Upgrade 3.8 to 4

[BlueRad]

I'm upgrading from 3.8.6 to 4.0.5 and running into errors.

First was a table called contenttype which didn't exist but claimed it did when I tried to make it.
I got that fixed with a simple drop and create.

Now I've hit a problem I'm not sure how to solve.

Step 6) Attachment System Alterations (3/5)
Database Error

Database error in vBulletin 3.8.6:

Invalid SQL:

			SELECT attachmentid, postid, userid, dateline, visible, counter, filename
			FROM filedata
			WHERE attachmentid > 0
			ORDER BY attachmentid ASC
			LIMIT 0, 100;

MySQL Error   : Unknown column 'postid' in 'field list'
Error Number  : 1054
Request Date  : Thursday, August 5th 2010 @ 03:05:51 PM
Error Date    : Thursday, August 5th 2010 @ 03:05:51 PM
Script        : http://blu-ops.com/forum/install/upgrade_400a1.php?step=6
Referrer      : http://blu-ops.com/forum/install/upgrade_400a1.php?step=5
IP Address    : 76.66.24.205
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.91-community

Anyone got a quick fix?

[Lynne]

Notice the top of the database error:

Database error in vBulletin 3.8.6:

It still thinks you are running 3.8.6 like it was never upgraded to 4.0.5. Did you run the upgrade script finally to completion? The database error where it talks about the postid column is an old pre-4.x column which was dropped in 4.0. So, if your files are 4.x files, then that error is caused by a modification.

[Videx]

None of your old mods will work in vb4, so remove those before you try to upgrade if you really want to avoid trouble. I don't mean just hit the 'uninstall' button. I mean read the install instructions and remove any files you uploaded and edits you made.

[BlueRad]

Originally Posted by Lynne

Notice the top of the database error:

Database error in vBulletin 3.8.6:

It still thinks you are running 3.8.6 like it was never upgraded to 4.0.5. Did you run the upgrade script finally to completion? The database error where it talks about the postid column is an old pre-4.x column which was dropped in 4.0. So, if your files are 4.x files, then that error is caused by a modification.

I'm mid upgrade right now, that occurred on step 6.

I'll try the uninstall now.