vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Error Message? (https://vborg.vbsupport.ru/showthread.php?t=222577)

Madbatty 09-06-2009 12:06 PM

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!

Lynne 09-06-2009 03:45 PM

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.

Madbatty 09-06-2009 04:38 PM

Fu**ing Hell Lynne I love you bro *kiss* everything is working again !!!


All times are GMT. The time now is 02:15 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00988 seconds
  • Memory Usage 1,720KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete