Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 08-24-2006, 08:07 PM
hypnoticpimp hypnoticpimp is offline
 
Join Date: Dec 2004
Posts: 132
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Please Help me! with DATABASE ERROR. INvalid SQL

I installed a mod called, Psi Stats 2006, located at
https://vborg.vbsupport.ru/showthrea...=104213&page=5

Hey, for some reason, i just got this error, when entering to my forums


Quote:

Database error in vBulletin 3.5.4:
Invalid SQL:
REPLACE INTO `hypnoticpimp_psistats_cache` (`cdata`, `ctype`, `csid`)

MySQL Error : Can't find file: 'hypnoticpimp_psistats_cache.MYI' (errno: 2)
Error Number : 1017




I had this mod working for like 1 month, and all of a sudden i get this error
I trued adding the Disable Hooks, on my config, so i can uninstall it and res install it, but when i did, nothing happens, i still get that message,. Even when i try to logging in to my admincp, it takes me to that error page.

I read on other posts, on vb.org for that mod, at
https://vborg.vbsupport.ru/showthrea...=104213&page=5
that can fix it, by reparing tables! my question is on phpadmin there is no Fix table option, and i dont know which table i should fix, or how i fix it, Please help

I even uploaded tools.php to my admin, and i got that page working, and i tried the repair tables tool in there. and i checke don all tables, after it was done, i tried refreshing on forum and still got that error

I cant login to my admin cp. even if i use that disable hooks, on the config.pgp . I still get that error, and i even tried refreshing, the page a couple of times.

The only thing i can do is use tools.php, but all that has is a repair all tables tools. DOesnt have that optimize tool. But i used the repair all tables on tools.php and still nothing

could you step me through to fixing and optmizing on phpadmin, please
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 08:24 PM.


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.07989 seconds
  • Memory Usage 2,181KB
  • Queries Executed 11 (?)
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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)showthread_list
  • (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_threadedmode.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • 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