vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=275343

DB error
by gazza2008
11 Dec 2011 19:47

I am getting a DB error whsn I try and update a usergroup permissions

here is the DB error

Database error in vBulletin 4.1.8:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Junior Admin',
`description` = '',
`usertitle` = '<span style=\"color: dark red ;\">Distinguished members</span>',
`opentag` = '<span style=\"color: dark red; text-shadow: Purple 1px 1px 10px;\"><strong>',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '1',
`canoverride` = '1',
`dbtech_statuspermissions` = '54',
`dbtech_vbshoutpermissions` = '2',
`akvbghsfs_akismet_permissions` = '0',
`forumpermissions` = '16777215',
`genericpermissions` = '2147221467',
`attachlimit` = '1000000',
`pmquota` = '100',
`pmpermissions` = '7',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '31',
`wolpermissions` = '31',
`adminpermissions` = '2',
`genericpermissions2` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '25000',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '30000',
`signaturepermissions` = '245755',
`sigpicmaxwidth` = '0',
`sigpicmaxheight` = '0',
`sigpicmaxsize` = '0',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '1',
`albumpermissions` = '255',
`albumpicmaxwidth` = '0',
`albumpicmaxheight` = '0',
`albummaxpics` = '0',
`albummaxsize` = '0',
`usercsspermissions` = '191',
`visitormessagepermissions` = '15',
`socialgrouppermissions` = '262143',
`maximumsocialgroups` = '0',
`groupiconmaxsize` = '0',
`usmlsaperms` = '15',
`staffappminpostreq` = '10',
`staffappminrepreq` = '0',
`staffappminregreq` = '0',
`arcadepermissions` = '255',
`minpoststoplay` = '0',
`minreptoplay` = '-1000',
`minreglengthtoplay` = '0',
`arcadetourperms` = '15'
WHERE usergroupid=11;

MySQL Error : Unknown column 'akvbghsfs_akismet_permissions' in 'field list'
Error Number : 1054
Request Date : Sunday, December 11th 2011 @ 06:50:49 PM
Error Date : Sunday, December 11th 2011 @ 06:50:49 PM
Script : http://www.cardsharing-chat.info/adm....php?do=update
Referrer : http://www.cardsharing-chat.info/adm...usergroupid=11



Anyone got any ideas

Cheers

gaz

Lynne 11 Dec 2011 21:20

That is from a modification you installed. Either reinstall it correctly, or uninstall it correctly, in order to get rid of the error.

gazza2008 11 Dec 2011 22:14

Quote:

Originally Posted by Lynne (Post 2276850)
That is from a modification you installed. Either reinstall it correctly, or uninstall it correctly, in order to get rid of the error.

I dont know which mod it is

When I try and disable all mods in config.php I still get same error

HMBeaty 11 Dec 2011 22:16

Quote:

Originally Posted by gazza2008 (Post 2276877)
I dont know which mod it is

When I try and disable all mods in config.php I still get same error

It's the GlowHost Spam-O-Matic mod

--------------- Added 11 Dec 2011 at 22:17 ---------------

More than likely, you installed it before, then uninstalled it, but left the files in place. More specifically, the file in the includes/xml/ directory

Lynne 11 Dec 2011 23:37

Uninstalling a modification means going through the complete install instructions backwards, not just uninstalling the product.

Fready 12 Dec 2011 03:18

Do what the above said,
The error is here, easy to see;
Quote:

MySQL Error : Unknown column 'akvbghsfs_akismet_permissions' in 'field list'
Which shows it's to do with this file
Quote:

akvbghsfs_akismet_permissions'
which is a modification, search for the file in your cPanel and delete it.,

gazza2008 12 Dec 2011 19:58

cheers

found it and done it


All times are GMT. The time now is 11:58.

Powered by vBulletin® Version 3.8.14
Copyright © 2020, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.