Log in

View Full Version : WTF, i keep getting errors in ADMIN CP


Chicago_VLNU_4s
08-04-2006, 10:12 PM
when i try to edit usergroups, heres the error i get..

There seems to have been a problem with the Off Tha Ave database.
Please try again by clicking the Refresh button in your web browser.
An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.
We apologise for any inconvenience.

Database error in vBulletin 3.5.4:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = '',
`opentag` = '<span style=\'color:white\'>',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`anymediapermissions` = '1',
`profileviewpermissions` = '15',
`pagerpermissions` = '5',
`pagerquota` = '50',
`pagerminpost` = '0',
`pagerminpostperday` = '0',
`pagermaxperday` = '0',
`pagersendmax` = '0',
`pagersendmaxchar` = '3000',
`hhroptions` = '0',
`forumpermissions` = '774391',
`genericpermissions` = '204210139',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '0',
`pmsendmax` = '5',
`calendarpermissions` = '0',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericoptions` = '30',
`profilepicmaxwidth` = '200',
`profilepicmaxheight` = '200',
`profilepicmaxsize` = '6553',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000'
WHERE usergroupid=2;
MySQL Error : Unknown column 'hhroptions' in 'field list'
Error Number : 1054
Date : Friday, August 4th 2006 @ 05:12:14 PM
Script : http://www.offthaave.com/forums/admincp/usergroup.php
Referrer : http://www.offthaave.com/forums/admincp/usergroup.php?do=edit&usergroupid=2
IP Address : 75.3.90.164
Username : 4 CORNER HUSTLA
Classname : vB_Database




and whenever i try to import an .xml file, heres the error i get..

"Importing Product, Please Wait..."

and yellow loading colon's that load forever... then here's the error..


There seems to have been a problem with the Off Tha Ave database.
Please try again by clicking the Refresh (http://www.offthaave.com/forums/admincp/plugin.php#) button in your web browser.
An E-Mail has been dispatched to our Technical Staff (chicagorilla4chn@yahoo.com), whom you can also contact if the problem persists.
We apologise for any inconvenience.


Database error in vBulletin 3.5.4:
Invalid SQL:
### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'EasyFeedback - Saving the ratings', 'misc_start', '// ############################### start feedback ###############################\r\nif ($_REQUEST[\'do\'] == \'feedback\')\r\n{\r\n $vbulletin->input->clean_array_gpc(\'r\', array(\r\n \'r\' => TYPE_UINT,\r\n ));\r\n\r\n if ($vbulletin->userinfo[\'userid\'])\r\n {\r\n $userid = $vbulletin->userinfo[\'userid\'];\r\n $ip = $_SERVER[\'REMOTE_ADDR\'];\r\n $time = time();\r\n $rating = $vbulletin->GPC[\'r\'];\r\n $response = \'<p><b>Thanks for the Review</b></p>\';\r\n $db->query_write(\"\r\n INSERT INTO \" . TABLE_PREFIX . \"feedback (userid, ip, time, rating)\r\n VALUES (\'$userid\', \'$ip\', \'$time\', \'$rating\')\r\n \");\r\n \r\n$ret = setcookie(\"_fb__\",\"1\",time()+60*60*24*30,\"/\"); // set the cookie so it will not load again\r\n }\r\n\r\nelse {\r\n$response = \'<p><b>Registered users only!</b></p>\';\r\n}\r\neval(\'print_output(\"\' . $response . \'\");\');\r\n}', 'mrnase_easyfeedback');
MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Friday, August 4th 2006 @ 07:08:09 PM
Script : http://www.offthaave.com/forums/admincp/plugin.php
Referrer : http://www.offthaave.com/forums/admincp/plugin.php?do=productadd
IP Address : 75.3.90.164
Username : 4 CORNER HUSTLA
Classname : vB_Database




can somebody please help me.. theres probably more errors to come across

Paul M
08-04-2006, 11:14 PM
The first error is because there is no such field as 'hhroptions' in the usergroup table - so that must be a mod you have installed that is not working properly (or hasn't been removed properly if you no longer use it).

The second error is because you are trying to import a vb 3.6 format product into vb 3.5 - you can't do that.

Chicago_VLNU_4s
08-05-2006, 01:56 AM
thanks for the reply Paul.. yeh the second one was 4 the "Rate our site" hack. so ill try to look through "Manage Products" and see if we don't use anything outta there anymore and reply back. Thanks again

ok, for some reason its the hide hack ressurection... i disabled it, and was able to manage usegroups.... funny