MYSQL usercp error after server move and database backup... PLEASE HELP!

[[email protected]]

All users now get a similar error on our forums whenever attempting to use usercp...

PLEASE HELP!

Database error in vBulletin 3.0.8:
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 = 1
AND thread.visible = 1
AND lastpost > 1140021559
AND deletionlog.primaryid IS NULL
mysql error: Unknown column 'thread.threadid' in 'on clause'
mysql error number: 1054
Date: Wednesday 15th of February 2006 11:45:11 AM
Script: http://www.topshelfexotic.com/vbulletin/usercp.php?
Referer: xxxxxxxxxxxxxxxxxxxx
Username: xxxxxxxxx
IP Address: xxxxxxxxxxxx

[Steve Machol]

It would appear that the database was not correctly backed up and restored. Do you still have access to the old db?

[[email protected]]

yes i beleive I do, any particular method I should take to ensure it is done correctly?

also, everything else seems to be working flawlessly, is it possible it is something else??

thanks

[Steve Machol]

The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/m...nce_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/m...ce_ssh_restore

This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeout errors and an incomplete backup file.