No announcement yet.

mysql error: Got error 28 from table handler

  • Filter
  • Time
  • Show
Clear All
new posts

  • mysql error: Got error 28 from table handler

    2. PHP version 4.1.2
    3. MySQL version 3.23.53
    4. Apache/webserver version - newest
    5. Server operating system - Linux

    My problem:
    if I click on thread, then I get the following error:

    Database error in vBulletin 2.2.5:
    Invalid SQL:
    post.*,SUM(bookmarks.public) AS bmcount,SUM(bookmarks.counter) AS allhits,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 bookmarks ON bookmarks.userid=user.userid AND bookmarks.public='1'
    WHERE post.postid IN (0,652519,652904,652910)
    GROUP BY post.postid
    ORDER BY dateline
    mysql error: Got error 28 from table handler
    mysql error number: 1030
    Date: Tuesday 04th of February 2003 02:42:44 PM

    Ok. I have try to use repair.php - all table are OK
    I have empty the searchindex table (130MB)

    But i donīt know, how can i clear space via ssh?

    thx 4 any help
    Last edited by cf-soul; Tue 4th Feb '03, 5:06am.

  • #2
    Error code 28 means there's no space left on your device.

    Close your forums immediately. Next, send a letter to your webhost informing them that the MySQL patition ran out of space... they should be able to help you.