Failed update to Beta 4, now 3.8.4 has bugs.

[servermin]

I had someone that I help with a vbulletin install try to go to beta without backing up the database. We just moved to a new server so haven't done a new backup myself, as I had the old server until just recently.

Anyway, there were problems and we are getting a few errors. Vbulletin is saying a reinstall, but there seems to have to be another way, since we can see all the posts and everything.

Looking for some options and ideas if anyone has any.

Here is what we are getting in the admin panel initial screen. All the other pages within it work. Below is when trying to edit large posts or go to some of them. The site is zefron.com/forum

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT SUM(filesize) AS size FROM attachment;

MySQL Error : Unknown column 'filesize' in 'field list'
Error Number : 1054
Request Date : Friday, December 11th 2009 @ 06:19:53 PM
Error Date : Friday, December 11th 2009 @ 06:19:53 PM
Script : http://www.zefron.com/forum/admincp/index.php?do=home
Referrer : http://www.zefron.com/forum/admincp/index.php
IP Address : 68.58.46.209
Username : Kathryn
Classname : vB_Database
MySQL Version : 5.0.85-community

Here is what we are getting in large threads or when we edit large threads

Database error in vBulletin 3.8.4:

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,6271951,6271966,6271998,6272038,6272085,6272152, 6272182,6272252,6272377)
ORDER BY attachmentid;

MySQL Error : Unknown column 'extension' in 'from clause'
Error Number : 1054
Request Date : Friday, December 11th 2009 @ 06:20:31 PM
Error Date : Friday, December 11th 2009 @ 06:20:31 PM
Script : http://www.zefron.com/forum/showthread.php?p=6272377
Referrer : http://www.zefron.com/forum/
IP Address : 68.58.46.209
Username : Kathryn
Classname : vB_Database
MySQL Version : 5.0.85-community