Announcement

Collapse
No announcement yet.

mysql errors

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

  • Mike Sullivan
    replied
    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).

    Leave a comment:


  • xcal
    started a topic mysql errors

    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:
    SELECT
    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
    Referer: http://www.rtcw.uklinux.net/forums/f...p?s=&forumid=2
    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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X