Announcement

Collapse
No announcement yet.

MySQL error ??

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

  • MySQL error ??

    Before my MySQL DB table:word error.
    so I fixed it.

    But now...I can't access VBB..
    I get:

    Database error in vBulletin: Invalid SQL: SELECT template FROM template WHERE title='options'
    mysql error: Got error 127 from table handler
    mysql error number: 1030
    Date: Friday 27th of July 2001 03:17:55 PM
    Script: /forum/index.php
    Referer:


    can anyone teach me what happen and how can I do ?


    Thanks.

  • #2
    Error 127 means corruption. You can try uploading the file repair.php from the extras directory of the vB2 zip file and running it.

    Comment


    • #3
      Thank you for your help.

      But I had run repair.php?check=1

      I still get :

      Warning: MySQL: Unable to save result set in /home/sites/site74/web/forum/admin/db_mysql.php on line 93

      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.


      ==============================
      And in EMail say:

      Database error in vBulletin: Invalid SQL: SELECT template FROM template WHERE title='options'
      mysql error: Got error 127 from table handler
      mysql error number: 1030
      Date: Friday 27th of July 2001 04:31:09 PM
      Script: /forum/repair.php?check=1&iterations=4
      Referer:




      What wrong of my DB ?
      Do there has other method to fix it?

      Can help me please? Thanks.

      Comment


      • #4
        Hmmm...127 might be out of space...Are you on a shared host or a dedicated server?

        Comment


        • #5
          I give money for my virtaul hosting.
          I have 1G space.

          I am sure it will not out of space.


          Before it is work OK.
          Suddenly one day, my word table has error.
          so I ask the technical support to fix it.

          After they fixed it. I get this error..

          Comment


          • #6
            It wouldn't be space on your account (although I would pay money to see you use 1 gig and see what the host says) but on the MySQL partition that is causing the error if that is truly the culprit.

            I would suggest asking your host to try to fix this too.

            Comment


            • #7
              Thank you for your help again.

              But I am sure before my DB error, the size is just larger than about 22K.

              Now my DB size is 92X KB.

              I also use PHPMyAdmin to access my DB. It is OK.

              ====Quite Strange=====

              Comment


              • #8
                Is it suitable for me to install vBulletin again?

                Comment


                • #9
                  ask your host to run a myisamchk repair on your forum database

                  check here
                  http://i4net.tv/marticle/get.php?act...le&articleid=7

                  http://i4net.tv/marticle/get.php?act...le&articleid=4

                  http://www.mysql.com/documentation/m...toc.html#Check
                  :: 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


                  • #10
                    When my table:word has error.
                    My technical support had do that.

                    After this. I can't access to my forum.

                    That's why ??

                    I sure that now my DB is OK.
                    Because I can use PHPMyADmin to browse it.

                    Comment

                    Loading...
                    Working...
                    X