Vb 2.3.2 Tons of database errors!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • stocker340
    New Member
    • Dec 2002
    • 13

    Vb 2.3.2 Tons of database errors!

    Hello all

    I have the old VB 2.3.2 version and I am getting a ton of database errors and have been getting them e-mailed to me all the time many a day.
    What can I do about this problem?
    Below is an example
    I am hosted on webhsp at www.superstockforum.com

    Thxs

    Dale


    Database error in vBulletin 2.3.2:

    Invalid SQL: SELECT thread.title,thread.threadid,thread.forumid,postid,post.dateline FROM post,thread WHERE thread.threadid=post.threadid AND thread.visible = 1 AND post.userid='640' ORDER BY post.dateline DESC LIMIT 20 mysql error: Got error 134 from storage engine

    mysql error number: 1030

    Date: Wednesday 03rd of December 2008 10:21:44 PM
    Script: http://www.superstockforum.com/membe...threadid=10501
    Referer:
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    MySQL error code 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 -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue


    (Actual link may be different in vB 2.)

    If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.

    If that doesn't work then this may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:



    You may have to ask your host to try and repair this for you.

    Note: vB 2.x is end-of-life and no longer supported. I strongly recommend that you upgrade to the latest stable version as soon as possible.
    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

    • stocker340
      New Member
      • Dec 2002
      • 13

      #3
      No admin CP

      Whereis admin cp?
      I have my control panel open but see nothing about admincp?

      Comment

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

        #4
        That would be the 'admin' directory in vB 2.
        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

        • stocker340
          New Member
          • Dec 2002
          • 13

          #5
          nothin like that

          Damn

          I cannot see anythung that controls itemin your original reply

          Much appreciated

          Comment

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

            #6
            Then you will need to use one of the other repair options I mentioned.
            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...