Log in

View Full Version : Error..please help...

410
10-21-2002, 01:49 AM
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:
Xenon
10-21-2002, 07:27 AM
go into PHPmyadmin and run this:
REPAIR privatemessage
Dean C
10-21-2002, 07:43 AM
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
410
10-21-2002, 01:10 PM
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!
Xenon
10-21-2002, 04:43 PM
hmm, you can also upload the file repair.php in your vb-zip and run it, i think this could also do the queryie
DrkFusion
10-21-2002, 05:05 PM
How exactly does the REPAIR sql actually repair a table?
-Arunan
Chris M
10-21-2002, 05:09 PM
It recreates any missing tables...

Satan
Steve Machol
10-21-2002, 05:12 PM
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.