No announcement yet.

mysql errors

  • Filter
  • Time
  • Show
Clear All
new posts

  • mysql errors

    ive read the topic above refering to common errors for mysql but not knowing anything about mysql and mine being slightly different i need some help,

    Database error in vBulletin: Invalid SQL:
    session.userid AS sessionuserid,
    post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
    attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
    ,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
    FROM post
    LEFT JOIN icon ON icon.iconid=post.iconid
    LEFT JOIN user ON user.userid=post.userid
    LEFT JOIN userfield ON userfield.userid=user.userid
    LEFT JOIN avatar ON avatar.avatarid=user.avatarid
    LEFT JOIN customavatar ON customavatar.userid=user.userid
    LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
    LEFT JOIN session ON (session.userid = user.userid
    AND session.userid > 0

    AND session.lastactivity>1000338620)
    WHERE post.postid IN (0,488,781,784,786,872,1098)
    ORDER BY dateline

    mysql error: Got error -1 from table handler
    mysql error number: 1030
    Date: Thursday 13th of September 2001 01:05:20 AM
    Script: /forums/showthread.php?s=&threadid=88
    mysql version 3.22.32

    PHP Version 4.0.4pl1

    Server Linux

    im getting this error, its started happening over the last 3 days, but sometimes the forum comes back to life, is this a lack of disk space like mentioned above or is my db broken
    Last edited by xcal; Wed 12th Sep '01, 4:17pm.

  • #2
    I would get that error randomly occasionally -- I'd check the space issue, and if you can, run isamchk on your database (you need to shutdown MySQL to do that though).


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