Can anyone help with this db error?

[Astra-SRi]

I have just moved servers, installed vb3.0.8 and had my database restored, but now the UserCP isn't working. It just gives this error:

____________________________________________________
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 > 1134669616
AND deletionlog.primaryid IS NULL

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

mysql error number: 1054

Date: Thursday 15th of December 2005 06:25:34 PM
Script: http://forums.astra-sri.co.uk/usercp.php?
Referer: http://forums.astra-sri.co.uk/online...e&pp=25&page=1
Username: RiK
IP Address: 82.38.194.200
____________________________________________________

Any help is much appriciated.

Thanks
Rik

[Floris]

What you did was the incorrect path to move from one server to another.

You have to move the files from the old server to the new server. Update the config.php file to point to the new database, and restore the old database.

Don't do a fresh installation first, and then restore the database. This will cause problems.

To fix this now, drop the current database, make sure the files you run are of the same version as on the old server. And restore the backup of the old database again. Update config.php and you're set. No need to run upgrade.php or install.php

That said, once everything works, I suggest to upgrade to 3.5.2.

[Astra-SRi]

Thanks for the help.

Unfortunately I didn't have the option to copy the files from my old server as their drives have failed and as yet no backups have been restored so it was a rush job to get set up on a new server.

[Floris]

If you were running 3.0.8, you can download the .zip from the members area and use those files. Just don't run install.php or upgrade.php, simply restore the database backup.sql

[Astra-SRi]

Hi,

I managed to get access to my old server, so I deleted vB from my host and dropped the db. Then I transferred all the files from my old server and imported my vbulletin.sql file, but I'm still getting the same error?

Any ideas?

Thanks

[Floris]

Why did you drop the database from the old server?

I hope you made a backup first, and then did a drop database?

[Astra-SRi]

Sorry, I meant I deleted the vB and dropped the db on my new server so I could start again. Copied all the files from my old server and uploaded the to the new one. But I'm using a 5 day old backup of the db as when my old host died they lost my db.

[Floris]

Here are our online manual instructions on how to restore a vBulletin database:

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

[Astra-SRi]

I have got the database restored and evrything works except the userCP which gives this error:
__________________________________________________ __
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 > 1134669616
AND deletionlog.primaryid IS NULL

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

mysql error number: 1054

Date: Thursday 15th of December 2005 06:25:34 PM
Script: http://forums.astra-sri.co.uk/usercp.php?
Referer: http://forums.astra-sri.co.uk/online...e&pp=25&page=1
Username: RiK
IP Address: 82.38.194.200
__________________________________________________

Thats what I need help fixing?

Any ideas?

[Astra-SRi]

Never mind. I've upgraded to 3.5.2 and all is now well.

[Carnage-]

out of interest what mysql version are you running, i just moved a forum from one server to another and got exactly the same problem. I did import the database correctly.