Announcement

Collapse
No announcement yet.

Got error 130 from storage engine Issue

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

  • Got error 130 from storage engine Issue

    Getting the following SQL error when I try visiting my site


    Database error in vBulletin 3.8.4:

    Invalid SQL:

    INSERT INTO taggregate_temp_1258138560
    SELECT threadid, COUNT(*) AS views
    FROM threadviews
    GROUP BY threadid;

    MySQL Error : Got error 130 from storage engine
    Error Number : 1030
    Request Date : Friday, November 13th 2009 @ 12:56:07 PM
    Error Date : Friday, November 13th 2009 @ 12:56:15 PM
    Script : http://forums.mixolgy.net/cron.php?rand=1258138565
    Referrer : http://forums.mixolgy.net/index.php
    IP Address : 41.233.38.227
    Username : m7mod
    Classname : vb_database
    MySQL Version :

    and create this table automatic taggregate_temp_xxxxx
    and can't repair this table find attach
    Click image for larger version

Name:	theardviews.jpg
Views:	1
Size:	81.3 KB
ID:	3712051
    and wondering if anyone can assist in the resolution:

  • #2
    What did you do right before this happened?

    MySQL error code 130: Incorrect file format

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment


    • #3
      This is after upgrading to vBulletin 3.8.4 Patch Level 1

      Comment


      • #4
        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

        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:

        http://www.vbulletin.com/forum/showt...threadid=44909

        You may have to ask your host to try and repair this for you.
        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
          Originally posted by Lynne View Post
          What did you do right before this happened?

          MySQL error code 130: Incorrect file format

          yes this message come when i repair the table now
          how can i solve it.

          Comment


          • #6
            Then you need to ask your host to try and repair this for you.
            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...
            X