The Arcive of Official vBulletin Modifications Site.

I need Help. · **Released**: 04-14-2002

I went to use phpmyadmin to optomized a table and now there messed up, is there any way i could fix them without losing every thing? This is really important. Its the search and templateset table.

Code:

  Table   Action Records Type Size 
   access    Browse  Select  Insert  Properties  Drop  Empty  0   MyISAM      1.0 KB  
   adminlog    Browse  Select  Insert  Properties  Drop  Empty  1,865   MyISAM      163.3 KB  
   adminutil    Browse  Select  Insert  Properties  Drop  Empty  1   MyISAM      2.0 KB  
   announcement    Browse  Select  Insert  Properties  Drop  Empty  3   MyISAM      5.4 KB  
   attachment    Browse  Select  Insert  Properties  Drop  Empty  34   MyISAM      1.5 MB  
   avatar    Browse  Select  Insert  Properties  Drop  Empty  0   MyISAM      1.0 KB  
   award    Browse  Select  Insert  Properties  Drop  Empty  1   MyISAM      2.1 KB  
   bbcode    Browse  Select  Insert  Properties  Drop  Empty  28   MyISAM      5.7 KB  
   calendar_events    Browse  Select  Insert  Properties  Drop  Empty  0   MyISAM      1.0 KB  
   customavatar    Browse  Select  Insert  Properties  Drop  Empty  29   MyISAM      119.5 KB  
   forum    Browse  Select  Insert  Properties  Drop  Empty  59   MyISAM      71.2 KB  
   forumpermission    Browse  Select  Insert  Properties  Drop  Empty  55   MyISAM      5.4 KB  
   icon    Browse  Select  Insert  Properties  Drop  Empty  14   MyISAM      4.8 KB  
   modapp    Browse  Select  Insert  Properties  Drop  Empty  6   MyISAM      3.8 KB  
   modappuser    Browse  Select  Insert  Properties  Drop  Empty  7   MyISAM      2.2 KB  
   moderator    Browse  Select  Insert  Properties  Drop  Empty  15   MyISAM      3.6 KB  
   poll    Browse  Select  Insert  Properties  Drop  Empty  12   MyISAM      3.7 KB  
   pollvote    Browse  Select  Insert  Properties  Drop  Empty  63   MyISAM      4.3 KB  
   post    Browse  Select  Insert  Properties  Drop  Empty  1,669   MyISAM      484.3 KB  
   privatemessage    Browse  Select  Insert  Properties  Drop  Empty  120   MyISAM      37.6 KB  
   profilefield    Browse  Select  Insert  Properties  Drop  Empty  9   MyISAM      4.8 KB  
   replacement    Browse  Select  Insert  Properties  Drop  Empty  131   MyISAM      10.2 KB  
   replacementset    Browse  Select  Insert  Properties  Drop  Empty  5   MyISAM      3.2 KB  
   search    Browse  Select  Insert  Properties  Drop  Empty  in use  
   searchindex    Browse  Select  Insert  Properties  Drop  Empty  14,141   MyISAM      352.9 KB  
   session    Browse  Select  Insert  Properties  Drop  Empty  19   HEAP      156.0 KB  
   setting    Browse  Select  Insert  Properties  Drop  Empty  176   MyISAM      44.9 KB  
   settinggroup    Browse  Select  Insert  Properties  Drop  Empty  32   MyISAM      5.3 KB  
   smilie    Browse  Select  Insert  Properties  Drop  Empty  21   MyISAM      6.8 KB  
   style    Browse  Select  Insert  Properties  Drop  Empty  3   MyISAM      2.8 KB  
   subscribeforum    Browse  Select  Insert  Properties  Drop  Empty  1   MyISAM      3.0 KB  
   subscribethread    Browse  Select  Insert  Properties  Drop  Empty  105   MyISAM      4.5 KB  
   template    Browse  Select  Insert  Properties  Drop  Empty  719   MyISAM      924.1 KB  
   templateset    Browse  Select  Insert  Properties  Drop  Empty  in use  
   thread    Browse  Select  Insert  Properties  Drop  Empty  195   MyISAM      28.0 KB  
   threadrate    Browse  Select  Insert  Properties  Drop  Empty  2   MyISAM      3.0 KB  
   user    Browse  Select  Insert  Properties  Drop  Empty  89   MyISAM      35.3 KB  
   user_rate    Browse  Select  Insert  Properties  Drop  Empty  84   MyISAM      4.2 KB  
   useractivation    Browse  Select  Insert  Properties  Drop  Empty  36   MyISAM      4.2 KB  
   useraward    Browse  Select  Insert  Properties  Drop  Empty  15   MyISAM      3.4 KB  
   userfield    Browse  Select  Insert  Properties  Drop  Empty  89   MyISAM      198.0 KB  
   usergroup    Browse  Select  Insert  Properties  Drop  Empty  12   MyISAM      8.1 KB  
   usernotepad    Browse  Select  Insert  Properties  Drop  Empty  4   MyISAM      1.1 KB  
   usertitle    Browse  Select  Insert  Properties  Drop  Empty  3   MyISAM      2.7 KB  
   vbstats_counter    Browse  Select  Insert  Properties  Drop  Empty  19   MyISAM      1.4 KB  
   vbstats_countries    Browse  Select  Insert  Properties  Drop  Empty  247   MyISAM      9.8 KB  
   vbstats_date    Browse  Select  Insert  Properties  Drop  Empty  17   MyISAM      1.6 KB  
   vbstats_exclude    Browse  Select  Insert  Properties  Drop  Empty  0   MyISAM      1.0 KB  
   vbstats_options    Browse  Select  Insert  Properties  Drop  Empty  1   MyISAM      1.1 KB  
   vbstats_referrer    Browse  Select  Insert  Properties  Drop  Empty  14   MyISAM      2.6 KB  
   word    Browse  Select  Insert  Properties  Drop  Empty  5,519   MyISAM      417.4 KB  
  51 table(s)   Sum  25,689  --    4.6 MB

