Issue: Error while upgrading

Issue Tools
- View Changes

April 23, 2014 2:49 AM

DragonSigh DragonSigh is offline

Junior Member

Error while upgrading

Upgrading to v4.0.0 Gamma 5 Build 006

Upgrading proccess stops with this error:

Code:

Database error in vBulletin 4.2.2:

Invalid SQL:
UPDATE `vb_blocktype` SET `name` = 'vwsidebar',
	`title` = 'vw_sidebar_block',
	`allowcache` = 0 WHERE name = 'vwactivity';

MySQL Error   : Duplicate entry 'vwsidebar' for key 'name'
Error Number  : 1062
Request Date  : Wednesday, April 23rd 2014 @ 10:46:06 AM
Error Date    : Wednesday, April 23rd 2014 @ 10:46:07 AM
Script        : [url]http://***/vault/install/index.php?step=1&nostyle=1[/url]
Referrer      : [url]http://***/vault/install/index.php[/url]
IP Address    : **.**.***.***
Username      : *****
Classname     : vB_Database
MySQL Version : 5.1.49-3

Issue Details

Issue Number 3713

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.0 Gamma 5

Fixed Version 4.0.0 Gamma 6

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 database, error, sql, upgrade

April 23, 2014 10:49 AM
pegasus

VaultWiki Team
This occurs if you uninstall a version Gamma 3+, re-install Gamma 2-, and then attempt to upgrade; or if you uninstall a version < Gamma 3, reinstall a version > Gamma 3, uninstall that version, re-install > Gamma 3 with vBulletin CMS disabled, enable vBulletin CMS, attempt to upgrade VaultWiki. There may be other ways to duplicate this, but those are 2 ways I was able to do it.

The second way is already patched if the newest installation was Gamma 5, but some entries were not removed during the uninstall script < Gamma 5, because it was expected that vBulletin removes such entries automatically. However, some users are on earlier versions of vBulletin that don't, the vBulletin bug might still be unresolved, or they use APM to uninstall their products which also doesn't.

You will have to manually execute the following MySQL query before you can continue:

Code:

DELETE FROM vb_blocktype WHERE name = 'vwsidebar'

Even though it is not possible for this to occur if a fresh installation is >= Gamma 5 or Gamma 5 was the uninstalled version, I have updated the uninstall script for the next release for completeness's sake, in case someone uninstalls Gamma 6 and then attempts to install Gamma 3 afterwards.
Reply
April 23, 2014 12:43 PM

DragonSigh

Junior Member

Thanks, that SQL query helped me. But I upgraded from Gamma 4 to Gamma 5 without any deinstallation or reinstallation.

Reply

+ Reply

All times are GMT -4. The time now is 7:21 AM.

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: Error while upgrading

Issue Tools