• 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
    • Install Failure and Unable to Uninstall

    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: Install Failure and Unable to Uninstall

    • Issue Tools
      • View Changes
    1. issueid=3593 February 27, 2014 12:51 PM
      Mokonzi Mokonzi is offline
      Senior Member
      Install Failure and Unable to Uninstall
      While attempting to Install the system hung and attempting to uninstall creates MySQL errors

      I bit the bullet today and decided to run with an install and import of the VW 3.x data. While progressing through the steps I hit an issue with the installer seeming to hang at the point it was adding the package to the database (About step 5 or 6 IIRC).

      By hang, I mean that there were not error messages of any kind and that after 45-60 mins it was still 'processing' that part of the install.

      I tried refreshing the page in the hope it might be a temporary issue that would resolve itself, and initially it looked promising as it continued the install at the stage of configuring the attachments part.

      After it completed I went to the AdminCP section of VW and tried importing the VW3 wiki, but hit this MySQL error:

      Code:
      Invalid SQL:
      SELECT sourceid,targetid FROM `vb3_vw_import` WHERE name = 'page' AND hash = '1eb73f22a18e90ede0f5ceacf38fe570' AND  `targetid` IN ()  LIMIT 0;
      
      MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')  LIMIT 0' at line 1
      Error Number  : 1064
      Request Date  : Thursday, February 27th 2014 @ 04:52:46 PM
      Error Date    : Thursday, February 27th 2014 @ 04:52:47 PM
      Script        : http://www.mysite.com/admincp/wiki_cp.php?panel=impex&do=import&step=7&nostyle=1
      Referrer      : http://www.mysite.com/admincp/wiki_cp.php?panel=impex&do=import
      Next I tried running the install/upgrade script again in case it would help fix the missing errors (I know it was clutching at straws, but...)

      This error:

      Code:
      Invalid SQL:
      UPDATE `vb3_template` SET `styleid` = -10 WHERE styleid = -2 AND product = 'vaultwiki';
      
      MySQL Error   : Duplicate entry 'vault_special_redirectbit--10-template' for key 'title'
      Error Number  : 1062
      Request Date  : Thursday, February 27th 2014 @ 04:54:46 PM
      Error Date    : Thursday, February 27th 2014 @ 04:54:51 PM
      Script        : http://www.mysite.com/vault/install/index.php?step=6&nostyle=1
      Referrer      : http://www.mysite.com/vault/install/index.php
      Finally I decided to run the uninstall from the vB ACP, but got this error:

      Code:
      Invalid SQL:
      SELECT contenttypeid,class FROM `vb3_contenttype` WHERE  `class` IN (vwPage,vwComment)  LIMIT 2;
      
      MySQL Error   : Unknown column 'vwPage' in 'where clause'
      Error Number  : 1054
      Request Date  : Thursday, February 27th 2014 @ 04:55:22 PM
      Error Date    : Thursday, February 27th 2014 @ 04:55:22 PM
      Script        : http://www.thexuniverse.com/admincp/plugin.php?do=productkill
      Referrer      : http://www.thexuniverse.com/admincp/plugin.php?do=productdelete&productid=vaultwiki&s=
      I find the initial install problem puzzling cos the server we use for our site is a twelve core processor and has a lot of good resources. I was running the install from Chrome, but I don't believe there were any extensions running when I did so.

      So I'm stuck in limbo between a partially installed and partially uninstalled VW 4.x wiki...

      Any suggestions or tips? I don't mind running through the database to clear out any partially added columns and tables manually, but would need a list of what's what to do so.

      Looking forward to seeing VW 4.x in full swing as well.
    Issue Details
    Issue Number 3593
    Issue Type Bug
    Project VaultWiki 4.x Series
    Category Install / Upgrade
    Status Fixed
    Priority 2 - Fatal / Database Errors
    Affected Version 4.0.0 Gamma 2
    Fixed Version 4.0.0 Gamma 3
    Milestone VaultWiki 4 Gamma X
    Software DependencyvBulletin 4.x w/ ckEditor
    License TypePaid
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags Import, install, Server Errors




    1. February 27, 2014 5:32 PM
      pegasus pegasus is offline
      VaultWiki Team
      Long time no see!

      To manually uninstall, remove all entries from product, productdependency, productcode, and plugin with product(id) = vaultwiki
      Then rebuild the plugin cache by enabling/disabling any other product.

      You really only have to remove the vw_upgradelog table to prepare for re-install. But if you want to be thorough, you can have a look in the the vault/core/controller/install/db/ folder. In there are 3 directories:
      - create: these tables were added by the installer. Basically all tables with a vw_ prefix
      - alter: these vB tables were modified by the installer. Each file should outline what was added or changed.
      - insert: these tables had insert data by the installer. Some were vw_ tables, some were vB tables.

      If you need assistance, I will gladly have a go.

      I believe the install was actually successful the first time. It's possible you had to refresh because sometimes the attachment configuration dialog is invisible when it opens. I have not been able to get it happening consistently, but I will create another test forum and run it a few more times to see what's up.

      I would wait until Gamma 3 to import VW3. It transfers a lot of data that is lost in earlier versions of the importer. The importer was just rewritten (again) in Gamma 1 and the DB error you encountered was due to data that got dissociated during the import.

      You should wait to import, but if you have a test install or you want to get a handle on the new interfaces beforehand, please go ahead. Gamma 3 should be ready in a day or two, I am just wrapping up a new feature that needed to make it in.
      Reply Reply  
    2. February 28, 2014 2:04 AM
      Mokonzi Mokonzi is offline
      Senior Member
      Thanks matey, I might do that. I tried again and ended up with a MySQL error at Step 18:

      Code:
      Database error in vBulletin 4.2.2:
      
      Invalid SQL:
      UPDATE `vb3_template` SET `styleid` = -10 WHERE styleid = -2 AND product = 'vaultwiki';
      
      MySQL Error   : Duplicate entry 'vault_special_redirectbit--10-template' for key 'title'
      Error Number  : 1062
      Request Date  : Friday, February 28th 2014 @ 07:01:38 AM
      Error Date    : Friday, February 28th 2014 @ 07:01:42 AM
      Script        : http://www.thexuniverse.com/vault/install/index.php?step=18&nostyle=1
      Referrer      : http://www.thexuniverse.com/vault/install/index.php
      I'm assuming their needs to be tidy up stuff in the template stuff as well?
      Reply Reply  
    3. February 28, 2014 9:58 AM
      pegasus pegasus is offline
      VaultWiki Team
      Code:
      DELETE FROM vb3_template WHERE styleid = -10
      Reply Reply  
    4. February 28, 2014 11:54 PM
      pegasus pegasus is offline
      VaultWiki Team
      I could not duplicate the issue of the installer hanging during the initial process, but I have fixed the issue of the installer hanging if an invalid attachment storage path is selected. I will mark this as fixed for now. If you continue to encounter the original issue on reinstall, perhaps server logs or Javascript console information can help isolate the issue.
      Reply Reply  
    5. March 1, 2014 1:59 AM
      Mokonzi Mokonzi is offline
      Senior Member
      Thanks matey. I'll let you know how I get on. May well wait until Gamma 3 is out before I continue.
      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 11:15 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 © 2023 vBulletin Solutions Inc. All rights reserved.
    Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
    Copyright © 2008 - 2013 VaultWiki Team, Cracked Egg Studios, LLC.