Heres the errors:

Templateset:

Code:

Invalid SQL: SELECT templatesetid,title FROM templateset
mysql error: Can't open file: 'templateset.MYD'. (errno: 144)

mysql error number: 1016

Heres what it says on php my admin:

Code:

SQL-query :  

SHOW KEYS FROM `templateset`

MySQL said: 


Can't open file: 'templateset.MYD'. (errno: 144)

Search:

Code:

Invalid SQL: SELECT searchid,dateline FROM search WHERE userid=1 ORDER BY dateline DESC LIMIT 1
mysql error: Can't open file: 'search.MYD'. (errno: 144)

mysql error number: 1016

Heres what it says on php my admin:

Code:

Error

SQL-query :  

SHOW KEYS FROM `search`

MySQL said: 


Can't open file: 'search.MYD'. (errno: 144)

Steve Machol · #2 04-14-2002, 09:04 PM

Close your forums and upload repair.php (from the 'extras' folder of the zip file) to your admin folder. Then run it from your browser with this syntax:

http://www.yoursite.com/forums/admin...html=1&check=1

Slynderdale · #3 04-14-2002, 09:06 PM

Quote:

Originally posted by smachol
Close your forums and upload repair.php (from the 'extras' folder of the zip file) to your admin folder. Then run it from your browser with this syntax:

http://www.yoursite.com/forums/admin...html=1&check=1

Ill try that, thanks

Slynderdale · #4 04-14-2002, 09:29 PM

ok now this is bad, i ran the rapair scripted like ypi said, now instead just those two having an error, 90% of my database has errors now

Slynderdale · #5 04-14-2002, 09:31 PM

