vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Please Help me! with DATABASE ERROR. INvalid SQL (https://vborg.vbsupport.ru/showthread.php?t=124821)

hypnoticpimp 08-24-2006 08:07 PM

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


All times are GMT. The time now is 05:56 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.01040 seconds
  • Memory Usage 1,709KB
  • 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
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)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