MySQL Error : Unknown column 'allowhtml' in 'field list'

[jgommel]

Hello, I just tried to upgrade my site from 3.5.5 to 3.6.0, but started to get the following error.... Any Suggestions?

I searched the forum before asking this question - hopfully I didn't miss the answer in another thread.

--------------------------------------
Database error in vBulletin 3.6.0:

Invalid SQL:

SELECT announcementid, startdate, title, announcement.views, forumid, enddate, pagetext, allowhtml, allowbbcode, allowsmilies,
user.username, user.userid, user.usertitle, user.customtitle
FROM vb_announcement AS announcement
LEFT JOIN vb_user AS user ON(user.userid = announcement.userid)
WHERE startdate <= 1155678431
AND enddate >= 1155678431
AND forumid IN (18,-1)
ORDER BY startdate DESC
LIMIT 3;

MySQL Error : Unknown column 'allowhtml' in 'field list'
Error Number : 1054
--------------------------------------

Thanks,
James

[Colin F]

That looks as if you were using vBulletin 3.5.4 files with vBulletin 3.6.0
Reupload all the 3.5.5 files.

[jgommel]

After uploading all the 3.5.5 files again, will I need to also reupload all the 3.6.0 files and re-run the upgrade.php?

Thanks,
James

[jgommel]

Still getting the same error... not sure what else to do?

[Colin F]

You will need to upload the 3.6.0 files, but not run upgrade.php

[jgommel]

Okay - did that - still getting the same error...

--------------------------------------
Database error in vBulletin 3.6.0:

Invalid SQL:

SELECT announcementid, startdate, title, announcement.views, forumid, enddate, pagetext, allowhtml, allowbbcode, allowsmilies,
user.username, user.userid, user.usertitle, user.customtitle
FROM vb_announcement AS announcement
LEFT JOIN vb_user AS user ON(user.userid = announcement.userid)
WHERE startdate <= 1155689386
AND enddate >= 1155689386
AND forumid IN (18,-1)
ORDER BY startdate DESC
LIMIT 3;

MySQL Error : Unknown column 'allowhtml' in 'field list'
Error Number : 1054
--------------------------------------

[Steve Machol]

There is no 'allowhtml' field in the 3.6.0 announcement or user tables. This has to be from a code change you've made either to the files or with a plugin.

Reupload the original 3.6.0 files and dissable your plugins.