Code:

 Table   Action Records Type Size 
   access    Browse  Select  Insert  Properties  Drop  Empty  0   MyISAM      1.0 KB  
   adminlog    Browse  Select  Insert  Properties  Drop  Empty  in use  
   adminutil    Browse  Select  Insert  Properties  Drop  Empty  in use  
   announcement    Browse  Select  Insert  Properties  Drop  Empty  in use  
   attachment    Browse  Select  Insert  Properties  Drop  Empty  in use  
   avatar    Browse  Select  Insert  Properties  Drop  Empty  0   MyISAM      1.0 KB  
   award    Browse  Select  Insert  Properties  Drop  Empty  in use  
   bbcode    Browse  Select  Insert  Properties  Drop  Empty  in use  
   calendar_events    Browse  Select  Insert  Properties  Drop  Empty  0   MyISAM      1.0 KB  
   customavatar    Browse  Select  Insert  Properties  Drop  Empty  in use  
   forum    Browse  Select  Insert  Properties  Drop  Empty  in use  
   forumpermission    Browse  Select  Insert  Properties  Drop  Empty  in use  
   icon    Browse  Select  Insert  Properties  Drop  Empty  in use  
   modapp    Browse  Select  Insert  Properties  Drop  Empty  in use  
   modappuser    Browse  Select  Insert  Properties  Drop  Empty  in use  
   moderator    Browse  Select  Insert  Properties  Drop  Empty  in use  
   poll    Browse  Select  Insert  Properties  Drop  Empty  in use  
   pollvote    Browse  Select  Insert  Properties  Drop  Empty  in use  
   post    Browse  Select  Insert  Properties  Drop  Empty  in use  
   privatemessage    Browse  Select  Insert  Properties  Drop  Empty  in use  
   profilefield    Browse  Select  Insert  Properties  Drop  Empty  in use  
   replacement    Browse  Select  Insert  Properties  Drop  Empty  in use  
   replacementset    Browse  Select  Insert  Properties  Drop  Empty  in use  
   search    Browse  Select  Insert  Properties  Drop  Empty  in use  
   searchindex    Browse  Select  Insert  Properties  Drop  Empty  in use  
   session    Browse  Select  Insert  Properties  Drop  Empty  21   HEAP      156.0 KB  
   setting    Browse  Select  Insert  Properties  Drop  Empty  in use  
   settinggroup    Browse  Select  Insert  Properties  Drop  Empty  in use  
   smilie    Browse  Select  Insert  Properties  Drop  Empty  in use  
   style    Browse  Select  Insert  Properties  Drop  Empty  in use  
   subscribeforum    Browse  Select  Insert  Properties  Drop  Empty  in use  
   subscribethread    Browse  Select  Insert  Properties  Drop  Empty  in use  
   template    Browse  Select  Insert  Properties  Drop  Empty  in use  
   templateset    Browse  Select  Insert  Properties  Drop  Empty  in use  
   thread    Browse  Select  Insert  Properties  Drop  Empty  195   MyISAM      28.0 KB  
   threadrate    Browse  Select  Insert  Properties  Drop  Empty  2   MyISAM      3.0 KB  
   user    Browse  Select  Insert  Properties  Drop  Empty  89   MyISAM      35.3 KB  
   user_rate    Browse  Select  Insert  Properties  Drop  Empty  84   MyISAM      4.2 KB  
   useractivation    Browse  Select  Insert  Properties  Drop  Empty  36   MyISAM      4.2 KB  
   useraward    Browse  Select  Insert  Properties  Drop  Empty  15   MyISAM      3.4 KB  
   userfield    Browse  Select  Insert  Properties  Drop  Empty  89   MyISAM      198.0 KB  
   usergroup    Browse  Select  Insert  Properties  Drop  Empty  12   MyISAM      8.1 KB  
   usernotepad    Browse  Select  Insert  Properties  Drop  Empty  4   MyISAM      1.1 KB  
   usertitle    Browse  Select  Insert  Properties  Drop  Empty  3   MyISAM      2.7 KB  
   vbstats_counter    Browse  Select  Insert  Properties  Drop  Empty  19   MyISAM      1.4 KB  
   vbstats_countries    Browse  Select  Insert  Properties  Drop  Empty  247   MyISAM      9.8 KB  
   vbstats_date    Browse  Select  Insert  Properties  Drop  Empty  17   MyISAM      1.6 KB  
   vbstats_exclude    Browse  Select  Insert  Properties  Drop  Empty  0   MyISAM      1.0 KB  
   vbstats_options    Browse  Select  Insert  Properties  Drop  Empty  1   MyISAM      1.1 KB  
   vbstats_referrer    Browse  Select  Insert  Properties  Drop  Empty  14   MyISAM      2.6 KB  
   word    Browse  Select  Insert  Properties  Drop  Empty  5,519   MyISAM      417.4 KB  
  51 table(s)   Sum  6,367  --    882.1 K

Slynderdale · #6 04-14-2002, 09:38 PM

now all i get is

There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Steve Machol · #7 04-14-2002, 09:44 PM

It sounds like your server is running an older version of MySQL. See eva2000's message here, specifically suggestion #3:

http://www.vbulletin.com/forum/showt...threadid=42663

You may have to contact you host to help fix the problem. Good luck!

Slynderdale · #8 04-14-2002, 10:02 PM

MySQL 3.23.45

Steve Machol · #9 04-14-2002, 10:10 PM

That should be fine for repair.php then. Have you installed any hacks that make changes to the database?
What was the content of the latest error email you got?

Slynderdale · #10 04-14-2002, 10:28 PM

i tried to run a repair query and it failed and got an error, i installed some hacks, but they worked fine and didnt cause any problems.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04183 seconds Memory Usage 2,305KB Queries Executed 23 (?)
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 (6)bbcode_code (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)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_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 pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!