| fxwoody |
16 Jun 2010 14:18 |
Well for one strange reason i can't get the usergroup permission to work ! I always receive DBase error!
Quote:
Database error in vBulletin 4.0.3:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<span style=\"font-weight: bold; color: #ff0000;\">',
`closetag` = '',
`passwordexpires` = '180',
`passwordhistory` = '360',
`vbblog_general_permissions` = '524286',
`vbblog_customblocks` = '10',
`vbblog_custompages` = '10',
`vbblog_entry_permissions` = '24575',
`vbblog_comment_permissions` = '990',
`awardpermissions` = '1',
`ms_photobucket_upload_permissions` = '0',
`tournamentpermissions` = '1023',
`maxteams` = '1',
`ladderpermissions` = '31',
`ms_imageshack_upload_permissions` = '0',
`ms_megaupload_upload_permissions` = '0',
`hhroptions` = '1023',
`forumpermissions` = '16777215',
`genericpermissions` = '2147483647',
`attachlimit` = '0',
`pmquota` = '150',
`pmpermissions` = '7',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '55',
`profilepicmaxwidth` = '200',
`profilepicmaxheight` = '200',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '130',
`avatarmaxheight` = '150',
`avatarmaxsize` = '2000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '160',
`sigpicmaxsize` = '65535',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '262143',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535'
WHERE usergroupid=6;
MySQL Error : Unknown column 'ms_photobucket_upload_permissions' in 'field list'
Error Number : 1054
Request Date : Wednesday, June 16th 2010 @ 03:38:50 PM
Error Date : Wednesday, June 16th 2010 @ 03:38:50 PM
Script : http://**********.com/test/****/usergroup.php?do=update
Referrer : http://**********.com/test/*****/use...&usergroupid=6
IP Address : *******
Username : ******
Classname : vB_Database
MySQL Version : 5.0.90-community
|
From what i can see the " Unknown column 'ms_photobucket_upload_permissions' in 'field list' " as been incorporated somewhere in it when we did the upgrade from 3.8xxx to 4.0.3 !? Not a top gun in the field so, pls, be gentil with answer :p lol
Tks
***EDITED***
Ok got ride of the photobucket and imageshack files and works fine ;)
Tks |