vb.org Archive - Database crashed, need help

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)

- - Database crashed, need help (https://vborg.vbsupport.ru/showthread.php?t=267669)

kartik786

07-30-2011 07:07 AM

Database crashed, need help

I'm getting the following error when posting any thread.

The homepage does not open,

Internal pages open fine, But when I open new thread, it gives a database error.

Code:

Database error in vBulletin 3.8.3:



Invalid SQL:



                        SELECT thread.threadid, MATCH(thread.title) AGAINST ('testing') AS score

                        FROM thread AS thread

                        

                        WHERE MATCH(thread.title) AGAINST ('testing')

                                AND thread.open <> 10

                                

                                

                        LIMIT 5;



MySQL Error   : Incorrect key file for table './database_name/thread.MYI'; try to repair it

Error Number  : 126

Request Date  : Saturday, July 30th 2011 @ 01:32:52 PM

Error Date    : Saturday, July 30th 2011 @ 01:32:54 PM

Script        : http://www.website.comforums/newthread.php?do=postthread&f=12

Referrer      : http://www.website.com/forums/newthread.php?do=newthread&f=12

IP Address    : 116.73.21.8

Username      : admin

Classname     : vB_Database_MySQLi

MySQL Version : 5.0.92-community-log

I repaired the database but this problem still remains the same.

BirdOPrey5

07-30-2011 11:03 AM

Did you run repair on the thread table? Sometimes more than once. Do you have the ability to restart mysql on the server? Couldn't hurt if you can.

Make sure your disk space isn't close to full.

kartik786

07-30-2011 11:28 AM

thanks birdoprey5 :)

My hosting guys somehow managed to optimize it but the server mysql is getting thrashed with load and they suggest we seperate mysql and apache to 2 servers.

They dont know how to connect the database string. Any clue on that?

BirdOPrey5

07-30-2011 03:57 PM

I don't know what the database "string" is but if you do move the database to another server I know you will have to make changes in your config.php file to tell it the details of the database server.

kartik786

08-01-2011 07:48 PM

Thanks Birdoprey :)

For everyone landing here through google search, here's the solution

Quote:

If this keeps happening over and over again after reparing the tables, then this is a server issue. You need to contact your host.

To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.

If that doesn't work then this may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:

https://www.vbulletin.com/forum/show...threadid=44909

You may have to ask your host to try and repair this for you.

All times are GMT. The time now is 12:23 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00944 seconds Memory Usage 1,731KB 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)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)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
Messages: