Problems with PM's

[jilly]

If my users try to access their PM's, this is what they are seeing:

Database error in vBulletin 3.0.6:
Invalid SQL:
SELECT
SUM(IF(readtime <> 0, 1, 0)) AS confirmed,
SUM(IF(readtime = 0, 1, 0)) AS unconfirmed
FROM pmreceipt
WHERE userid = 1

mysql error: Can't open file: 'pmreceipt.MYI' (errno: 144)
mysql error number: 1016
Date: Sunday 18th of December 2005 11:34:30 AM
Script: http://www.afterabortion.com/forums/private.php?
Referer: http://www.afterabortion.com/forums/...earchid=770085

And then I went to Admin CP > Import % Maintenance >
Help
Repair / Optimize Tables , and selected pm, pmreciept and pmtext, and clicked the repair and optimize buttons, this is what came up:

pm Check Status: OK
pm Optimize Status: Table is already up to date
pmreceipt Check Warning: Table is marked as crashed and last repair failed
pmreceipt Check Warning: Size of indexfile is: 618496 Should be: 386048
pmreceipt Check Warning: Size of datafile is: 1180364 Should be: 1176088
pmreceipt Check Error: Found key at page -1 that points to record outside datafile
pmreceipt Check Error: Corrupt
pmreceipt

[Steve Machol]

MySQL error: 144 = Table is crashed and last repair failed

To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin CP -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue

[jilly]

pm receipt

my server host repaired the pm reciept table for me, and then it worked..