Announcement

Collapse
No announcement yet.

Database Error! - what does this mean?

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

  • Database Error! - what does this mean?

    Hi.

    I recently made my forums live and I checked my email this morning an got 3 database error emails with the errors dated at 10:42 am


    Here they are:

    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 user.invisible = 0
    AND session.lastactivity>1007306821)
    WHERE post.postid IN (0,79)
    ORDER BY dateline

    mysql error: Got error 28 from table handler
    mysql error number: 1030
    Date: Sunday 02nd of December 2001 10:42:01 AM
    Script: /showthread.php?threadid=63
    Referer: http://66.78.40.13/forumdisplay.php?forumid=118


    2

    Database error in vBulletin: Invalid SQL:
    SELECT DISTINCT
    session.userid AS sessionuserid,
    announcementid,startdate,enddate,announcement.title,pagetext,user.*,userfield.*
    ,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
    FROM announcement
    LEFT JOIN user ON user.userid=announcement.userid
    LEFT JOIN userfield ON userfield.userid=announcement.userid
    LEFT JOIN avatar ON avatar.avatarid=user.avatarid LEFT JOIN customavatar ON customavatar.userid=announcement.userid
    LEFT JOIN session ON (session.userid = announcement.userid
    AND session.userid <> 0
    AND user.invisible = 0
    AND session.lastactivity>1007306832)
    WHERE startdate<='1007307732' AND enddate>='1007307732' AND (announcement.forumid='118' OR announcement.forumid='116' OR announcement.forumid='635' OR announcement.forumid='-1') ORDER BY startdate DESC
    mysql error: Got error 28 from table handler
    mysql error number: 1030
    Date: Sunday 02nd of December 2001 10:42:12 AM
    Script: /announcement.php?forumid=118
    Referer: http://66.78.40.13/forumdisplay.php?forumid=118


    3

    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 user.invisible = 0
    AND session.lastactivity>1007306839)
    WHERE post.postid IN (0,78)
    ORDER BY dateline

    mysql error: Got error 28 from table handler
    mysql error number: 1030
    Date: Sunday 02nd of December 2001 10:42:19 AM
    Script: /showthread.php?threadid=62
    Referer: http://66.78.40.13/forumdisplay.php?forumid=118



    Does anyone know what the error is? could it be that the server was down at the time?

    Also - am I creating a security risk by posting this code?

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

    You need to shut down your forums and contact your host immediately. The partition containing the MySQL databases is out of 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


    • #3
      Hi Smachol,

      Thanks for replying.

      I contacted the hosting provider and he doesn't think it is an "out of space" issue

      The partition is only 67% full.

      "Disk /hda6 (/var) 67 % "


      Are there any other possibilities?

      Comment


      • #4
        Nope - the error is pretty clear: "No space left on device"

        It's possible that a bunch of space cleared up by the time you contacted them. Keep an eye on it and if it happens again - don't let them tell you there's no problem!
        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