Announcement

Collapse
No announcement yet.

Error 1030

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

  • Error 1030

    ----------------------------------------------------

    Database error in vBulletin 2.2.9:

    Invalid SQL:
    SELECT
    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
    WHERE post.postid IN (0,2,3)
    ORDER BY dateline

    mysql error: Got error 28 from table handler

    mysql error number: 1030

    Date: Monday 25th of November 2002 07:47:58 AM
    Script: http://forum.squaregaming.net/showthread.php?threadid=2
    Referer: http://forum.squaregaming.net/forumd....php?forumid=8

    ----------------------------------------------------

    I got that as an error sent to my email. =/
    I don't know what happened, but it won't let me upload avatars, or files. It turns thread with something tha was attempted to be uploaded into an error. Please help if you can.

    Link to my php info.

    http://forum.squaregaming.net/admin/phpinfo.php <---

    This message also happens when trying to upload an avatar.

    -----------------
    vBulletin Message
    There has been an error in the upload. Please ensure that the file has been correctly selected and that the upload has taken place successfully.
    ---------------

    And followed the guidelines I set. Any help would be greatly appreciated.
    Last edited by cid; Mon 25th Nov '02, 5:55am.

  • #2
    A little off-topic comment : is your apache running as root user?


    Does MySQL/PHP have a tmp dir with the correct rights? I think table writing goes wrong when it replies that error. Not sure though.
    It could also be that the tmp partition that mysql is using run out of space.
    Last edited by Floris; Mon 25th Nov '02, 6:48am.

    Comment


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

      The partition containing the database and/or system 'tmp' directory has run out of space. You need to immiediately shoutdown your forums and contact your webhost about this. They need to free up some space on that partition.
      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


      • #4
        Originally posted by Steve Machol
        Error code 28: No space left on device

        The partition containing the database and/or system 'tmp' directory has run out of space. You need to immiediately shoutdown your forums and contact your webhost about this. They need to free up some space on that partition.
        Though I am not a MySQL/PHP guru, I got pretty close

        Is there any way I could (as a none-root) keep an eye on free space on the server (if it runsin safe-mode) ?

        Comment


        • #5
          Originally posted by xiphoid
          Though I am not a MySQL/PHP guru, I got pretty close

          Is there any way I could (as a none-root) keep an eye on free space on the server (if it runsin safe-mode) ?
          If it's a Unix/Linux server, you can run 'df' at the command prompt.
          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


          • #6
            Originally posted by Steve Machol
            If it's a Unix/Linux server, you can run 'df' at the command prompt.
            PHP Code:
            <?php passthru('df'); ?>
            I could try that?

            Comment


            • #7
              That would work. It won't be formatted nicely though.
              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 Steve Machol
                That would work. It won't be formatted nicely though.
                unfortn. it doesn't - white page - guess my admin has disabled the use for it

                Comment


                • #9
                  Thanks so much, I'll check with the admin of the server now.

                  Comment


                  • #10
                    Originally posted by xiphoid
                    unfortn. it doesn't - white page - guess my admin has disabled the use for it
                    It worked for me. I tested this out before replying the first time.
                    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


                    • #11
                      Question, where exactly do I put that PHP tag? =P

                      Comment


                      • #12
                        I wrote it to a file called db.php and uploaded it to my server. Then I ran it from the browser.
                        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