PDA

View Full Version : What is this SQL Error??


kmfdm_kid2000
04-15-2003, 05:39 AM
This happened all of the sudden, I wasn't even NEAR the new Database (FRESH one, since I didn't receive help fixing the old one from anyone but Filburt, sadly, I was not able to recover yet...)

Anyway, why am I and my users getting this:


Database error in vBulletin 2.3.0:

Invalid SQL: SELECT threadid,lastpost
FROM thread
WHERE forumid = 224
AND visible=1
AND sticky=1

mysql error: Can't open file: 'thread.MYI'. (errno: 145)

mysql error number: 1016

Date: Tuesday 15th of April 2003 06:28:06 AM
Script: http://www.gqforums.com/forumdisplay.php?forumid=224
Referer:


Happens when trying to connect to almost ANY PHP file in the root, Forumdisplay, usercp.php, private.php, etc...I was working on COLORS and BUTTONS, not even on the server, so I KNOW it wasn't due to me doing something, so what gives??

Erwin
04-15-2003, 05:53 AM
Upload repair.php and run it. You have a damaged thread table.

This has happened to filburt1 recently.

kmfdm_kid2000
04-15-2003, 06:13 AM
Erwin, did I ever tell you you're the BEST?? I belive I did in an E-Mail long ago...That did the trick...Now, if I could only import the 154,000 posts from my other Database, I'd be set...:(

filburt1
04-15-2003, 10:12 AM
Today at 03:07 AM kmfdm_kid2000 said this in Post #3 (https://vborg.vbsupport.ru/showthread.php?postid=382378#post382378)
Erwin, did I ever tell you you're the BEST?? I belive I did in an E-Mail long ago...That did the trick...Now, if I could only import the 154,000 posts from my other Database, I'd be set...:(

Also remember to back up daily.

Look in my profile for a hack that automatically repairs this type of database error.