Private Message Error

  • Time
  • Show
Clear All
new posts
  • Mr Morningstarr*
    New Member
    • Jun 2006
    • 23

    Private Message Error

    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 :
    Referrer :
    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
    Senior Member
    • May 2004
    • 17689

    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 pmtext;
    REPAIR TABLE icon;

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

    Please don't contact me per PM.


    • Mr Morningstarr*
      New Member
      • Jun 2006
      • 23

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

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


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