what does this mean ?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pestilence
    Member
    • Feb 2001
    • 72
    • 3.0.0 'Gold'

    what does this mean ?

    board was fine last night then boom ?


    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>998221193)
    WHERE post.postid IN (0,41)
    ORDER BY dateline

    mysql error: Got error 28 from table handler
    mysql error number: 1030
    Date: Sunday 19th of August 2001 07:54:53 AM
  • JamesUS
    Senior Member
    • Aug 2000
    • 4622

    #2
    Error 28 tends to indicate a lack of free disk space on the MySQL Partition (usually /var on the server) - you really need to ask your host about this one I'm afraid.

    Comment

    • pestilence
      Member
      • Feb 2001
      • 72
      • 3.0.0 'Gold'

      #3
      Thanx jamesus

      Filesystem 1k-blocks Used Available Use% Mounted on
      /dev/hda1 248895 246977 0 100% /
      /dev/hda5 41429332 34343996 4980824 87% /home
      /dev/hda6 2016016 1807972 105632 94% /usr
      /dev/hda7 521748 437760 57484 88% /var

      thats the info i got from the shell

      Comment

      • tubedogg
        Senior Member
        • Feb 2001
        • 13602

        #4
        Re: Thanx jamesus

        Originally posted by pestilence
        /dev/hda7 521748 437760 57484 88% /var
        This is the problem - as MySQL is working, it creates temporary files and so it could very quickly fill up that space.

        Comment

        • pestilence
          Member
          • Feb 2001
          • 72
          • 3.0.0 'Gold'

          #5
          Thanx Kevin

          thanx a lot
          waiting on them getting back to me

          Comment

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