PDA

View Full Version : Query error on update usergroup


Fuhrmann
06-20-2010, 04:21 AM
Well, i am getting this error:

Database error in vBulletin 4.0.3:

Invalid SQL:
UPDATE vb_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Membros VIP',
`description` = 'Grupo dos membros VIP qua ajudam o PFPS',
`usertitle` = '',
`opentag` = '<span style=\"color: #68be67;\"><b>',
`closetag` = '</b></span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`solvedthread_permissions` = '0',
`dbtech_thankspermissions` = '3',
`awardpermissions` = '2',
`usernamechangepermissions` = '13',
`dbtech_username_changedelay` = '20',
`dbtech_username_historylimit` = '50',
`dbtech_username_numchanges` = '100',
`downloads2permissions` = '2631935',
`downloads2extrapermissions` = '2',
`excludecatlist` = '',
`downloadsmaxuploadtotal` = '300',
`downloadsmaxdailydl` = '-1',
`downloadsmaxdailyfiles` = '-1',
`downloaddelaygrp` = '30',
`vbblog_general_permissions` = '523514',
`vbblog_customblocks` = '4',
`vbblog_custompages` = '4',
`vbblog_entry_permissions` = '24575',
`vbblog_comment_permissions` = '990',
`medialibperms` = '63',
`medialibmodperms` = '0',
`ms_imageshack_upload_permissions` = '0',
`microsupport` = '7',
`supportpriority` = '0',
`tournamentpermissions` = '19',
`maxteams` = '1',
`ladderpermissions` = '1',
`forumpermissions` = '16766463',
`genericpermissions` = '1588248199',
`attachlimit` = '2097152',
`pmquota` = '300',
`pmpermissions` = '1',
`pmsendmax` = '10',
`pmthrottlequantity` = '100',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '200',
`profilepicmaxheight` = '300',
`profilepicmaxsize` = '419430',
`avatarmaxwidth` = '180',
`avatarmaxheight` = '220',
`avatarmaxsize` = '419430',
`signaturepermissions` = '235611',
`sigpicmaxwidth` = '700',
`sigpicmaxheight` = '210',
`sigpicmaxsize` = '419430',
`sigmaxrawchars` = '300',
`sigmaxchars` = '300',
`sigmaxlines` = '3',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '1',
`albumpermissions` = '255',
`albumpicmaxwidth` = '500',
`albumpicmaxheight` = '500',
`albummaxpics` = '100',
`albummaxsize` = '419430',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '259967',
`maximumsocialgroups` = '2',
`groupiconmaxsize` = '65535'
WHERE usergroupid=9;

MySQL Error : Unknown column 'ms_imageshack_upload_permissions' in 'field list'
Error Number : 1054
Request Date : Sunday, June 20th 2010 @ 02:16:12 AM
Error Date : Sunday, June 20th 2010 @ 02:16:12 AM
Script : http://www.portalfps.com.br/pfps/admincp/usergroup.php?do=update
Referrer : http://www.portalfps.com.br/pfps/admincp/usergroup.php?do=edit&usergroupid=9
IP Address : 189.27.213.179
Username : Fuhrmann
Classname : vB_Database
MySQL Version : 5.0.85-community

Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 421
#1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 439
#2 vB_Database->query_write() called in [path]/admincp/usergroup.php on line 358




I know that the field "'ms_imageshack_upload_permissions" doest existe in table, but how i can remove this field from the query?

I have in usergoup this:
http://img180.imageshack.us/img180/5438/ddasdasdasdasd.png

ChopSuey
06-20-2010, 02:25 PM
Have you removed the mod from your forum? YOu need to remove all files also.

XML, php, files on your server.

Fuhrmann
06-20-2010, 04:25 PM
Nice ChopSuey.
I used this mod: https://vborg.vbsupport.ru/showthread.php?t=239700&highlight=imageshack

All that i have done is delete the file "bitfield_ms_imageshack_upload.xml" and that is working now.
Really thanks.