mysql errors
 

Any ideas what this error means? I get it when trying to read PM's.


Database error in vBulletin 3.0.5:

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, 25

mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Monday 28th of March 2005 06:18:50 AM
Script: http://www.letsgokings.com/bbs/private.php?
Referer: http://www.letsgokings.com/bbs/
Username: RinkRat
IP Address: 66.214.41.130





Thanks!


UPDATE---



OK I've determined that it's a space error. I pruned a lot of messages, deleted some logs etc. and repaired the tables, but during the repair I'm getting

postindex Check Warning: Table is marked as crashed and last repair failed
postindex Check Warning: Size of indexfile is: 12792832 Should be: 1024
postindex Check Error: Can't read indexpage from filepos: -1
postindex Check Error: Corrupt
postindex



Is this repairable or should I go to a backup? I hate to go back since it's an old backup.

Search for the error code on www.mysql.com