Announcement

Collapse
No announcement yet.

MySQL error 1030 and

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

  • MySQL error 1030 and

    I'm MySQL database email errors sent to me, below are the two errors:


    Database error in vBulletin 2.3.0:
    Invalid SQL:
    SELECT DISTINCT post.userid, post2.pagetext as pagetext, icon.title as icontitle,icon.iconpath,
    thread.threadid,thread.title,lastpost, forumid,pollid,open,replycount,postusername,postuserid,
    lastposter,thread.dateline,views,thread.iconid,notes,thread.visible,sticky,votetotal,attac h
    FROM thread
    LEFT JOIN icon ON (icon.iconid = thread.iconid)
    LEFT JOIN post ON (thread.threadid = post.threadid AND post.userid = '2745' AND post.visible = 1) LEFT JOIN post AS post2 ON (thread.firstpostid = post2.postid)
    WHERE thread.threadid IN (0,13156,13058,10121,13133,13132,13111,13038,13023,12561,13044,13043,12842,12693,12276,130 11,12622,12960,12464,12922,12968,12870,12175,12961,12920,12341,12497,12717,12573,12738,127 74,8210,12701,12564,149,11579)
    ORDER BY sticky DESC, lastpost DESC

    mysql error: Got error 28 from table handler

    mysql error number: 1030


    AND THIS


    Database error in vBulletin 2.3.0:

    Invalid SQL: SELECT * FROM forum,subscribeforum WHERE subscribeforum.forumid=forum.forumid AND userid=3429 ORDER BY title
    mysql error: Got error 28 from table handler

    mysql error number: 1030


    Can anyone tell me what causes these and how to go about fixing them? I just ran repair.php and that doesn't seem to do anything for the errors.


    -Michael
    Debt-Made-Easy.com: Get out and stay out of debt.

  • #2
    Error code 28: No space left on device

    One or more partitions on your server is out of space or doesn't have enough space to complete this operation. Shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.
    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

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