Error: 124 MySql Error: 1030

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • NoFixxxer
    Member
    • Feb 2002
    • 33

    Error: 124 MySql Error: 1030

    Can anyone please tell me what I need to do to repair this? Thanks in advance.

    Database error in vBulletin 2.2.5:

    Invalid SQL: SELECT user.*
    FROM subscribethread,user
    WHERE subscribethread.threadid='5197'
    AND subscribethread.userid=user.userid
    AND user.userid<>'1'
    AND user.lastactivity>'1020162230'
    mysql error: Got error 124 from table handler

    mysql error number: 1030

    Date: Tuesday 30th of April 2002 04:49:20 PM
    Script: http://www.dssarea51.com/forums/forums/newreply.php
    Referer: http://www.dssarea51.com/forums/newr...&threadid=5197
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Wow - I've never seen this error before:

    Error code 124: Wrong medium type
    124 = Wrong index given to function
    What were you doing when you got this error?
    What versions of vB, PHP and MySQL are you running?
    Have you installed any hacks?
    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

    • NoFixxxer
      Member
      • Feb 2002
      • 33

      #3
      PHP 4.0.6, not sure about SQL, and Yes I have many hacks installed. Everything was working fine up until about an hour ago.

      The error pops up EVERYTIME someone replies to a thread, and trys to save the message.

      Any help is deeply appreciated.

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        Try reuploading a fresh copy of newreply.php.
        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

        • NoFixxxer
          Member
          • Feb 2002
          • 33

          #5
          I uploaded a fresh copy of newreply.php and this is now what I get


          Database error in vBulletin 2.2.5:

          Invalid SQL: INSERT INTO subscribethread (subscribethreadid,userid,threadid) VALUES (NULL,2,4759)
          mysql error: Duplicate entry '17360' for key 1

          mysql error number: 1062

          Date: Tuesday 30th of April 2002 05:13:25 PM
          Script: http://www.dssarea51.com/forums/forums/newreply.php
          Referer: http://www.dssarea51.com/forums/newr...&threadid=4759

          Comment

          • George L
            Former vBulletin Support
            • May 2000
            • 32996
            • 3.8.x

            #6
            Originally posted by NoFixxxer
            I uploaded a fresh copy of newreply.php and this is now what I get


            Database error in vBulletin 2.2.5:

            Invalid SQL: INSERT INTO subscribethread (subscribethreadid,userid,threadid) VALUES (NULL,2,4759)
            mysql error: Duplicate entry '17360' for key 1

            mysql error number: 1062

            Date: Tuesday 30th of April 2002 05:13:25 PM
            Script: http://www.dssarea51.com/forums/forums/newreply.php
            Referer: http://www.dssarea51.com/forums/newr...&threadid=4759
            1. you need to upload repair.php from your vB zip file to your /admin directory and run this url

            yourdomain.com/admin/repair.php?html=1&check=1

            2. or using mysqlcheck repair for 3.23.38 and above

            i.e. in shell/telnet/ssh type while mysql is running and forum is CLOSED:

            mysqlcheck -r -u mysqlusername -p databasename

            3. or via myisamchk repair functions while mysql is shutdown/stopped in shell/telnet/ssh type :

            myisamchk -r -u root -p databasename

            option #3 most likely requires server and mysql root access to first stop mysql and then run myisamchk repair options.
            :: 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

            • NoFixxxer
              Member
              • Feb 2002
              • 33

              #7
              Ok, I ran Repair.php and that fixed that problem. now when I try to backup the database, I get this message:


              Database error in vBulletin Control Panel 2.2.5:

              Invalid SQL: SELECT * FROM nuke_referer
              mysql error: Got error 127 from table handler

              mysql error number: 1030

              Date: Tuesday 30th of April 2002 05:41:58 PM
              Script: http://www.dssarea51.com/forums/forums/admin/backup.php
              Referer: http://www.dssarea51.com/forums/admi...?action=choose

              Comment

              • Steve Machol
                Former Customer Support Manager
                • Jul 2000
                • 154488

                #8
                Error code 127: Unknown error 127
                127 = Record-file is crashed


                Run repair.php again until all tables report 'OK'. Also be aware that while backing up via the Admin CP can be fine for smallers databases, it can produce errors and incomplete backups with larger databases. The most reliable way to backup and restore a db is with shell access via telnet or SSH. Instructions are here:

                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

                • NoFixxxer
                  Member
                  • Feb 2002
                  • 33

                  #9
                  Thanks guys. Appreciated.

                  Comment

                  • Steve Machol
                    Former Customer Support Manager
                    • Jul 2000
                    • 154488

                    #10
                    No problem. Good luck!
                    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...