| Ranma2k |
10-02-2006 07:59 PM |
Quote:
Originally Posted by d2sector
Im getting this error when editing a usergroups options (upload slots)
Code:
Database error in vBulletin 3.6.1:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Super Moderators',
`description` = '',
`usertitle` = 'Super Moderator',
`opentag` = '<strong><font color=\"#00B1E4\">',
`closetag` = '</font></strong>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '1048575',
`attachlimit` = '10971520',
`pmquota` = '150',
`pmpermissions` = '7',
`pmsendmax` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '15',
`adminpermissions` = '1',
`genericpermissions` = '485449583',
`genericoptions` = '63',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '96',
`avatarmaxheight` = '96',
`avatarmaxsize` = '50000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '20000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '20',
`vbppermissions` = '4993',
`vbp_discountrate` = '10.00000',
`vbp_paycheckamount` = '0.00000',
`vbp_secondarycost` = '0.00000',
`vbp_primarycost` = '0.00000',
`arcadepermissions` = '159',
`minpoststoplay` = '0',
`minreptoplay` = '-1000',
`minreglengthtoplay` = '0',
`vbimghost` = '3',
`vbimghost_upslots` = '5',
`vbimghost_files` = '50'
WHERE usergroupid=5;
MySQL Error : Unknown column 'vbimghost_upslots' in 'field list'
Error Number : 1054
Date : Sunday, October 1st 2006 @ 07:23:27 PM
Script : usergroup.php?do=update
Referrer : usergroup.php?do=edit&usergroupid=5
IP Address : XXXX
Username : XXXX
Classname : vB_Database
Tired uninstall (deleting the tables with phpmyadmin) and re-installing about 5 times. Using PHP 5 and MYSQL 5
|
try running the Q
Code:
ALTER TABLE " . TABLE_PREFIX . "usergroup ADD vbimghost INT( 10 ) UNSIGNED NOT NULL default '0', ADD vbimghost_files INT( 10 ) UNSIGNED NOT NULL default '50',ADD vbimghost_upslots INT( 5 ) UNSIGNED NOT NULL DEFAULT '3';
|
More Information