Forum Downgrading Problems
 

Hello.

I installed 4.0.2 but it was a right pig's ear and try as I might I just couldn't get it to work. So I deleted it all and put a backup I made of our previous version (3.8.5) but it seems to be stuck somewhere inbetween.

The admin area says we're on 3.8.5 but I keep getting a load of database errors (one on the admin area home page itself, most of the others in large threads). Any ideas how to do a proper downgrade? I know its not supported by vB themselves but I just want a stable forum back!

I do have database backups (one from before the upgrade and one after it). Should I try and put those back in, and if so how? There's no way through vB is there? Our site is hosted by a bigger company so should I send them the database and ask them to do it?

The database error says (one example from a particular thread, but they're all pretty similar):

Quote:
Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT dateline, thumbnail_dateline, filename, filesize, visible, attachmentid, counter,
postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize,
attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow
FROM attachment
LEFT JOIN attachmenttype AS attachmenttype USING (extension)
WHERE postid IN (-1,1140447)
ORDER BY attachmentid;

MySQL Error : Unknown column 'extension' in 'from clause'
Error Number : 1054
Request Date : Monday, March 22nd 2010 @ 03:46:02 PM
Error Date : Monday, March 22nd 2010 @ 03:46:02 PM
Script : http://www.n-europe.com/forum/showth...18182&page=383
Referrer : http://www.n-europe.com/forum/forumdisplay.php?f=10
IP Address : 80.195.241.83
Username : Ashley
Classname : vB_Database
MySQL Version : 5.1.31

Thanks in advance.