Issue: database error while updating from gamma 6 to 7

Issue Tools
- View Changes

July 3, 2014 12:04 PM

kamran_dotnet kamran_dotnet is offline

New Member

database error while updating from gamma 6 to 7

get this error while updating from VW Gamma 6 to Gamma 7
in step one:
Updating data in table: blocktype

Code:

Database error in vBulletin 4.2.2:

Invalid SQL:
UPDATE `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  : Thursday, July 3rd 2014 @ 04:01:21 PM
Error Date    : Thursday, July 3rd 2014 @ 04:01:21 PM
Script        : [url]http://winphonecenter.com/forum/vault/install/index.php?step=1[/url]
Referrer      : 
IP Address    : 37.19.82.142
Username      : WinPhoneCenter
Classname     : vB_Database
MySQL Version : 5.5.35-cll

Issue Details

Issue Number 3826

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.0 Gamma 7

Fixed Version 4.0.0 RC 1

Milestone VaultWiki 4 Gamma X

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

July 3, 2014 12:11 PM
pegasus

VaultWiki Team
Try deleting your entire vault/core/controller/install folder and then reuploading it. It should not be possible to get this error because of the following logic which is currently in place:

Code:

$exists = check for existing 'vwsidebar' if ($exists) { delete 'vwactivity' } if (not $exists) { rename 'vwactivity' to 'vwsidebar' }

According to this error, you are in the "not exists" logic, even though "exists" is true.
Reply
July 3, 2014 12:21 PM

kamran_dotnet

New Member

its fix
thanks pegasus

Reply
July 3, 2014 1:30 PM

pegasus

VaultWiki Team

Added a stop message in the next release that won't let the user access VaultWiki's admin panel until the install directory is removed or debug mode is turned on. In Debug Mode, admins will see a persistent error message at the top of the VaultWiki admin panel until the install directory is removed.

With this persistent message, marking this issue as fixed.

Reply

+ Reply

All times are GMT -4. The time now is 4:32 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: database error while updating from gamma 6 to 7

Issue Tools