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 · #22 04-15-2002, 10:27 PM

Glad you got it working. Just out of curiousity, how did you fix it?

Slynderdale · #23 04-15-2002, 10:46 PM

i went on phpmyadmin and manualy ran REPAIR TABLE query's for each table and it fixed them up and now they work, i lost a couple new posts but overall every thing is back to normal

eoc_Jason · #24 04-17-2002, 02:51 AM

Whew.... glad to hear you were able to fix it...

This is one of the many reasons I have my forum do a dump every night.... just incase of something bad.... hehe..

Slynderdale · #25 04-18-2002, 12:14 AM

ok im getting tired of my web host always being down for some unknown reason, and right when in a middle of testing a hack, im getting a new webhost with a d3 45mps connection, php, mysql, the works, and it has iphp, iphp is real cool

Tim Wheatley · #26 08-23-2002, 06:14 PM

I'm now trying what you said as I have the same problem. When someone tries to access my stats it gives a search.myd error.

Slynderdale · #27 08-24-2002, 02:33 AM

Quote:

Originally posted by Tim Wheatley
I'm now trying what you said as I have the same problem. When someone tries to access my stats it gives a search.myd error.

I hope it works.

WCW Fan · #28 07-15-2003, 03:08 AM

Quote:

04-17-02 at 04:51 AM eoc_Jason said this in Post #23
Whew.... glad to hear you were able to fix it...

This is one of the many reasons I have my forum do a dump every night.... just incase of something bad.... hehe..

How do you dumb your db would that be just backing up Im confused, Im sorry if this is an old topic I just signed up :/

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04073 seconds Memory Usage 2,284KB Queries Executed 24 (?)
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 (5)bbcode_code (2)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 (8)post_thanks_box (8)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (8)post_thanks_postbit_info (7)postbit (8)postbit_onlinestatus (8)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 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!