Announcement

Collapse
No announcement yet.

What the hell...

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

  • What the hell...

    I just visited my forums and I cant open ANY threads, I get this error...

    --

    There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.


    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>1005608256)
    WHERE post.postid IN (0,551,554,556)
    ORDER BY dateline

    mysql error: Can't create/write to file '/var/tmp/#sql138e2_c751_0.MYI' (Errcode: 28)
    mysql error number: 1
    Date: Monday 12th of November 2001 11:52:38 PM
    Script: /ffh/upload/showthread.php?threadid=69
    Referer: http://voracia.com/ffh/upload/forumd....php?forumid=3



    Somebody help, PLZ!!

  • #2
    i THINK errcode 28 is related to disk space, if I remember correctly.

    You may want to contact your host to verify suficient disk space etc....

    Comment


    • #3
      yes its a No space left on device error
      MCSE, MVP, CCIE
      Microsoft Beta Team

      Comment


      • #4
        Make sure they have chmod'd the /var/tmp dir to 777.......



        [EDIT]
        Woohoo 400th post.....
        [/EDIT]

        Comment


        • #5
          Originally posted by The Prohacker
          Make sure they have chmod'd the /var/tmp dir to 777.......



          [EDIT]
          Woohoo 400th post.....
          [/EDIT]
          congrats

          as to error 28.. contact your host - since this is most likely an out of disk space in your mysql data partition
          :: Always Back Up Forum Database + Attachments BEFORE upgrading !
          :: Nginx SPDY SSL - World Flags Demo [video results]
          :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

          Comment


          • #6
            Ok I have unlimited disk space on my server...so I dont think that could be the problem

            Comment


            • #7
              There's no such thing as unlimited disk space. The error is clear. The server has run out of space on the partition holding the mySQL databases.
              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


              • #8
                Originally posted by griever
                Ok I have unlimited disk space on my server...so I dont think that could be the problem
                Hah! Ask your host if your mySQL database counts towards your disk space ... some webhosts limit mySQL db sizes to 10MB...

                And yeah, no such thing as unlimited disk space
                OPEN TECH SUPPORT
                "Tech is our middle name!"

                Comment


                • #9
                  Problem Fixed, I talked to the server admin and he concluded that it was just a connectivity problem at the time. Its back up and running now, thx alot guys for your help!!

                  Comment

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