vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   WTF, i keep getting errors in ADMIN CP (https://vborg.vbsupport.ru/showthread.php?t=123065)

Chicago_VLNU_4s 08-04-2006 10:12 PM

WTF, i keep getting errors in ADMIN CP
 
when i try to edit usergroups, heres the error i get..

Quote:

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.
Code:

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/admi...&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..

Quote:

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.

Code:


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/admi...?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


All times are GMT. The time now is 03:50 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01114 seconds
  • Memory Usage 1,736KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete