Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 11 Dec 2011, 19:47
gazza2008 gazza2008 is offline
 
Join Date: Aug 2009
DB error

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
Reply With Quote
  #2  
Old 11 Dec 2011, 21:20
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
That is from a modification you installed. Either reinstall it correctly, or uninstall it correctly, in order to get rid of the error.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #3  
Old 11 Dec 2011, 22:14
gazza2008 gazza2008 is offline
 
Join Date: Aug 2009
Originally Posted by Lynne View Post
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
Reply With Quote
  #4  
Old 11 Dec 2011, 22:16
HMBeaty's Avatar
HMBeaty HMBeaty is offline
 
Join Date: Sep 2005
Real name: Brooks
Originally Posted by gazza2008 View Post
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
__________________
"Our greatest weakness lies in giving up. The most certain way to succeed is always to try just one more time!"
"It's important to only think about what you desire, not what you fear to achieve your ultimate goal!!
Reply With Quote
  #5  
Old 11 Dec 2011, 23:37
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Uninstalling a modification means going through the complete install instructions backwards, not just uninstalling the product.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #6  
Old 12 Dec 2011, 03:18
Fready Fready is offline
 
Join Date: Nov 2010
Do what the above said,
The error is here, easy to see;
MySQL Error : Unknown column 'akvbghsfs_akismet_permissions' in 'field list'
Which shows it's to do with this file
akvbghsfs_akismet_permissions'
which is a modification, search for the file in your cPanel and delete it.,
Reply With Quote
  #7  
Old 12 Dec 2011, 19:58
gazza2008 gazza2008 is offline
 
Join Date: Aug 2009
cheers

found it and done it
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 12:39.

Layout Options | Width: Wide Color: