SQL Error

[vinceg]

Hi All

Tried vB support who refuse to help as it's '3rd party'..
I moved site to a new server but keep getting DB errors when I change 'registered users' on 'Show Leaders'

SQL ERROR:
Database error in vBulletin 4.2.4 Beta 1:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'BMAA',
`description` = 'Able to view the BMAA section',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '1',
`canoverride` = '0',
`vbblog_general_permissions` = '0',
`vbblog_customblocks` = '0',
`vbblog_custompages` = '0',
`vbblog_entry_permissions` = '40044',
`vbblog_comment_permissions` = '2974',
`forumpermissions` = '783359',
`genericpermissions` = '203953795',
`attachlimit` = '1000000',
`pmquota` = '0',
`pmpermissions` = '0',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '5',
`genericoptions` = '40',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '25000',
`avatarmaxwidth` = '50',
`avatarmaxheight` = '50',
`avatarmaxsize` = '20000',
`signaturepermissions` = '499711',
`sigpicmaxwidth` = '0',
`sigpicmaxheight` = '0',
`sigpicmaxsize` = '0',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`sigmaxvideos` = '0',
`albumpermissions` = '159',
`albumpicmaxwidth` = '0',
`albumpicmaxheight` = '0',
`albummaxpics` = '0',
`albummaxsize` = '0',
`usercsspermissions` = '0',
`visitormessagepermissions` = '0',
`socialgrouppermissions` = '124735',
`maximumsocialgroups` = '0',
`groupiconmaxsize` = '0',
`awardpermissions` = '0',
`akvbghsfs_akismet_permissions` = '0'
WHERE usergroupid=44;

MySQL Error : Unknown column 'akvbghsfs_akismet_permissions' in 'field list'
Error Number : 1054
Request Date : Tuesday, June 14th 2016 @ 04:37:46 PM
Error Date : Tuesday, June 14th 2016 @ 04:37:46 PM
Script : http://www.microlightforum.com/admin....php?do=update
Referrer : http://www.microlightforum.com/admin...usergroupid=44
IP Address : 86.19.105.128
Username : Brucey
Classname : vB_Database
MySQL Version : 10.0.25-MariaDB


I have no akismet plugin, when I disable plugin manager error still happens.

Thanks in advance.

[MarkFL]

I would guess your file "admincp/update.php" has been altered. Try replacing it with the original.

[squidsk]

It actually looks like there's an bitfiled_XXX.xml file in the includes/xml directory that is being read that shouldn't be there which is adding extra-bitfields to your site but that doesn't actually have a corresponding column in the usergroup table. Based on the fields that you have there should only be three bitfield files.

bitfield_vbulletin.xml
bitfield_vbblog.xml
bitfield_awards.xml

The first two are for the vbulletin forums (i.e. the main bitfield file), and vbulletin blogs which adds a few bitfields, and the third goes with your awards_permissions field and is from the Yet Another Awards System.

[vinceg]

Originally Posted by squidsk

It actually looks like there's an bitfiled_XXX.xml file in the includes/xml directory that is being read that shouldn't be there which is adding extra-bitfields to your site but that doesn't actually have a corresponding column in the usergroup table. Based on the fields that you have there should only be three bitfield files.

bitfield_vbulletin.xml
bitfield_vbblog.xml
bitfield_awards.xml

The first two are for the vbulletin forums (i.e. the main bitfield file), and vbulletin blogs which adds a few bitfields, and the third goes with your awards_permissions field and is from the Yet Another Awards System.

Bloody star, that's the ticket!

Thank you