makemedie
04-09-2006, 11:11 AM
Hi,
Unfortunately an administrator from our forum went evil on us, and he deleted the entire content of our forums (basically, the forums folder). Fortunately though, one of us had a backup saved about 2 weeks prior to this. Anyways, long story.
So, we're setting it up somewhere else, on a different host. I asked my host to run Telnet and restore the SQL file (it was 22MB), and they did it for me. First problem here, the board was previously running vBulletin 3.5.3, and I had to install a blank forum before restoring the database. I didnt think and straight away downloaded vBulletin 3.5.4 and restored the database ontop of that. Now, the Admin panel shows stuff as vBulletin 3.5.3 while if I check for file version conflicts (I think it's in the Maintenance section) it shows all files as being from a different version :\
That's not really a problem though. The problem is, the forum index loads fine, but if I click on any thread, or try using any function (like search), it gives me a database error. Something like this -
Database error in vBulletin 3.5.3:
Invalid SQL:
SELECT IF(visible = 2, 1, 0) AS isdeleted,
NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, emailupdate, folderid,threadrate.vote,
thread.*
FROM thread AS thread
LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 3 AND canview = 1)
LEFT JOIN threadrate AS threadrate ON (threadrate.threadid = thread.threadid AND threadrate.userid = 3)
WHERE thread.threadid = 5775;
MySQL Error : Unknown column 'canview' in 'on clause'
Error Number : 1054
If anyone can help me by telling me what I did wrong, please do. Or, if there's a way to just save threads, posts and members, and to start fresh, please advise me on how to do that instead.
Any help's appreciated, I dont really know my way around that much with vB to solve this on my own :\
Cheers.
Nevermind, I'm a real daredevil :p I tried running the upgrade script, fixed everything.
Cheers heh.
Unfortunately an administrator from our forum went evil on us, and he deleted the entire content of our forums (basically, the forums folder). Fortunately though, one of us had a backup saved about 2 weeks prior to this. Anyways, long story.
So, we're setting it up somewhere else, on a different host. I asked my host to run Telnet and restore the SQL file (it was 22MB), and they did it for me. First problem here, the board was previously running vBulletin 3.5.3, and I had to install a blank forum before restoring the database. I didnt think and straight away downloaded vBulletin 3.5.4 and restored the database ontop of that. Now, the Admin panel shows stuff as vBulletin 3.5.3 while if I check for file version conflicts (I think it's in the Maintenance section) it shows all files as being from a different version :\
That's not really a problem though. The problem is, the forum index loads fine, but if I click on any thread, or try using any function (like search), it gives me a database error. Something like this -
Database error in vBulletin 3.5.3:
Invalid SQL:
SELECT IF(visible = 2, 1, 0) AS isdeleted,
NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, emailupdate, folderid,threadrate.vote,
thread.*
FROM thread AS thread
LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 3 AND canview = 1)
LEFT JOIN threadrate AS threadrate ON (threadrate.threadid = thread.threadid AND threadrate.userid = 3)
WHERE thread.threadid = 5775;
MySQL Error : Unknown column 'canview' in 'on clause'
Error Number : 1054
If anyone can help me by telling me what I did wrong, please do. Or, if there's a way to just save threads, posts and members, and to start fresh, please advise me on how to do that instead.
Any help's appreciated, I dont really know my way around that much with vB to solve this on my own :\
Cheers.
Nevermind, I'm a real daredevil :p I tried running the upgrade script, fixed everything.
Cheers heh.