Error..please help...
 

My Cpanel works, but when I go to my index.php it gives me this error. I didn't do anything to cause this, my server went down, and when it came back up, this happened....

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=7
mysql error: Can't open file: 'privatemessage.MYD'. (errno: 145)

mysql error number: 1016

Date: Sunday 20th of October 2002 05:10:33 PM
Script: http://www..com/forums//forums/index.php?s=
Referer:

go into PHPmyadmin and run this:
[sql]REPAIR privatemessage[/sql]

and if you haven't got any hacks installed i'd reccomend upgrading to 2.2.8 anyway as it fixes lots of bugs..

- miSt

I ran that and now it says this...

Error

SQL-query :

REPAIR privatemessage

MySQL said:

You have an error in your SQL syntax near 'privatemessage' at line 1

Back

Thanks for your help!

hmm, you can also upload the file repair.php in your vb-zip and run it, i think this could also do the queryie

How exactly does the REPAIR sql actually repair a table?
-Arunan

It recreates any missing tables...

Satan

Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

http://www.yourdomain/forum/admin/repair.php?html=1&check=1

[Of course change the exact URL as appropriate for your forums.]

If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok. See if this fixes the problem.