Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 08-04-2006, 10:12 PM
Chicago_VLNU_4s Chicago_VLNU_4s is offline
 
Join Date: Mar 2006
Location: Chicago
Posts: 453
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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
Reply With Quote
  #2  
Old 08-04-2006, 11:14 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #3  
Old 08-05-2006, 01:56 AM
Chicago_VLNU_4s Chicago_VLNU_4s is offline
 
Join Date: Mar 2006
Location: Chicago
Posts: 453
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:35 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03523 seconds
  • Memory Usage 2,186KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete