Database Error

  • Time
  • Show
Clear All
new posts
  • NeoION
    New Member
    • Jun 2002
    • 13

    Database Error


    I have recently moved my forums to another host, everything appears to be working ok but I got an email saying this:

    "Database error in vBulletin 3.0.0 Gamma:

    Invalid SQL: SELECT threadid , COUNT(*) AS views FROM threadviews GROUP BY threadid mysql error: Table 'clanion_vbforums.threadviews' doesn't exist

    mysql error number: 1146"

    Anyone got any ideas?
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    Run this query to recreate this table:

    DROP TABLE IF EXISTS threadviews;
    CREATE TABLE threadviews (
    KEY threadid (threadid)

    Also I strongly recommend that you upgrade to 3.0.6 as soon as possible, Not only do we no longer provde support for pre-releasse versions, but you need to upgrade to fix a number of bugs and security holes. Here is the Announcement:

    vBulletin 3.0.6 and 2.3.6 vBulletin 3.0.6 and 2.3.6 are security and bug fix releases. They fix a recently discovered XSS issue regarding BB code parsing. All versions of vBulletin prior to 3.0.6 and 2.3.6 are vulnerable. The only workaround is to disable BB code parsing in signatures and all forums where untrusted users

    For upgrade instructions, please see the online manual:

    And the the Upgrade FAQ here:

    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    • NeoION
      New Member
      • Jun 2002
      • 13

      Thanks for speedy reply


      • NeoION
        New Member
        • Jun 2002
        • 13

        Hey again, I took your advice and am tryin to upgrade the forums. I have hit two walls

        When I try to goto the /install/upgrade.php file it jumps to upgrade7.php and displays a screen like the one attached.. :|

        I dunno if this is related but I tried to login to the admincp after and it caused a sql error sayin:

        Database error in vBulletin 3.0.0 Gamma:

        Invalid SQL: INSERT INTO cpsession (userid, hash, dateline) VALUES (1, '483d91616cdf3b665f411382ee2a1089', 1107464052)
        mysql error: Table 'clanion_vbforums.cpsession' doesn't exist

        mysql error number: 1146

        Date: Thursday 03rd of February 2005 08:54:12 PM

        Eeek!! what the hell have I done lol!
        Attached Files


        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.