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
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
Comment