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)

Slynderdale · #12 04-14-2002, 10:50 PM

Database error in vBulletin :

Invalid SQL: SELECT template FROM template WHERE title='options'
mysql error: Can't open file: 'template.MYD'. (errno: 144)

mysql error number: 1016

Database error in vBulletin :
Invalid SQL: SELECT template FROM template WHERE title='options'
mysql error: Can't open file: 'template.MYD'. (errno: 144)

mysql error number: 1016

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

What 'repair query' did you run? Just run repair.php exactly as I told you. If any tables do not show 'ok' run it again. Make sure your forums are off when you run this! If all errors don;t go away after the second run, post the results here.

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

heres what i get when i try to run it

Warning: MySQL Connection Failed: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug in /home/darktech/public_html/slynderdale/forum/admin/db_mysql.php on line 40

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.

i have the memory too, i checked the account control panel

Steve Machol · #15 04-14-2002, 11:14 PM

I don't see how running repair.php could possibly generate that kind of an error since it's not attempting to create a thread.

Error code 11: Resource temporarily unavailable

This is a server problem.

Slynderdale · #16 04-15-2002, 07:22 PM

The server problem was fixed, but my mysql database is still messed up and when i try to tun the repair scripted thos shows up:

Code:

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.

the repair scripted shows up:

Code:

repair.php for mysql 3.23 or greater

This script will attempt to repair corrupted databases. While it can repair most common errors, it can not repair everything. As a side benefit it will also optimize your tables. This script is unsupported by jelsoft.

Usage:

iterations=x (x is the number of times you wish for the script to attempt to repair a broken table)
nohtml=1 (Output text only no html. Useful for cronjobs and you wish to receive text only)
forum=x (x is the name of the database to check. Leave it off to use the default database of your vBulletin forum)
check=1 (without this you will get this screen and no checking)

Example Usage:

repair.php?html=1&check=1 (most common usage, will check a forum and return html results)
repair.php?check=1&iterations=4&forum=vbdatabase (check the database "vbdatabase", try to repair damaged tables 4 times)

is there a way to have it check the mysql database without having it use the forums?

Steve Machol · #17 04-15-2002, 07:44 PM

I'm not sure what your question is. Since the forums are, in effect, the database I don't see what you're getting at.

I recommend you use the 'repair.php?html=1&check=1' syntax when running repair.php.

Slynderdale · #18 04-15-2002, 07:46 PM

Quote:

Originally posted by smachol
I'm not sure what your question is. Since the forums are, in effect, the database I don't see what you're getting at.

I recommend you use the 'repair.php?html=1&check=1' syntax when running repair.php.

i tried that and all i got 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.

Slynderdale · #19 04-15-2002, 07:58 PM

Code:

<!-- Database error in vBulletin Control Panel :

Invalid SQL: SELECT template FROM template WHERE title='options'
mysql error: Can't open file: 'template.MYD'. (errno: 144)

mysql error number: 1016

Date: Monday 15th of April 2002 08:42:50 PM
Script: /forum/admin/repair.php?html=1&check=1
Referer: http://www.1stconnection.co.uk:2086/scripts/command
 -->

i checked the repair files source and thats what it said

Slynderdale · #20 04-15-2002, 08:17 PM

would it be possible to make the repair.php a standalone scripted and doesnt need to get global.php? i think its not working because how the forums tables are messed up, i was wondering if you could edit it so i could put it in my sites root directory and run it and have it check the database that way

Slynderdale · #21 04-15-2002, 10:04 PM

Nevermind smachol, i fixed the tables myself, i didnt need the repair.php, thanks for the help though

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07211 seconds Memory Usage 2,314KB Queries Executed 25 (?)
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 (8)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 (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)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!