Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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...Moved from 5.x to 7.x of the community edition and some controls not workingMoved from 5.x to 7.x of the community edition and some controls not working
Previous
 
Next
New Post
2/21/2013 3:52 PM
 
Mr Anderson


Joined: 11/14/2006
Posts: 126

After having a few issues in upgrading from 5 to 7 one of our users went to edit some content in an HTML module and it is all weirded out.

When clicking on a URL and then clicking the URL editor the little box would be blank and cannot be closed. Then after a few attempts to see why IE9 was having issues I opened Firefox and it appeared to be working fine.

The module is reporting it is 5.1.2 so I went in to Edit Extension and clicked on Update and got the following:

Error: is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot insert duplicate key row in object 'dbo.Packages' with unique index 'IX_Packages'. The duplicate key value is (DotNetNuke Corporation, DNN_HTML, Module, <NULL>). The statement has been terminated. ---> System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.Packages' with unique index 'IX_Packages'. The duplicate key value is (DotNetNuke Corporation, DNN_HTML, Module, <NULL>). The statement has been terminated. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at PetaPoco.Database.Execute(String sql, Object[] args) at DotNetNuke.Data.DataProvider.UpdatePackage(Int32 portalID, String name, String friendlyName, String description, String type, String version, String license, String manifest, String owner, String organization, String url, String email, String releaseNotes, Boolean isSystemPackage, Int32 lastModifiedByUserID, String folderName, String iconFile) at DotNetNuke.Services.Installer.Packages.PackageController.UpdatePackage(PackageInfo package) at DotNetNuke.Modules.Admin.Extensions.EditExtension.UpdatePackage(Boolean displayMessage) at DotNetNuke.Modules.Admin.Extensions.EditExtension.OnUpdateClick(Object sender, EventArgs e) --- End of inner exception stack trace ---
Any ideas on how I can correct this?
 
New Post
3/3/2013 6:27 PM
 
Mr Anderson


Joined: 11/14/2006
Posts: 126

Anybody have an idea? I see this theme through many google searches but no ideas on a fix. Anything from bug reports to people shrugging their shoulders on this sort of issue.

I would try deleting the errant module, HTML, but I'm afraid it might then delete the site's content which would be a bad thing.
 
New Post
3/7/2013 11:28 PM
 
Mr Anderson


Joined: 11/14/2006
Posts: 126
Well it would appear that there was a duplicate entry. I found that somehow version 4.x of the html module was in there. Removed it from the database and did an upgrade and bam! Gone. I hope.
 
New Post
3/9/2013 5:31 AM
 
Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 46212
you should not edit module information manually. check for the module being available in install/module folder and install it manually using Host > Extensions.
Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
3/11/2013 10:44 AM
 
Mr Anderson


Joined: 11/14/2006
Posts: 126

Hello Sebastian,

Exactly what I was thinking, but my thinking was wrong. I tried to install the module via Install Modules and it failed, I went in to Extensions and looked at Extensions available for install and it too failed. Having removed the prior version of the reference to the HTML module corrected the issue of duplicate keys. Because there was duplicate keys as far as the HTML module was concerned.

Thanks though.

 
 Page 1 of 1
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Moved from 5.x to 7.x of the community edition and some controls not workingMoved from 5.x to 7.x of the community edition and some controls not working


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