PDA

View Full Version : +Help+ datebase error


+Fares+
05-19-2003, 02:32 PM
Hello Everone ,
could someone help me with this please...

somthing going on with my forum datebase and i don't know what and how to fix it .. this is the error..

-----------

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT COUNT(*) AS posts FROM post
mysql error: Can't open file: 'post.MYD'. (errno: 145)

mysql error number: 1016

-----------

dose any one can help me with this please ?.

filburt1
05-19-2003, 03:10 PM
Try running the query:

REPAIR TABLE post;

father max
05-23-2003, 01:20 AM
filbert,

do you know if this the same problem as above?

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT COUNT(*) AS count,postuserid,postusername FROM
thread GROUP BY postuserid ORDER BY count DESC LIMIT 1
mysql error: Can't open file: 'thread.MYI'. (errno: 145)

mysql error number: 1016 any idea what causes this? :(

father max
05-23-2003, 01:34 AM
...ha...never mind...i managed to fix it...:)

different query, but same gig: REPAIR TABLE thread;

...i may not be too stupid after all...

:)