Announcement

Collapse
No announcement yet.

DB Error regarding Private Messages

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • DB Error regarding Private Messages

    Database error in vBulletin 3.0.3:

    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=371 AND pm.folderid=0
    ORDER BY pmtext.dateline DESC
    LIMIT 0, 25

    mysql error: Got error -1 from table handler

    mysql error number: 1030

    Date: Saturday 10th of July 2004 02:14:34 PM
    Script: http://www.pokemonfanuniverse.com/forums/private.php?
    Referer: http://www.pokemonfanuniverse.com/forums/private.php
    Does anyone know what would cause this?

  • #2
    Usually a '-1' error means that something happened to the database and MySQL doesn't know how to categorize the problem. Run Repair/Optimize in the Admin CP:

    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.


    Comment

    Loading...
    Working...
    X