Forum SQL DB Error when trying to Mark Forum As Open

محروم.كوم · #1 04-14-2010, 07:10 PM

Some Background:

vB4.0.3 WITH vBSEO 3.5 RC3

I have a forum on my site that contains a HTML rss feed and of course I do not want people to be able to post HTML to that section so I used the :

Forum is Open (Set this to 'No' to prevent any new posts being made in this forum) = NO

Anyway I'm trying to set that to YES to try and diagnose a different issue and I am getting the following SQL DB Error every time I try.

Following Error (I've taken out titles/descriptions/urls as I'm not confortable posting that in public just in case any hack attempt is possible due to this sql error)

Database error in vBulletin 4.0.3:

Invalid SQL:
UPDATE forum SET
title_clean = 'Blah',
title = 'Blah',
description_clean = 'Blah',
description = 'Blah',
link = '',
displayorder = 1,
parentid = 49,
daysprune = -1,
defaultsortfield = 'lastpost',
defaultsortorder = 'desc',
showprivate = 0,
newpostemail = '',
newthreademail = '',
### Bitfield: forum.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 16, options - 16, options),
options = IF(options & 32, options, options + 32),
options = IF(options & 32768, options - 32768, options),
options = IF(options & 8192, options, options + 8192),
options = IF(options & 4, options, options + 4),
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options, options + 2),
options = IF(options & 16384, options, options + 16384),
options = IF(options & 256, options, options + 256),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options, options + 128),
options = IF(options & 512, options, options + 512),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options, options + 4096),
options = IF(options & 65536, options, options + 65536),
options = IF(options & 131072, options - 131072, options),
styleid = 0,
imageprefix = '',
password = '',
vbseo_moderatepingbacks = 1,
vbseo_moderatetrackbacks = 1,
vbseo_moderaterefbacks = 1,
accessf_nb = 0,
accesst_nb = 0,
create_nb = 0,
reply_nb = 0,
linkview_nb = 0,
linkpost_nb = 0,
enable_recipe = '0'
WHERE forumid = 33;

MySQL Error : Unknown column 'accessf_nb' in 'field list'
Error Number : 1054
Request Date : Wednesday, April 14th 2010 @ 03:58:35 PM
Error Date : Wednesday, April 14th 2010 @ 03:58:35 PM
Script : http://www.mysite.com/forum/admincp/forum.php?do=update
Referrer : http://www.mysite.com/forum/admincp/...o=edit&f=33&s=

IP Address : 78.86.XXX.XXX
Username : Blah
Classname : vB_Database
MySQL Version : 5.0.45-log

PLEASE HELP! __DEFINE_LIKE_SHARE__