Announcement

Collapse
No announcement yet.

ARG! Problems out of nowhere! HELP!

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

  • ARG! Problems out of nowhere! HELP!

    okay this just popped out of nowhere?!?
    any ideas WHATS going on?

    http://www.form-kaos.com/forums/show...?threadid=3693

    snyx
    MSN: [email protected] | MAIL: [email protected] | FOLIO: mholman.com

  • #2
    I get this when I try to get into a thread.

    <!-- 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 custom

    then this when I refresh

    avatar 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>1000872710)
    WHERE post.postid IN (0,36499,36504,36508,36510,36522,36523,36528,36536)
    ORDER BY dateline

    mysql error: Got error 28 from table handler
    mysql error number: 1030
    Date: Wednesday 19th of September 2001 12:26:50 AM
    Script: /forums/showthread.php?postid=36536
    Referer: http://www.form-kaos.com/forums/index.php?
    -->
    </td></tr></table>
    <p>There seems to have been a slight problem with the database.
    Please try again by pressing the refresh button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p><pre>

    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>1000872710)
    WHERE post.postid IN (0,36499,36504,36508,36510,36522,36523,36528,36536)
    ORDER BY dateline

    mysql error: Got error 28 from table handler
    mysql error number: 1030
    Date: Wednesday 19th of September 2001 12:26:50 AM
    Script: /forums/showthread.php?postid=36536
    Referer: http://www.form-kaos.com/forums/index.php?


    </pre>HTTP/1.1 200 OK
    Date: Wed, 19 Sep 2001 04:26:52 GMT
    Server: Apache/1.3.17 (Unix) mod_bwlimited/0.8 PHP/4.0.4pl1 mod_log_bytes/0.2 mod_frontpage/3.0.4.3 mod_ssl/2.8.0 OpenSSL/0.9.5a
    X-Powered-By: PHP/4.0.4pl1
    Content-Length: 40
    Set-Cookie: bbthreadview[3810]=1000873612; path=/
    Keep-Alive: timeout=15, max=99
    Connection: Keep-Alive
    Content-Type: text/html


    <!-- 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>1000872712)
    WHERE post.postid IN (0,36499,36504,36508,36510,36522,36523,36528,36536)
    ORDER BY dateline

    mysql error: Got error 28 from table handler
    mysql error number: 1030
    Date: Wednesday 19th of September 2001 12:26:52 AM
    Script: /forums/showthread.php?postid=36536
    Referer: http://www.form-kaos.com/forums/index.php?
    -->
    </td></tr></table>
    <p>There seems to have been a slight problem with the database.
    Please try again by pressing the refresh button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p><pre>

    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>1000872712)
    WHERE post.postid IN (0,36499,36504,36508,36510,36522,36523,36528,36536)
    ORDER BY dateline

    mysql error: Got error 28 from table handler
    mysql error number: 1030
    Date: Wednesday 19th of September 2001 12:26:52 AM
    Script: /forums/showthread.php?postid=36536
    Referer: http://www.form-kaos.com/forums/index.php?


    </pre>
    MSN: [email protected] | MAIL: [email protected] | FOLIO: mholman.com

    Comment


    • #3
      error 28 is out of disk space i believe... is your partition for mysql full ?
      :: 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


      • #4
        well here is the thing, I was fine, then I tried to switch my GZIP from 1-5, then I left it for a few hours, heard there was a problem, then switched it back. (didnt work) could that have done it?
        MSN: [email protected] | MAIL: [email protected] | FOLIO: mholman.com

        Comment


        • #5
          not sure leave gzip at 1... but i'd check your partitions for disk usage

          in telnet type

          df

          and see if any partitions are at 100%
          :: 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
            I got this.
            Filesystem 1k-blocks Used Available Use% Mounted on
            /dev/hda6 1517920 264748 1176064 18% /
            /dev/hdb1 19243740 32 18266156 0% /backup
            /dev/hda1 54416 5007 46600 10% /boot
            /dev/hda9 13630404 9131876 3806132 71% /home
            /dev/hda5 2016016 1913660 0 100% /usr
            /dev/hda7 1011928 365252 595272 38% /var
            MSN: [email protected] | MAIL: [email protected] | FOLIO: mholman.com

            Comment


            • #7
              yup your /usr partition is 100% full which is probably where mysql data is right?

              you need to

              1. move mysql to a larger parition
              2. free space in /usr partition
              3. ask your host to help you
              4. if that doesn't work - move hosts
              :: 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


              • #8
                I have a feeling number 4 is coming.
                MSN: [email protected] | MAIL: [email protected] | FOLIO: mholman.com

                Comment

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