Database Error

[NeoION]

Hey,

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]

Run this query to recreate this table:

DROP TABLE IF EXISTS threadviews;
CREATE TABLE threadviews (
threadid INT UNSIGNED NOT NULL DEFAULT '0',
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:

http://www.vbulletin.com/forum/showthread.php?t=127027

For upgrade instructions, please see the online manual:

http://www.vbulletin.com/docs/html/upgrade/

And the the Upgrade FAQ here:

http://www.vbulletin.com/forum/showthread.php?t=124989

[NeoION]

Thanks for speedy reply

[NeoION]

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
Script: http://forums.clan-ion.com/login.php



Eeek!! what the hell have I done lol!