Database error

[Blueracer66]

Whenever I try to update a user group I get the following database error:

Database error in vBulletin 3.8.6:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Moderators',
	`description` = 'Moderators keep the community going!',
	`usertitle` = 'Moderator',
	`opentag` = '<strong> <span style=\"font: candara; verdana; color: #ff7800;\">',
	`closetag` = '</span></strong>',
	`passwordexpires` = '0',
	`passwordhistory` = '0',
	`forumpermissions` = '16515071',
	`genericpermissions` = '1577000655',
	`attachlimit` = '0',
	`pmquota` = '150',
	`pmpermissions` = '7',
	`pmsendmax` = '10',
	`pmthrottlequantity` = '0',
	`calendarpermissions` = '63',
	`wolpermissions` = '13',
	`adminpermissions` = '0',
	`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` = '650',
	`albumpicmaxheight` = '650',
	`albumpicmaxsize` = '100000',
	`albummaxpics` = '100',
	`albummaxsize` = '0',
	`usercsspermissions` = '63',
	`visitormessagepermissions` = '63',
	`socialgrouppermissions` = '59263',
	`maximumsocialgroups` = '5',
	`groupiconmaxsize` = '65535',
	`awardpermissions` = '1',
	`akvbghsfs_akismet_permissions` = '1'
WHERE usergroupid=7;

MySQL Error   : Unknown column 'akvbghsfs_akismet_permissions' in 'field list'
Error Number  : 1054
Request Date  : Sunday, September 26th 2010 @ 10:40:05 PM
Error Date    : Sunday, September 26th 2010 @ 10:40:05 PM
Script        : http://allconsolegamers.com/community/admincp/usergroup.php?do=update
Referrer      : http://allconsolegamers.com/community/admincp/usergroup.php?do=edit&usergroupid=7
IP Address    : 00.11.222.33
Username      : Blueracer66
Classname     : vB_Database
MySQL Version : 5.1.47-community-log

Any ideas how to fix this? Thank you!

[Trevor Hannant]

There's no '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.

[Blueracer66]

Thanks buddy that worked! I had to delete the file on the XML directory (found in the includes folder). I also manually removed the 'akismet_permissions' column through MyPHPAdmin.

[yahsuah]

Thanks buddy that worked! I had to delete the file on the XML directory (found in the includes folder). I also manually removed the 'akismet_permissions' column through MyPHPAdmin.

How can I do this via phpmyadmin? I have experiencing same problem.

[Trevor Hannant]

Firstly and most importantly, take a full backup of your database before making any "destructive" changes to it!

Next, in that table in phpMyAdmin, open the 'usergroup' table and click on the 'Structure' tab'. Then, check the tickbox beside 'akismet_permissions' and ONLY that line then click 'Drop' underneath the column listing.

You'll be asked to confirm the drop with something like this:

Do you really want to execute the following query?

ALTER TABLE `usergroup`
DROP `akismet_permissions`;

Provided it only says about dropping that column, hit 'Yes'

[Paul M]

You do not need to drop the column and unless you know exactly what you are doing, you should leave it alone.

Extra [unused] columns do not do any harm.

The original error was because someone HAD dropped the column, but they left some files in that meant it was still needed.