Register or have you forgotten your password?
Get the most out of Surmunity, read our tips here! Need an interesting blog to read? You've got to read the Surpass Blog!
| Welcome! Please register to access all of our features.
| PHP, MySQL General PHP questions. Or go to our PHPsuexec Forum >> |
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread |
August 1st, 2003, 10:13 AM
|
#1 (permalink) |
|
Registered User
Fresh Surpasser
Joined in Jun 2003
10 posts
Gave thanks: 0
Thanked 0 times
|
One of my customers is running a YaBB SE bbs and it is getting errors because one of the table files is "in use" all the time.
MySQL said: Can't open file: 'coma_log_clicks.MYI'. (errno: 145) Perhaps restarting MySQL would help, is it possible to do that from the web? server: 209.123.255.117 |
|
    |
|
August 2nd, 2003, 1:11 AM
|
#2 (permalink) |
|
Registered User
Comfy Contributor
Joined in May 2003
Lives in Florida
118 posts
Gave thanks: 0
Thanked 0 times
|
Error 145 is corrupt data/table. Try repairing the table, run this query on the database:
Code:
REPAIR TABLE coma_log_clicks
__________________
Profession: Programmer, Gamer, Web Developer Website: http://www.reanimated.net/ - Server: Quela |
|
|
|
|
August 5th, 2003, 10:32 AM
|
#3 (permalink) | |
|
Registered User
Fresh Surpasser
Joined in Jun 2003
10 posts
Gave thanks: 0
Thanked 0 times
|
Quote:
|
|
|
|
|
Aug 1 2003, 11.11 pm|
August 5th, 2003, 6:09 PM
|
#4 (permalink) |
|
Registered User
Comfy Contributor
Joined in May 2003
Lives in Florida
118 posts
Gave thanks: 0
Thanked 0 times
|
:P The error might come up again, he/you just has to repair it again; eventually it'll get fully repaired.
__________________
Profession: Programmer, Gamer, Web Developer Website: http://www.reanimated.net/ - Server: Quela |
|
|
|
