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

[snakes1100]

I'd ask this 1st, why are you trying to run a BETA version on a live production site?

It's called a BETA for a reason.

If the columns are missing, i would view the upgrade php files starting with the one after your old version 3.8.4, view each php upgrade script from that point on in a editor and search for those keywords, see what queries were supposed to be run and compare them to your db, most likely 1/2 of the upgrade queries weren't ran.

[servermin]

They did it without my knowledge. I wondered the same thing

What you describes seems above what I know how to do. I was just posting tonsee if there was something that could save the site. I didn't know if anyone would mind trying to try this if people think this would work. Thanks!

[snakes1100]

There is no reason it can't be saved, the errors appear to be simply missing columns in the table.

I assume you also inspected the currently upload php files and they are all for the beta version and not for 3.8.4?

Did you check the two tables above and confirm that those tables don't actually exist?

[Lynne]

They might have put the vB4 files on the server, but they didn't run the upgrade.php file because you can see the database has not been upgraded at all (it says 3.8.4).

[servermin]

They ran the upgrade then went back to 3.8.4. Would that be why?

[Paul M]

What exactly do you mean by "then went back to 3.8.4" ?

[servermin]

She said she tried the upgrade and it failed so ran the 3.8.4 install again.

[Lynne]

You can't do that. The database won't suddenly downgrade to 3.8.4 again. Either she ran the upgrade and the database was changed, or she didn't run it and the database was left as a 3.8.4 database. Or, and I'm not sure about this, she started to run it and only some of the database was changed except the version number was not yet changed.

[servermin]

Snakes 1100 is going to take a look at it. Thanks for all the ideas. We'll post results here, for future problems with others.