Few tables crashed

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Merjawy
    Senior Member
    • Sep 2002
    • 2613

    [Answered] Few tables crashed

    This is vB 4.1.12 Suite

    I have had this issue few months ago and I managed somehow to repair without dropping any table.
    Just now the site is down with few crashed tables, I ran reprair from within ACP and also from CPanel with no luck.

    I used SSH and that didn't do any good either
    As you can see below, contenttype, tags and seach tables have crashed

    PHP Code:

     
    -jailshell-3.2mysqlcheck --u host_host -p password host_4112
     
     
    host_4112.access OK
    host_4112
    .action OK
    host_4112
    .ad OK
    host_4112
    .adcriteria OK
    host_4112
    .adminhelp OK
    host_4112
    .administrator OK
    host_4112
    .adminlog OK
    host_4112
    .adminmessage OK
    host_4112
    .adminutil OK
    host_4112
    .album OK
    host_4112
    .albumupdate OK
    host_4112
    .announcement OK
    host_4112
    .announcementread OK
    host_4112
    .apiclient OK
    host_4112
    .apilog OK
    host_4112
    .apipost OK
    host_4112
    .attachment OK
    host_4112
    .attachmentcategory OK
    host_4112
    .attachmentcategoryuser OK
    host_4112
    .attachmentpermission OK
    host_4112
    .attachmenttype OK
    host_4112
    .attachmentviews OK
    host_4112
    .autosave OK
    host_4112
    .avatar OK
    host_4112
    .bbcode OK
    host_4112
    .bbcode_video OK
    host_4112
    .block OK
    host_4112
    .blockconfig OK
    host_4112
    .blocktype OK
    host_4112
    .blog OK
    host_4112
    .blog_attachmentlegacy OK
    host_4112
    .blog_category OK
    host_4112
    .blog_categorypermission OK
    host_4112
    .blog_categoryuser OK
    host_4112
    .blog_custom_block OK
    host_4112
    .blog_custom_block_parsed OK
    host_4112
    .blog_deletionlog OK
    host_4112
    .blog_editlog OK
    host_4112
    .blog_featured OK
    host_4112
    .blog_groupmembership OK
    host_4112
    .blog_grouppermission OK
    host_4112
    .blog_hash OK
    host_4112
    .blog_moderation OK
    host_4112
    .blog_moderator OK
    host_4112
    .blog_pinghistory OK
    host_4112
    .blog_rate OK
    host_4112
    .blog_read OK
    host_4112
    .blog_relationship OK
    host_4112
    .blog_search OK
    host_4112
    .blog_searchresult OK
    host_4112
    .blog_sitemapconf OK
    host_4112
    .blog_subscribeentry OK
    host_4112
    .blog_subscribeuser OK
    host_4112
    .blog_summarystats OK
    host_4112
    .blog_tachyentry OK
    host_4112
    .blog_text OK
    host_4112
    .blog_textparsed OK
    host_4112
    .blog_trackback OK
    host_4112
    .blog_trackbacklog OK
    host_4112
    .blog_user OK
    host_4112
    .blog_usercss OK
    host_4112
    .blog_usercsscache OK
    host_4112
    .blog_userread OK
    host_4112
    .blog_userstats OK
    host_4112
    .blog_views OK
    host_4112
    .blog_visitor OK
    host_4112
    .bookmarksite OK
    host_4112
    .cache OK
    host_4112
    .cacheevent OK
    host_4112
    .calendar OK
    host_4112
    .calendarcustomfield OK
    host_4112
    .calendarmoderator OK
    host_4112
    .calendarpermission OK
    host_4112
    .cms_article OK
    host_4112
    .cms_category OK
    host_4112
    .cms_grid OK
    host_4112
    .cms_layout OK
    host_4112
    .cms_layoutwidget OK
    host_4112
    .cms_navigation OK
    host_4112
    .cms_node OK
    host_4112
    .cms_nodecategory OK
    host_4112
    .cms_nodeconfig OK
    host_4112
    .cms_nodeinfo OK
    host_4112
    .cms_permissions OK
    host_4112
    .cms_rate OK
    host_4112
    .cms_sectionorder OK
    host_4112
    .cms_widget OK
    host_4112
    .cms_widgetconfig OK
    host_4112
    .cms_widgettype OK
    host_4112
    .contentpriority OK
    host_4112
    .contenttype
    Error 
    Incorrect information in file'./host_4112/contenttype.frm'
    error Corrupt
    host_4112
    .cpsession
    note 
    The storage engine for the table doesn't support repair
    host_4112.cron OK
    host_4112.cronlog OK
    host_4112.customavatar OK
    host_4112.customprofile OK
    host_4112.customprofilepic OK
    host_4112.datastore OK
    host_4112.dbquery OK
    host_4112.deletionlog OK
    host_4112.discussion OK
    host_4112.discussionread OK
    host_4112.editlog OK
    host_4112.event OK
    host_4112.externalcache OK
    host_4112.faq OK
    host_4112.filedata OK
    host_4112.force_read_guests OK
    host_4112.force_read_users OK
    host_4112.formresults OK
    host_4112.forum OK
    host_4112.forumpermission OK
    host_4112.forumprefixset OK
    host_4112.forumread OK
    host_4112.forumrunner_push_data OK
    host_4112.forumrunner_push_users OK
    host_4112.groupmessage OK
    host_4112.groupmessage_hash OK
    host_4112.groupread OK
    host_4112.holiday OK
    host_4112.humanverify OK
    host_4112.hvanswer OK
    host_4112.hvquestion OK
    host_4112.icon OK
    host_4112.imagecategory OK
    host_4112.imagecategorypermission OK
    host_4112.indexqueue OK
    host_4112.infraction OK
    host_4112.infractionban OK
    host_4112.infractiongroup OK
    host_4112.infractionlevel OK
    host_4112.language OK
    host_4112.mailqueue OK
    host_4112.moderation OK
    host_4112.moderator OK
    host_4112.moderatorlog OK
    host_4112.ms_links OK
    host_4112.ms_menu_links OK
    host_4112.ms_tabs OK
    host_4112.notice OK
    host_4112.noticecriteria OK
    host_4112.noticedismissed OK
    host_4112.package OK
    host_4112.passwordhistory OK
    host_4112.paymentapi OK
    host_4112.paymentinfo OK
    host_4112.paymenttransaction OK
    host_4112.phrase OK
    host_4112.phrasetype OK
    host_4112.picturecomment OK
    host_4112.picturecomment_hash OK
    host_4112.picturelegacy OK
    host_4112.plugin OK
    host_4112.pm OK
    host_4112.pmreceipt OK
    host_4112.pmtext OK
    host_4112.pmthrottle OK
    host_4112.podcast OK
    host_4112.podcastitem OK
    host_4112.poll OK
    host_4112.pollvote OK
    host_4112.post OK
    host_4112.postedithistory OK
    host_4112.posthash OK
    host_4112.postindex OK
    host_4112.postlog OK
    host_4112.postparsed OK
    host_4112.prefix OK
    host_4112.prefixpermission OK
    host_4112.prefixset OK
    host_4112.product OK
    host_4112.productcode OK
    host_4112.productdependency OK
    host_4112.profileblockprivacy OK
    host_4112.profilefield OK
    host_4112.profilefieldcategory OK
    host_4112.profilevisitor OK
    host_4112.ranks OK
    host_4112.reminder OK
    host_4112.reputation OK
    host_4112.reputationlevel OK
    host_4112.route OK
    host_4112.rssfeed OK
    host_4112.rsslog OK
    host_4112.searchcore
    Error : Incorrect information in file: '
    ./host_4112/searchcore.frm'
    error : Corrupt
    host_4112.searchcore_text OK
    host_4112.searchgroup
    Error : Incorrect information in file: '
    ./host_4112/searchgroup.frm'
    error : Corrupt
    host_4112.searchgroup_text OK
    host_4112.searchlog
    Error : Incorrect information in file: '
    ./host_4112/searchlog.frm'
    error : Corrupt
    host_4112.session
    note : The storage engine for the table doesn'
    t support repair
    host_4112
    .setting OK
    host_4112
    .settinggroup OK
    host_4112
    .sigparsed OK
    host_4112
    .sigpic OK
    host_4112
    .skimlinks OK
    host_4112
    .smilie OK
    host_4112
    .socialgroup OK
    host_4112
    .socialgroupcategory OK
    host_4112
    .socialgroupicon OK
    host_4112
    .socialgroupmember OK
    host_4112
    .spamlog OK
    host_4112
    .stats OK
    host_4112
    .strikes OK
    host_4112
    .style OK
    host_4112
    .stylevar OK
    host_4112
    .stylevardfn OK
    host_4112
    .subscribediscussion OK
    host_4112
    .subscribeevent OK
    host_4112
    .subscribeforum OK
    host_4112
    .subscribegroup OK
    host_4112
    .subscribethread OK
    host_4112
    .subscription OK
    host_4112
    .subscriptionlog OK
    host_4112
    .subscriptionpermission OK
    host_4112
    .tachyforumcounter OK
    host_4112
    .tachyforumpost OK
    host_4112
    .tachythreadcounter OK
    host_4112
    .tachythreadpost OK
    host_4112
    .tag
    Error 
    Incorrect information in file'./host_4112/tag.frm'
    error Corrupt
    host_4112
    .tagcontent
    Error 
    Incorrect information in file'./host_4112/tagcontent.frm'
    error Corrupt
    host_4112
    .taggregate_temp_1328882160
    note 
    The storage engine for the table doesn't support repair
    host_4112.tagsearch OK
    host_4112.template OK
    host_4112.templatehistory OK
    host_4112.templatemerge OK
    host_4112.thread OK
    host_4112.threadrate OK
    host_4112.threadread OK
    host_4112.threadredirect OK
    host_4112.threadviews OK
    host_4112.upgradelog OK
    host_4112.user OK
    host_4112.useractivation OK
    host_4112.userban OK
    host_4112.userchangelog OK
    host_4112.usercss OK
    host_4112.usercsscache OK
    host_4112.userfield OK
    host_4112.usergroup OK
    host_4112.usergroupleader OK
    host_4112.usergrouprequest OK
    host_4112.userlist OK
    host_4112.usernote OK
    host_4112.userpromotion OK
    host_4112.usertextfield OK
    host_4112.usertitle OK
    host_4112.vbfields OK
    host_4112.visitormessage OK
    host_4112.visitormessage_hash OK
    host_4112.whoread 
    - - - Updated - - -

    PHP Code:

     Database error in vBulletin 4.1.12
    :
    Invalid SQL:
    (
    SELECT 'package' AS classtypepackage.packageid AS typeidpackage.packageid AS packageid,
    package.productid AS productid, if(package.productid 'vbulletin'1product.active) AS enabled,
    package.class AS class, -as isaggregator
    FROM package 
    AS package
    LEFT JOIN product 
    AS product
    ON product
    .productid package.productid
    WHERE product
    .active 1
    OR package.productid 'vbulletin'
    )
    UNION
    (SELECT 'contenttype' AS classtypecontenttypeid AS typeidcontenttype.packageid AS packageid,
    11contenttype.class AS class , contenttype.isaggregator
    FROM contenttype 
    AS contenttype
    INNER JOIN package 
    AS package ON package.packageid contenttype.packageid
    LEFT JOIN product 
    AS product ON product.productid package.productid
    WHERE product
    .active 1
    OR package.productid 'vbulletin' );
    MySQL Error Incorrect information in file'./host_4112/contenttype.frm'
    Error Number 1033
    Request Date 
    SundayJuly 29th 2012 11:44:53 AM
    Error Date 
    SundayJuly 29th 2012 11:44:53 AM
    Script 
    http://www.mydomain.com/
    Referrer 
    IP Address xxx.xxx.xxx.xxx
    Username 
    Admin
    Classname 
    vB_Database
    MySQL Version 
    5.0.95-community 
    - - - Updated - - -

    I fixed the issue. Please mark it solved
    To be or not to be... Where the hell is the question????
    My psychiatrist told me I was crazy and I said I want a second opinion. He said okay, you're ugly too

    Live vBulletin 4.2.0 Multilingual * Alpha/Beta vB 4 - vB 5 Tier 1A
    CentOS 6.2 - Apache:2.2.15(Apache2Handler) - PHP:5.3.3 - MySQL:5.1.61
    Xampp/Win-XP - Apache v2.2.21(Apache2Handler) - PHP:5.3.8 - MySQL:5.5.16

  • Andy
    Senior Member
    • Jan 2002
    • 5886
    • 4.1.x

    #2
    How did you fix the issue?

    Comment

    • TheLastSuperman
      Senior Member
      • Sep 2008
      • 1799

      #3
      I'm assuming he (or his host) closed the forum and shut down the mysql server then used myisamchk to recreate the *.frm files for the tables in question... is that correct Merjawy?


      Former vBulletin Support Staff
      Hacked recently? See my blog post "Recovering a Hacked vBulletin Site".
      Thinking outside the box? Need modification support? Visit www.vBulletin.org and have at it!

      Comment

      • Merjawy
        Senior Member
        • Sep 2002
        • 2613

        #4
        Sorry guys, I didn't see your questions till now

        Michael was close.
        What I did was I restarted MySQL server and it fixed the issue Magic
        To be or not to be... Where the hell is the question????
        My psychiatrist told me I was crazy and I said I want a second opinion. He said okay, you're ugly too

        Live vBulletin 4.2.0 Multilingual * Alpha/Beta vB 4 - vB 5 Tier 1A
        CentOS 6.2 - Apache:2.2.15(Apache2Handler) - PHP:5.3.3 - MySQL:5.1.61
        Xampp/Win-XP - Apache v2.2.21(Apache2Handler) - PHP:5.3.8 - MySQL:5.5.16

        Comment

        • TheLastSuperman
          Senior Member
          • Sep 2008
          • 1799

          #5
          Originally posted by Merjawy
          Sorry guys, I didn't see your questions till now

          Michael was close.
          What I did was I restarted MySQL server and it fixed the issue Magic
          ROFL well go figure it was Magic yet again! I need to learn some of that myself .


          Former vBulletin Support Staff
          Hacked recently? See my blog post "Recovering a Hacked vBulletin Site".
          Thinking outside the box? Need modification support? Visit www.vBulletin.org and have at it!

          Comment

          • Merjawy
            Senior Member
            • Sep 2002
            • 2613

            #6
            lol
            To be or not to be... Where the hell is the question????
            My psychiatrist told me I was crazy and I said I want a second opinion. He said okay, you're ugly too

            Live vBulletin 4.2.0 Multilingual * Alpha/Beta vB 4 - vB 5 Tier 1A
            CentOS 6.2 - Apache:2.2.15(Apache2Handler) - PHP:5.3.3 - MySQL:5.1.61
            Xampp/Win-XP - Apache v2.2.21(Apache2Handler) - PHP:5.3.8 - MySQL:5.5.16

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...
            😀
            😂
            🥰
            😘
            🤢
            😎
            😞
            😡
            👍
            👎