Hi all,

I finally took a stab at DNN5 and ran a few trial upgrades on my 4.9.5 system. Then I spent the better part of a day reading and looking for answers. Although I've resolved most issues, either with mods, fixes, or seeing them as tickets in gemini, I can' t get past one error. The site appears to be working, but I can't risk updating my live site until I can get an error-free upgrade.

The upgrade report indicates that everything is fine apart from: Executing Application Upgrades: 05.00.00 Error!

The upgrade log files in Providers\DataProviders\SqlDataProvider are empty, so I can't find out what went wrong. Plenty of others seem to have this same issue.

The Event viewer shows the following errors around the same time, or directly after finishing the uprgade scripts - They may or may not be related - I don't know.

RawURL: /Install/Install.aspx?mode=Install
AbsoluteURL: /Install/Install.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-GB; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 (.NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 581b74e8-5303-4147-895d-34074782f452
InnerException: Cannot insert duplicate key row in object 'dbo.Packages' with unique index 'IX_Packages'. The statement has been terminated.
Message: System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.Packages' with unique index 'IX_Packages'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, ... and so on....

And this one

AbsoluteURLReferrer: http://www.------.com/Install/Install.aspx?mode=Install
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-GB; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 (.NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 70a80d7d-a21c-4000-85a5-e406d171ae26
InnerException: Object reference not set to an instance of an object.
Message: System.NullReferenceException: Object reference not set to an instance of an object. at DotNetNuke.Common.Utilities.FileSystemUtils.DeleteFiles(Array arrPaths) at DotNetNuke.Modules.Html.HtmlTextController.UpgradeModule(String Version) at DotNetNuke.Entities.Modules.EventMessageProcessor.UpgradeModule(EventMessage message)

 

So the question is: Why are the logs empty and how can I get them to populate correctly so I can find out what went wrong?

Or, how else can I troubleshoot this?

Thanks for any advice on this.
Rob

Related links:

• Precisely the same errors as me: http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/107/threadid/334750/scope/posts/Default.aspx
• Precisely the same again: http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/107/postid/335710/scope/posts/Default.aspx
• 'IX_Packages' issue - although my HTML modules work: http://support.dotnetnuke.com/issue/ViewIssue.aspx?ID=10826&PROJID=2
• 'IX_Packages' issue: http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/107/postid/333161/scope/posts/Default.aspx

Thanks for the tip Jack, I'll try that out and report back.

Rob

p.s. I'm pretty sure you're unmoderated - it just says otherwise because it's tjhe DNN forum.

2 days down the tube now so it's time to give up on this.

All I can report is that "Cannot insert duplicate key row in object 'dbo.Packages' with unique index 'IX_Packages'" is a permanent error accross all attempts to upgrade from 4.9.5 to 5.whatever

Going to 5.0.0 at least produced logs with messages in them.. later versions did not, but the event viewer still gave it away.

Does anyone at all have a clue what that error is and whather it does any serious damage?

Rob