PDA

View Full Version : Vbulletin error on fresh install!


rockerzteam
09-06-2016, 03:18 AM
Database error in vBulletin 3.8.7:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Elite Member',
`description` = 'Elite Member Donator!',
`usertitle` = 'Elite Member',
`opentag` = '<span style=\"color: red;\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '12316927',
`genericpermissions` = '1575966447',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '0',
`pmsendmax` = '0',
`pmthrottlequantity` = '0',
`calendarpermissions` = '55',
`wolpermissions` = '13',
`adminpermissions` = '1',
`genericpermissions2` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '55',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`akvbghsfs_akismet_permissions` = '0'
WHERE usergroupid=5;

MySQL Error : Unknown column 'akvbghsfs_akismet_permissions' in 'field list'
Error Number : 1054
Request Date : Tuesday, September 6th 2016 @ 12:15:18 AM
Error Date : Tuesday, September 6th 2016 @ 12:15:18 AM

Sarah.
09-06-2016, 10:11 AM
There's no 'akvbghsfs_akismet_permissions' column in a default vBulletin install - this comes from a modification.

If you've removed a modification that dealt with this, make sure you've deleted all it's files (including XML files) and retry.

RichieBoy67
09-08-2016, 07:58 AM
Database error in vBulletin 3.8.7:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Elite Member',
`description` = 'Elite Member Donator!',
`usertitle` = 'Elite Member',
`opentag` = '<span style=\"color: red;\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '12316927',
`genericpermissions` = '1575966447',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '0',
`pmsendmax` = '0',
`pmthrottlequantity` = '0',
`calendarpermissions` = '55',
`wolpermissions` = '13',
`adminpermissions` = '1',
`genericpermissions2` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '55',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`akvbghsfs_akismet_permissions` = '0'
WHERE usergroupid=5;

MySQL Error : Unknown column 'akvbghsfs_akismet_permissions' in 'field list'
Error Number : 1054
Request Date : Tuesday, September 6th 2016 @ 12:15:18 AM
Error Date : Tuesday, September 6th 2016 @ 12:15:18 AM

Sure does not seem like a fresh install.

If you have plug ins partially installed then reupload the files, uninstall the plug in using the plug in manager and then delete the files.