Help!!!

lenney

New Member
while trying to upgrade i get this error
Database error in vBulletin 3.7.1:

Invalid SQL:
UPDATE usergroup SET
usercsspermissions = usercsspermissions |
IF(forumpermissions & 2, 32, 0),
forumpermissions = forumpermissions |
IF(forumpermissions & 4096, 8388608, 0),
genericoptions = genericoptions |
IF(usergroupid = 1,64, 0),
socialgrouppermissions = socialgrouppermissions |
IF(forumpermissions & 32, 512, 0) |
IF(adminpermissions & 1, 128, 0) |
IF(forumpermissions & 16, 1024, 0) |
IF(adminpermissions & 1, 2048, 0) |
IF(forumpermissions & 1024, 4096, 0) |
IF(forumpermissions & 512, 8192, 0) |
IF(genericpermissions & 128, 16384, 0) |
IF(genericpermissions & 134217728, 32768, 0),
groupiconmaxsize = profilepicmaxsize,
pmthrottlequantity = 0,
maximumsocialgroups = 5;

MySQL Error : Unknown column 'usercsspermissions' in 'field list'
 
Apparently when you uninstalled the Flashchat MOD you left stuff there, look in /includes/xml/

look for : bitfield_ms_wic_addon.xml and ms_wic_addon.xml

delete them
 
before upgrade closed ur forum
>> make new databse name with user previlages
>> copy ur database to new databse name from phpmyadmin
>> after that fix all data in admincp >>repair and maintenance >update counter after that repair and optimise
>> in update counter special forum information >thread information >>>smiliar thread >> and rebuild search index and if finish goto optimise and repair and fixing indexing
>> and go to upgrade ur version
>>> and for good disble all product bro
 
bluescorpion said:
Apparently when you uninstalled the Flashchat MOD you left stuff there, look in /includes/xml/

look for : bitfield_ms_wic_addon.xml and ms_wic_addon.xml

delete them

diddnt have them there

virus tried that no luck still

Database error in vBulletin 3.7.1:

Invalid SQL:
UPDATE usergroup SET
usercsspermissions = usercsspermissions |
IF(forumpermissions & 2, 32, 0),
forumpermissions = forumpermissions |
IF(forumpermissions & 4096, 8388608, 0),
genericoptions = genericoptions |
IF(usergroupid = 1,64, 0),
socialgrouppermissions = socialgrouppermissions |
IF(forumpermissions & 32, 512, 0) |
IF(adminpermissions & 1, 128, 0) |
IF(forumpermissions & 16, 1024, 0) |
IF(adminpermissions & 1, 2048, 0) |
IF(forumpermissions & 1024, 4096, 0) |
IF(forumpermissions & 512, 8192, 0) |
IF(genericpermissions & 128, 16384, 0) |
IF(genericpermissions & 134217728, 32768, 0),
groupiconmaxsize = profilepicmaxsize,
pmthrottlequantity = 0,
maximumsocialgroups = 5;

MySQL Error : Unknown column 'usercsspermissions' in 'field list'
Error Number : 1054
Request Date : Saturday, May 9th 2009 @ 08:53:34 AM
Error Date : Saturday, May 9th 2009 @ 08:53:34 AM
 
Back
Top