Announcement

Collapse
No announcement yet.

Manually uninstalling mod as mysql_query takes too long

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

  • Manually uninstalling mod as mysql_query takes too long

    I need to uninstall a mod that has inserted columns into the vb_posts table, which has more than 6M entries. Trying to run uninstall via browser results in a timeout (white-screen) after more than a minute of running. How can I manually uninstall this mod? This is the mod: http://www.vbulletin.org/forum/showt...184155&page=75

  • #2
    Originally posted by jl255 View Post
    I need to uninstall a mod that has inserted columns into the vb_posts table, which has more than 6M entries. Trying to run uninstall via browser results in a timeout (white-screen) after more than a minute of running. How can I manually uninstall this mod? This is the mod: http://www.vbulletin.org/forum/showt...184155&page=75
    You'd need to ask the author of the mod for support - we have no idea what queries it would require to do this manually.

    You could ask your host to temporarily increase the timeout settings for php & MySQL though.
    MARK.B | vBULLETIN SUPPORT

    TalkNewsUK - My vBulletin 5.5.2 Demo
    AdminAmmo - My Cloud Demo

    Comment


    • #3
      Tks, perhaps i was not clear. I'm not asking how to remove the db columns. But I'm asking how to manually remove the mod from vbulletin. i will run the mysql queries separately to remove any added tables or columns. and the creator is providing support anymore.

      Comment


      • #4
        This is not really a good idea. Just disable the modification if it's causing issues.
        MARK.B | vBULLETIN SUPPORT

        TalkNewsUK - My vBulletin 5.5.2 Demo
        AdminAmmo - My Cloud Demo

        Comment


        • #5
          Disable the product in the admincp. Delete its files. Database information will remain but shouldn't really hurt anything over the long term if the fields are designed correctly. If after disabling, there are database errors, you will need to contact the addon author.
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud customization and demonstration site.
          vBulletin 5 Documentation - Updated every Friday. Report issues here.
          vBulletin 5 API - Full / Mobile
          I am not currently available for vB Messenger Chats.

          Comment


          • #6
            After disabling the product, the syntax for getting rid of the column is...
            Code:
            alter table
             post
            drop column
             column_name
            Change column_name to the actual name of the column you want to get rid of.
            Lats...

            Comment

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