Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...5.6.2 -> 6.2.3 upgrade error: duplicate index5.6.2 -> 6.2.3 upgrade error: duplicate index
Previous
 
Next
New Post
9/19/2012 2:31 PM
 

Hi all,

Tried following Chris Hammond's video to go from 5.6.2 to 6.2.3.  The upgrade failed with the following error:

Upgrading DotNetNuke

Current Assembly Version: 06.02.03

Current Database Version: 05.06.02



Upgrade Status Report

00:00:00.031 - Upgrading to Version: 06.02.03
00:00:00.998 -   Executing Script: 05.06.03.SqlDataProvider Error! (see 05.06.03.log.resources for more information)

In the log we see

2012-09-19 11:11:06,922 [w05][Thread:24][FATAL] DotNetNuke.Web.Common.Internal.DotNetNukeHttpApplication - System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Data.SqlClient.SqlException (0x80131904): Violation of UNIQUE KEY constraint 'IX_Version'. Cannot insert duplicate key in object 'dbo.Version'. The duplicate key value is (5, 6, 3).
The statement has been terminated..

Help?

Thanks -- Mike

 
New Post
9/19/2012 6:11 PM
 

Hi all,

OK, got it: if your instance of DNN is not in the root at a remote provider, and you are using IIS URL Rewrite, do not clobber the web.config at the root of your site.  For some reason I thought I needed to turn off URL Rewrite for the upgrade, and renamed the root web.config.  False.  Don't do that.

Upgraded via ftp, copying the unzipped upgrade package hierarchically over the original files, then running

http://<the site>/UpgradeWizard.aspx.

While the "wizard" never returned, nor wrote any notification to the browser instance from which it was invoked, it did in fact complete successfully.  So the site is now on DNN 6.2.3 WITH a running instance of the Morpheus skin with SkinLab.

Here's how to upgrade a site with Morpheus/Skinlab: upgrade Morpheus/Skinlab FIRST, before attempting the DNN upgrade.

You will find that SkinLab is very slow, but that it runs, on (for example) DNN 5.6.2, after Morpheus/Skinlab has been upgraded.

After DNN has been subsequently upgraded (to in my case DNN 6.2.3), SkinLab runs reasonably well.

So I take back all the mean things I said and thought about Morpheus's author... well... most of them.  If you bought the skin from snowcovered/The Store, and can still log on to the account you used to make the purchase, at least as of 9/17/2012 the most recent Morpheus files (dated November 2011) were still there.  Google and you will find instructions from the author about upgrading Morpheus.

All the best -- Mike

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...5.6.2 -> 6.2.3 upgrade error: duplicate index5.6.2 -> 6.2.3 upgrade error: duplicate index


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out