• Register
    • Help

    striker  0 Items
    Currently Supporting
    • Home
    • News
    • Forum
    • Wiki
    • Support
      • Manage Subscriptions
      • FAQ
      • Support For
        • VaultWiki 4.x Series
        • VaultWiki.org Site
    • What's New?
    • Buy Now
    • Manual
    • 
    • Support
    • VaultWiki 4.x Series
    • Bug
    • VW uninstall does not drop vw_import_redirect

    1. Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

      VaultWiki allows your existing forum users to collaborate on creating and managing a site's content pages. VaultWiki is a fully-featured and fully-supported wiki solution for vBulletin and XenForo.

      The VaultWiki Team encourages you to join our community of forum administrators and check out VaultWiki for yourself.

    Issue: VW uninstall does not drop vw_import_redirect

    • Issue Tools
      • View Changes
    1. issueid=3628 March 30, 2014 12:15 PM
      Alfa1 Alfa1 is offline
      Distinguished Member
      VW uninstall does not drop vw_import_redirect

      Are there any other tables and fields that the uninstaller is missing?
    Issue Details
    Issue Number 3628
    Issue Type Bug
    Project VaultWiki 4.x Series
    Category Install / Upgrade
    Status Fixed
    Priority 3 - Loss of Functionality
    Affected Version 4.0.0 Gamma 4
    Fixed Version 4.0.0 Gamma 5
    Milestone VaultWiki 4 Gamma X
    Software DependencyXenForo 1.x
    License TypePaid
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. March 30, 2014 2:13 PM
      pegasus pegasus is offline
      VaultWiki Team
      The uninstaller automatically removes tables that are added by the installer (by loading the installer modularly and changing the CREATE commands to DROP). vw_import_redirect is not actually created by the installer, but is a temporary table created during a VW3 import. It is not actually needed once the importer completes, so the importer should remove the table during the cleanup step. We can also add a step to the upgrader to remove this table if there is a complete VW3 import (if there is an incomplete import, doing so could result in data loss).
      Reply Reply  
    2. March 30, 2014 2:31 PM
      Alfa1 Alfa1 is offline
      Distinguished Member
      Uninstall should remove all wiki data including any import logs. This may prevent issues with re-importing.
      Reply Reply  
    3. March 30, 2014 3:58 PM
      pegasus pegasus is offline
      VaultWiki Team
      Unfortunately, there is not a good way for the uninstaller to detect that temporary tables exist or that they belong to VaultWiki and not some other product (they are not all as statically named as "vw_import_redirect").

      I suppose the other option is not to use a temporary table at all, but to store the temporary data in log entries (either vw_log or vw_import). We can change this behavior for the next release, but we will still be unable to cleanup any existing temporary tables from before that release due to the problem I mentioned above, with the exception of "vw_import_redirect" since it has a known name.
      Reply Reply  
    4. April 2, 2014 12:13 PM
      pegasus pegasus is offline
      VaultWiki Team
      Some temporary tables are very specific in the columns they have and often update using one of those columns as an index. Because of this, it's not possible to use vw_log for all temporaries.

      I've gone ahead and added the appropriate steps to the affected importers so that they cleanup temporary data when they're done. I've also added a step to the uninstaller for temporary tables, in case someone doesn't complete an import and uninstalls later. It should be able to detect dynamically named tables that follow a newly enforced naming convention. So from Gamma 5 onwards, temporary tables must be named like 'vw_temporary_*'. I've also added a step to the upgrade that will check if there are pending imports. If there aren't, it will remove any relevant leftover temporary tables. If there are, it will attempt to rename the relevant temporary tables so they follow the new naming convention. This introduces a risk of data loss for any imports were already started before the upgrade but not completed until afterwards, if the temp data is oddly named and therefore might be missed by the upgrade. There's not much we can do about that; I think these measures are quite sufficient.

      Marking as fixed in the next release.
      Reply Reply  
    + Reply

    Assigned Users
    Loading Please Wait
    Tags
    Loading Please Wait
    • Contact Us
    • License Agreement
    • Privacy
    • Terms
    • Top
    All times are GMT -4. The time now is 3:13 PM.
    This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Learn more… Accept Remind me later
  • striker
    Powered by vBulletin® Version 4.2.5 Beta 2
    Copyright © 2025 vBulletin Solutions Inc. All rights reserved.
    Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
    Copyright © 2008 - 2024 VaultWiki Team, Cracked Egg Studios, LLC.