Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 09-06-2009, 12:06 PM
Madbatty Madbatty is offline
 
Join Date: Jun 2007
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Error Message?

I recieve the following error message when I try to updated a user group

Quote:
Database error in vBulletin 3.8.2:

Invalid SQL:
UPDATE vb_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Crew',
`description` = 'Design Group',
`usertitle` = '',
`opentag` = '<b><span style=\'color:Blue\'>',
`closetag` = '</span></b>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`forumpermissions` = '16777207',
`genericpermissions` = '2112749567',
`attachlimit` = '0',
`pmquota` = '200',
`pmpermissions` = '3',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '29',
`adminpermissions` = '1',
`genericpermissions2` = '1',
`genericoptions` = '56',
`profilepicmaxwidth` = '500',
`profilepicmaxheight` = '300',
`profilepicmaxsize` = '80000',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '30000',
`signaturepermissions` = '235775',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '300',
`sigpicmaxsize` = '0',
`sigmaxrawchars` = '500',
`sigmaxchars` = '300',
`sigmaxlines` = '3',
`sigmaxsizebbcode` = '5',
`sigmaximages` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '1024',
`albumpicmaxheight` = '1024',
`albumpicmaxsize` = '1000000',
`albummaxpics` = '120',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '47',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '80000',
`profileviewpermissions` = '0',
`fcpermissions` = '4',
`minpoststoplay` = '0',
`minreptoplay` = '-1000',
`minreglengthtoplay` = '0'
WHERE usergroupid=10;

MySQL Error : Unknown column 'profileviewpermissions' in 'field list'
Error Number : 14
Request Date : xxxxxxxxxxxxx
Error Date : xxxxxxxxxxxxx
Script : /admincp/usergroup.php?do=update
Referrer : /admincp/usergroup.php?do=edit&usergroupid=10
IP Address : xxxxxxxxxxxxxx
Username : xxxxxxxxxxxxxx
Classname : vB_Database
MySQL Version : 5.0.67-userstats-log
Can someone please tell me how to get rid of that? Thx!
Reply With Quote
  #2  
Old 09-06-2009, 03:45 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

There is no column profileviewpermissions in the usergroup table in default vbulletin. So, that is caused by a modification. You either didn't completely uninstall one (uninstall also means to remove all files you uploaded for the mod) or one of them is causing problems and you should disable it.
Reply With Quote
  #3  
Old 09-06-2009, 04:38 PM
Madbatty Madbatty is offline
 
Join Date: Jun 2007
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Fu**ing Hell Lynne I love you bro *kiss* everything is working again !!!
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 01:26 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.05028 seconds
  • Memory Usage 2,173KB
  • 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
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)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