Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
  #1  
Old 12-11-2011, 06:47 PM
gazza2008 gazza2008 is offline
 
Join Date: Aug 2009
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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 12-11-2011, 08:20 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That is from a modification you installed. Either reinstall it correctly, or uninstall it correctly, in order to get rid of the error.
Reply With Quote
  #3  
Old 12-11-2011, 09:14 PM
gazza2008 gazza2008 is offline
 
Join Date: Aug 2009
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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 12-11-2011, 09:16 PM
HMBeaty's Avatar
HMBeaty HMBeaty is offline
 
Join Date: Sep 2005
Posts: 4,141
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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 [DATE]1323641851[/DATE] at [TIME]1323641851[/TIME] ---------------

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
Reply With Quote
  #5  
Old 12-11-2011, 10:37 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Uninstalling a modification means going through the complete install instructions backwards, not just uninstalling the product.
Reply With Quote
  #6  
Old 12-12-2011, 02:18 AM
Fready Fready is offline
 
Join Date: Nov 2010
Posts: 146
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.,
Reply With Quote
  #7  
Old 12-12-2011, 06:58 PM
gazza2008 gazza2008 is offline
 
Join Date: Aug 2009
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

cheers

found it and done it
Reply With Quote
Reply

Thread Tools
Display Modes

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

Forum Jump


All times are GMT. The time now is 12:52 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07296 seconds
  • Memory Usage 2,214KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete