Private Message Error

[Mr Morningstarr*]

Hi, I'm getting this message when trying to access my private messages:

Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=1 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50;

MySQL Error : Got error -1 from storage engine
Error Number : 1030
Date : Wednesday, September 19th 2007 @ 03:02:04 AM
Script : http://www.morningstarr.co.uk/forum/private.php
Referrer : http://www.morningstarr.co.uk/forum/...ok-like-2.html
IP Address : **************
Username : Mr Morningstarr*
Classname : vb_database


I'm about to contact my host too, but wondered if anyone here knew the reason for it.

I've searched a few threads, but most people seem to get an error 28 message so I'm not sure if this is the same.

Any help is appreciated.

[Colin F]

As far as I know error -1 means that MySQL encountered an unknown error. Try repairing those three tables by running these queries:

REPAIR TABLE pm;
REPAIR TABLE pmtext;
REPAIR TABLE icon;

If that doesn't work then you should contact your host and have them look into this.

[Mr Morningstarr*]

Sorry Colin, I've only just got back to this.

I contacted my host and they sorted it out. Thanks for the advice though.