Announcement

Collapse
No announcement yet.

MySQL Error 1030

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

  • MySQL Error 1030

    I receive this error and several variations when I visit my forums. It's been working fine until today.

    Database error in vBulletin 3.5.1:

    Invalid SQL:

    SELECT thread.threadid, thread.title,
    thread.postusername, thread.dateline,
    forum.forumid,
    forum.title AS forumtitle,
    post.pagetext AS preview

    FROM thread AS thread
    INNER JOIN forum AS forum ON(forum.forumid = thread.forumid)
    LEFT JOIN post AS post ON (post.postid = thread.firstpostid)

    WHERE 1=1
    AND thread.forumid IN(6,17,20,3,7,10,22,11,4,9,12,13,14,5,8,18,19,15,23,16)
    AND thread.visible = 1
    AND post.visible = 1
    AND open <> 10

    ORDER BY thread.dateline DESC
    LIMIT 15;

    MySQL Error : Got error 134 from table handler
    Error Number : 1030
    Date : Tuesday, December 13th 2005 @ 09:38:58 AM
    Script : http://www.url.com/forums/external.php?type=js
    Referrer : http://www.url.com
    IP Address : xx.xxx.xxx.xxx
    Username : Unregistered
    Classname : vb_database

  • #2
    MySQL error: 134 = Record was already deleted (or record file crashed)

    To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

    Admin CP -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue
    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


    • #3
      I can't login into the admin cp because of a database error. Any other suggestions?

      Comment


      • #4
        Run this query in phpmyAdmin:

        REPAIR TABLE thread;
        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


        • #5
          I just did that and it doesn't work. I don't know if i did it right though. I selected 'field access' - 'sort descending' 'update query' type in 'REPAIR TABLE thread;' and 'submit query'.

          MySQL returned an empty result set (i.e. zero rows). (Query took 0.0002 sec) SQL query:
          SELECT `access` . *
          FROM access
          LIMIT 0 , 30


          Then I ran the query again below that and I got.

          SQL query SQL query:
          REPAIR TABLE thread [ Edit ] [ Create PHP Code ]
          Table Op Msg_type Msg_text xxxxxx_forums.threadrepairstatusOK


          But my forums still display a database error. Here is another error below.

          Database error in vBulletin 3.5.1:

          Invalid SQL:

          SELECT userid, lastactivity, options, username, user.usergroupid,
          displaygroupid,
          groupa.opentag as opentaga, groupa.closetag as closetaga,
          groupb.opentag as opentagb, groupb.closetag as closetagb
          FROM user as user
          LEFT JOIN usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
          LEFT JOIN usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
          WHERE lastactivity > 1134507671 ORDER BY username;

          MySQL Error : Got error 127 from table handler
          Error Number : 1030
          Date : Wednesday, December 14th 2005 @ 01:01:11 PM
          Script : http://www.url.com
          Referrer : http://www.url.com
          IP Address : 66.45.80.212
          Username : Unregistered
          Classname : vb_database
          Last edited by ncpamike; Sun 18 Dec '05, 12:35am.

          Comment


          • #6
            Huh? There is no way you'd get those errors by running that query to repair the thread table. What exactly did you do and what happened when you did it?

            You will also need to repiar your userid table:

            REPAIR TABLE userid;
            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


            • #7
              I received that error before I ran any query. Sorry for the confusion. I just did what you said and ran the query 'REPAIR TABLE userid;' and it says it doesn't exist.

              Comment


              • #8
                Sorry, that should have been:

                REPAIR TABLE user;
                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
                  Holy ****, It worked! YOU ARE THE MAN!!! THANK YOU SO MUCH!!!

                  To try and prevent this from happening again, do you know what would cause such errors?

                  Comment


                  • #10
                    DB errors are usually caused by server problems or misconfiguration. Theere really isn't any reason to get db errors on a well-maintained and optimized server.
                    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
                      I'm sick of my current host (iPowerWeb). They continue to have problems after problems after problems and not to mention horrible customer support. I don't recommend them to anyone.

                      I'll begin searching for a new host today. If anyone has any suggestions, I would love for you to share them. Who hosts vbulletin.com? These forums are never down!

                      Comment

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