Issue: Install Failure and Unable to Uninstall

Issue Tools
- View Changes

February 27, 2014 12:51 PM
Mokonzi

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

February 27, 2014 5:32 PM

pegasus

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

February 28, 2014 2:04 AM

Mokonzi

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?

February 28, 2014 9:58 AM
pegasus

VaultWiki Team
Code:

DELETE FROM vb3_template WHERE styleid = -10
Reply
February 28, 2014 11:54 PM

pegasus

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
March 1, 2014 1:59 AM

Mokonzi

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

All times are GMT -4. The time now is 1:20 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

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

Issue: Install Failure and Unable to Uninstall

Issue Tools