No announcement yet.

Problems with PM's

  • Filter
  • Time
  • Show
Clear All
new posts

  • Problems with PM's

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

    Database error in vBulletin 3.0.6:
    Invalid SQL:
    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

    And then I went to Admin CP > Import % Maintenance >
    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
    Last edited by jilly; Sun 18 Dec '05, 8:50am.

  • #2
    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
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    • #3
      pm receipt

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


      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.