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]

Originally Posted by 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

The error you got means the post table got corrupted somehow. Doing a REPAIR on a corrupted table usually works.

[Odysseus]

Originally Posted by rinkrat

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/showthrea...356#post806356