Mysql error

[rinkrat]

Any idea what would be causeing this on my entire site?

Database error in vBulletin 3.0.3:

Invalid SQL: select count(*) as new_posts from post where dateline > '1095591934'
mysql error: Can't open file: 'post.MYI'. (errno: 144)

mysql error number: 1016

Here's a log entry before the crash that may be related:

/cache/09075d7a2a86bffc5dca78cc3e41feb9
[Sun Sep 19 03:04:12 2004] [error] Cache unable to open file for writing: ./cache/507a8cbc0c95be3bb866bfa4f13f3c2b
[Sun Sep 19 03:04:12 2004] [error] Cache unable to open file for writing: ./cache/81f5a729422e780876a448e48d44b7f0
[Sun Sep 19 03:04:13 2004] [error] Cache unable to open file for writing: ./cache/41ce944ee47f04f536fd2472f85b0e0e
[Sun Sep 19 03:04:13 2004] [error] Cache unable to open file for writing:

Thanks for any help!

[Boofo]

Try repairing your post table and see if that fixes it.

REPAIR TABLE post;

[rinkrat]

I'll try that.

Here's a log entry before the crash that may be related:

/cache/09075d7a2a86bffc5dca78cc3e41feb9
[Sun Sep 19 03:04:12 2004] [error] Cache unable to open file for writing: ./cache/507a8cbc0c95be3bb866bfa4f13f3c2b
[Sun Sep 19 03:04:12 2004] [error] Cache unable to open file for writing: ./cache/81f5a729422e780876a448e48d44b7f0
[Sun Sep 19 03:04:13 2004] [error] Cache unable to open file for writing: ./cache/41ce944ee47f04f536fd2472f85b0e0e
[Sun Sep 19 03:04:13 2004] [error] Cache unable to open file for writing:

[rinkrat]

Also, how can I repair it when the board is down? I tried repair.php bit it had the same error.

[rinkrat]

Ahh... I'll try repair table thx

[rinkrat]

lgk2.post repair warning Number of rows changed from 20180 to 31645
lgk2.post repair status OK


That worked!! Thanks. I'll back up real fas in case it happens again :)

[Boofo]

lgk2.post repair warning Number of rows changed from 20180 to 31645
lgk2.post repair status OK


That worked!! Thanks. I'll back up real fas in case it happens again :)
The error you got means the post table got corrupted somehow. Doing a REPAIR on a corrupted table usually works. ;)

[Odysseus]

Here's a log entry before the crash that may be related:


/cache/09075d7a2a86bffc5dca78cc3e41feb9
[Sun Sep 19 03:04:12 2004] [error] Cache unable to open file for writing: ./cache/507a8cbc0c95be3bb866bfa4f13f3c2b
[Sun Sep 19 03:04:12 2004] [error] Cache unable to open file for writing: ./cache/81f5a729422e780876a448e48d44b7f0
[Sun Sep 19 03:04:13 2004] [error] Cache unable to open file for writing: ./cache/41ce944ee47f04f536fd2472f85b0e0e
[Sun Sep 19 03:04:13 2004] [error] Cache unable to open file for writing:


This has nothing to do with your crash.These error logs are created by the magpie RSS hack, which you might have installed. See also there:
https://vborg.vbsupport.ru/showthread.php?p=806356#post806356