Quote:
Originally Posted by saadessa
AFTER TRY TO GIVE permission
GIVE THIS ERROR
PHP Code:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '180',
`passwordhistory` = '360',
`forumpermissions` = '16777215',
`genericpermissions` = '2147483583',
`attachlimit` = '0',
`psiwd_options` = '1',
`pmquota` = '50',
`pmpermissions` = '7',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '55',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`uscpermissions` = '0'
WHERE usergroupid=6;
MySQL Error : Unknown column 'psiwd_options' in 'field list'
Error Number : 1054
Request Date : Saturday, June 27th 2009 @ 01:18:46 PM
Error Date : Saturday, June 27th 2009 @ 01:18:46 PM
|
Getting the same thing
PHP Code:
Database error in vBulletin 3.8.3:
Invalid SQL:
UPDATE ravensfo_usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrator/Owner',
`description` = 'Owner of forum',
`usertitle` = 'Owner',
`opentag` = '<span style=\"color: red;\">',
`closetag` = '</span>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`ispublicgroup` = '0',
`canoverride` = '0',
`credit_ibp_passcost` = '1',
`credit_ibp_accesscost` = '0',
`credit_ibp_discount` = '0',
`credit_thanks_gain` = '100',
`credit_thanks_lose` = '-10',
`credit_thanks_give` = '5',
`credit_thanks_take` = '-5',
`fcpermissions` = '13',
`ugphelpcenter` = '8191',
`vbblog_general_permissions` = '524286',
`vbblog_customblocks` = '5',
`vbblog_custompages` = '5',
`vbblog_entry_permissions` = '24575',
`vbblog_comment_permissions` = '2014',
`creditpermissions` = '628',
`credit_induction` = '200',
`credit_referral` = '100',
`credit_refbonus` = '0',
`credit_paycheck` = '100',
`credit_active` = '100',
`credit_birthday` = '100',
`credit_repgive` = '10',
`credit_reputation` = '15',
`credit_infraction` = '-10',
`credit_thread` = '50',
`credit_threadrate` = '10',
`credit_post` = '1',
`credit_ownthreadpost` = '3',
`credit_postsize` = '1',
`credit_ownthreadview` = '1',
`credit_ownthreadrate` = '1',
`credit_ownthreadreply` = '2',
`credit_ownprofileview` = '10',
`credit_pollmake` = '10',
`credit_pollvote` = '3',
`credit_attachment` = '100',
`credit_sendpm` = '0',
`credit_addevent` = '3',
`credit_addprofpic` = '0',
`credit_profile` = '0',
`credit_donmaxuser` = '-1',
`credit_pastotpost` = '-1',
`credit_pastotuser` = '-1',
`credit_pasawuser` = '-1',
`credit_pasawthread` = '-1',
`credit_saveint` = '0.1',
`credit_maxsave` = '-1',
`credit_loanint` = '0.195',
`credit_maxloan` = '1000',
`credit_totloan` = '5',
`credit_goodgroup` = '0',
`credit_midgroup` = '0',
`credit_badgroup` = '0',
`credit_maxtickets` = '10',
`credit_lotdiscount` = '0',
`forumpermissions` = '16777215',
`genericpermissions` = '2147483647',
`attachlimit` = '0',
`psiwd_options` = '1',
`pmquota` = '5000',
`pmpermissions` = '7',
`pmsendmax` = '5',
`pmthrottlequantity` = '100',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '500',
`profilepicmaxheight` = '500',
`profilepicmaxsize` = '1000000000',
`avatarmaxwidth` = '250',
`avatarmaxheight` = '250',
`avatarmaxsize` = '2000000000',
`signaturepermissions` = '245759',
`sigpicmaxwidth` = '700',
`sigpicmaxheight` = '700',
`sigpicmaxsize` = '1000000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '5',
`albumpermissions` = '255',
`albumpicmaxwidth` = '700',
`albumpicmaxheight` = '700',
`albumpicmaxsize` = '1000000',
`albummaxpics` = '110',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '1000000000',
`awardpermissions` = '1',
`op_user_html_markup_permissions` = '2047',
`sk_hiddenpermissions` = '1',
`trgpermissions` = '15',
`trmperms` = '15',
`radiotvpermissions` = '2047',
`unreq_perms` = '3'
WHERE usergroupid=13;
MySQL Error : Unknown column 'psiwd_options' in 'field list'
Error Number : 1054
Request Date : Saturday, June 27th 2009 @ 12:33:46 PM
Error Date : Saturday, June 27th 2009 @ 12:33:46 PM
Script : http://ravensforums.com/forums/admincp/usergroup.php?do=update
Referrer : http://ravensforums.com/forums/admincp/usergroup.php?do=edit&usergroupid=13
IP Address : 76.11.135.45
Username : Jeff
Classname : vB_Database
MySQL Version : 5.1.30
|
More Information