Thread: Miscellaneous Hacks - Ultimate Side Columns
View Single Post
  #484  
Old 11-17-2008, 10:06 PM
Alex LD Alex LD is offline
 
Join Date: Aug 2008
Location: Iowa
Posts: 68
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

There must be a bug, I was getting the following message when attempting to edit a usergroup may way to try to fix. Though I've gotten the issue resolved by simply removing the addon I'm sure others will experience this aswell The Error is below.
PHP Code:
Invalid SQL:
UPDATE vbusergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`
description` = '',
`
usertitle` = '',
`
opentag` = '',
`
closetag` = '',
`
passwordexpires` = '0',
`
passwordhistory` = '0',
`
vbtube` = '15',
`
uscpermissions` = '0',
`
forumpermissions` = '3928575',
`
genericpermissions` = '1579685063',
`
attachlimit` = '0',
`
pmquota` = '45',
`
pmpermissions` = '3',
`
pmsendmax` = '5',
`
calendarpermissions` = '63',
`
wolpermissions` = '1',
`
adminpermissions` = '0',
`
genericpermissions2` = '1',
`
genericoptions` = '62',
`
profilepicmaxwidth` = '100',
`
profilepicmaxheight` = '100',
`
profilepicmaxsize` = '65535',
`
avatarmaxwidth` = '100',
`
avatarmaxheight` = '100',
`
avatarmaxsize` = '20000',
`
signaturepermissions` = '235519',
`
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` = '31',
`
visitormessagepermissions` = '63',
`
socialgrouppermissions` = '375'
WHERE usergroupid=2;

MySQL Error Unknown column 'uscpermissions' in 'field list' 
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01252 seconds
  • Memory Usage 1,793KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete