[Forum] Database error after 4.0.3 Upgrade

[Ironman24]

I recently upgraded from 3.6.4 to 4.0.3 and the forums themselves seem to be working OK after the upgrade however I am having some errors in the admin cp.

I receive this database error:

Database error in vBulletin 4.0.3:
Invalid SQL:
SELECT COUNT(*) AS count
FROM attachment AS attachment
INNER JOIN post AS post USING (postid)
WHERE attachment.visible = 0;
MySQL Error : Unknown column 'attachment.visible' in 'where clause'
Error Number : 1054
Request Date : Monday, June 7th 2010 @ 10:05:08 AM
Error Date : Monday, June 7th 2010 @ 10:05:08 AM
Script : http://www.carolinafbodyclub.com/for...ex.php?do=home
Referrer : http://www.carolinafbodyclub.com/forums/admin/index.php
IP Address : 24.163.48.199
Username : sxappeal
Classname : vB_Database
MySQL Version : 4.1.22-standard

I have done some searching and can't find a solution. I have no mods or plugins installed and I am using the default template, which I also tried creating a new default template.

I repaired/optimized the tables in the database and they all show OK.

I am also having problems rebuilding the threads and forums. I receive a Access denied message.

Any suggestions?

Thanks!

Michael

[Zachery]

Make sure you've uploaded all of the 4.0.3 files over your old vBulletin 3.x files.

[mgcom]

I have the same problem - do you need to delete all the old vb3 files/mods/stlyes etc ?

[Zachery]

I have the same problem - do you need to delete all the old vb3 files/mods/stlyes etc ?

No, please start your own thread with your own information.

[Videx]

I have the same problem - do you need to delete all the old vb3 files/mods/stlyes etc ?

You should uninstall all your mods, not forgetting to delete the files you manually uploaded. They won't work in vb4 anyway, and can cause really odd problems.