Moved servers, now I'm getting a MySQL error :(

[CheeseFrog]

The forum looks normal, until I try to post anything. Then I get an error sent to my inbox reading:

Invalid SQL:
                                REPLACE INTO postindex
                                (wordid, postid, score, intitle)
                                VALUES
                                 (17507, 181116, 1, 0)

mysql error: Table 'forum.postindex' doesn't exist

mysql error number: 1146

I tried searching for this, but came up empty. Can anybody shed some light on this one? I'm not very MySQL savvy, so dumb it down a notch or two Thanks!

[dodgeboard.com]

It means you are missing your postindex table. Do you know how to look into your database via cpanel/phpmyadmin ?

[CheeseFrog]

I know how to poke around in there, but I don't know what I'm doing :-/

[dodgeboard.com]

Did your host move the account/system for you?

[CheeseFrog]

I backed up the the db to a .sql file locally, which I then FTP'd up to the new server. Unfortunately I don't have access to the old server. The new host then took that sql file and created a new db with it. Mostly the same parameters except for the hostname in config.php... oh and the admin name was change too. But the db name stayed the same.

[veenuisthebest]

See if you have postindex table in database or not.

Try Rebuilding Search Index in Maintenance -> Update Counters.

[CheeseFrog]

See if you have postindex table in database or not.

Try Rebuilding Search Index in Maintenance -> Update Counters.

Doing that now.. wow, this is taking a while. It's been going for the last 35-40 minutes.

[CheeseFrog]

How long should this take? It's been going for a few hours now. 180,000 and climbing...

[Steve Machol]

It really depends on the server. As long as it's progressing then it's still working on it.

[CheeseFrog]

Well son of a gun... That did the trick! Thanks veenuisthebest!!!

[CheeseFrog]

Maybe I spoke too soon. The forum itself seems to work. But whenever I go to User CP, I get the following error:

Database error in vBulletin 3.0.3:

Invalid SQL: 
    SELECT thread.threadid, thread.forumid
    FROM thread AS thread, subscribethread AS subscribethread
    LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND type = 'thread')
    WHERE subscribethread.threadid = thread.threadid
    AND subscribethread.userid = 2
    AND thread.visible = 1
    AND lastpost > 1254249703
    AND deletionlog.primaryid IS NULL

mysql error: Unknown column 'thread.threadid' in 'on clause'

mysql error number: 1054

Does anybody have any ideas on this one?

[Steve Machol]

You need to upgrade vB. That error is from incompatibilities between that ancient version of vB and your newer versions of PHP and MySQL.