Announcement

Collapse
No announcement yet.

problem

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

  • problem

    Well, another f'ing msql database problem, i am getting extremely fed up with this, and i hear UBB calling me, cause i get this alot.

    This time:

    Members cant view any threads posted. Any idea what the f*** is going on?or any way of fixing it, before i give up and go to UBB. Thanks

  • #2
    How is anyone supposed to be able to help you if you don't post what the MySQL error message is?
    Rob

    Comment


    • #3
      Can you provide us with a bit more information, like vB version, PHP and mySQL versions, and a URL where the problem is occuring?

      Also please update your profile with your license info.
      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
        i closed the forums, because i was getting alot of those freaking e-mails, the URL is

        http://lindblum.futureff.com


        the error e-mail is ::


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

        mysql error: Got error 28 from table handler
        mysql error number: 1030
        Date: Wednesday 25th of July 2001 06:27:30 PM
        Script: /showthread.php?threadid=265
        Referer: http://lindblum.futureff.com/forumdisplay.php?forumid=2



        the version is 2.0.0

        PHP / MSQL version 5 (i think)

        thats about it...

        Comment


        • #5
          Error 28 means the partition is out of space.

          Are you on a shared host or a dedicated server?

          Comment


          • #6
            shared

            does this mean i cant fix it?

            Comment


            • #7
              You should contact your host and ask them how much space is left in the MySQL partition, and tell them you are receiving that error and ask them if they could look into it.

              Other than that, no there's nothing you can really do.

              Comment


              • #8
                It means you need to talk to your host. They're the only ones that can fix this. Good luck!

                And don't forget to add your license info to your profile.
                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


                • #9
                  Who is your hosting provider?
                  Rob

                  Comment


                  • #10
                    what do u mean with the sig thing?

                    And i'm with hostrocket

                    Comment


                    • #11
                      Read my new post in this Forum about receiving database errors.
                      Rob

                      Comment


                      • #12
                        yea, i read that. Thank you does that mean they should be able to fix it soon?

                        Comment


                        • #13
                          I don't know. This is all I was able to find on their support forums:

                          "This will hopefully be a temporary thing but we have had many reports of intermittant apache outages which are being caused by errors related to mod_gzip so until were certain it wont continue to do this we are disabling it. Its better to have the pages get there using a little more bandwidth than not at all. "
                          Rob

                          Comment

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