Database error

[tinbin]

There is an error in my database and i can't find how come..
I didn't install any hack or modification for the last weeks...

The URLs in the mail also point to a wrong URL:
/forum/~awesome-/forum/index.php

It just has to be forum/index.php

Can anyone give me a clue what causes this error?
Here's the mail:
--------------
Subject: vBulletin (forum) Database error!
All headers
Database error in vBulletin 2.2.9:

Invalid SQL: SELECT count(*) AS messages FROM privatemessage WHERE userid=1209 AND dateline>1053245729 AND
folderid=0
mysql error: Can't open file: 'privatemessage.MYI'. (errno: 145)

mysql error number: 1016

Date: Sunday 18th of May 2003 04:50:06 AM
Script: http://www.awesome-forums.com/forum/~awesome-/forum/index.php?
Referer:






[Sun May 18 04:37:46 2003] [error] [client 195.92.168.169] File does not exist: /home/awesome-/public_html/404.shtml
[Sun May 18 04:37:46 2003] [error] [client 195.92.168.169] File does not exist: /home/awesome-
/public_html/forum/plasma/back.gif
[Sun May 18 04:37:34 2003] [error] [client 195.92.168.169] File does not exist: /home/awesome-/public_html/404.shtml
[Sun May 18 04:37:34 2003] [error] [client 195.92.168.169] File does not exist: /home/awesome-
/public_html/forum/plasma/strip_back.gif
[Sun May 18 04:37:30 2003] [error] [client 195.92.168.169] File does not exist: /home/awesome-/public_html/404.shtml
[Sun May 18 04:37:30 2003] [error] [client 195.92.168.169] File does not exist: /home/awesome-
/public_html/forum/plasma/back.gif
[Sun May 18 04:07:39 2003] [error] [client 81.107.14.132] File does not exist: /home/awesome-/public_html/404.shtml
[Sun May 18 04:07:39 2003] [error] [client 81.107.14.132] File does not exist: /home/awesome-/public_html/forum/plasma/back.gif
[Sun May 18 04:07:25 2003] [error] [client 81.107.14.132] File does not exist: /home/awesome-/public_html/404.shtml
[Sun May 18 04:07:25 2003] [error] [client 81.107.14.132] File does not exist: /home/awesome-
/public_html/forum/plasma/strip_back.gif
[Sun May 18 04:07:24 2003] [error] [client 81.107.14.132] File does not exist: /home/awesome-/public_html/404.shtml
[Sun May 18 04:07:24 2003] [error] [client 81.107.14.132] File does not exist: /home/awesome-/public_html/forum/plasma/back.gif
[Sun May 18 04:06:56 2003] [error] [client 81.107.14.132] File does not exist: /home/awesome-/public_html/404.shtml
[Sun May 18 04:06:56 2003] [error] [client 81.107.14.132] File does not exist: /home/awesome-/public_html/forum/plasma/back.gif
[Sun May 18 04:06:39 2003] [error] [client 81.107.14.132] File does not exist: /home/awesome-/public_html/404.shtml
[Sun May 18 04:06:39 2003] [error] [client 81.107.14.132] File does not exist: /home/awesome-/public_html/forum/plasma/back.gif

--------------

[Xenon]

REPAIR privatemessage

try to run this query one or several times and it should work again

[tinbin]

This is what i get in phpMyAdmin:

Error

SQL-query :

REPAIR privatemessage

MySQL said:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'privatemessage' at line 1
Back

[Boofo]

Try (Backup first):

REPAIR TABLE privatemessage;

[tinbin]

Thanks a lot!
This seems to work :)
Will check if everything still works, but on the first sight everything seems back ok...

Thx a lot pal!!

[Boofo]

No problem. ;) Xenon did all the hard work. ;)

[Xenon]

damn forgotten words ^^

btw. there is a repair.php in the vb.zip.
whenever you see a .MYD error of MySQL you should run it :)