The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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. |
#3
|
|||
|
|||
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? |
#4
|
||||
|
||||
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.
|
#5
|
|||
|
|||
Thanks Birdoprey
For everyone landing here through google search, here's the solution Quote:
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|