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...Cannot install modules after upgrade from DNN 6.2.2 to DNN 7Cannot install modules after upgrade from DNN 6.2.2 to DNN 7
Previous
 
Next
New Post
12/5/2012 2:58 AM
 

Hi,

I met this odd issue after I upgrade a web site from DNN 6.2.2 to DNN 7. When I install/upgrade modules, I met below error:

....

Info:: Component installed successfully - ResourceFile

Info:: Starting Installation - Module

Info:: ExceptionSystem.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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.PetaPoco.PetaPocoHelper.ExecuteNonQuery(String connectionString, CommandType type, String sql, Object[] args) at DotNetNuke.Data.SqlDataProvider.ExecuteNonQuery(String procedureName, Object[] commandParameters) at DotNetNuke.Entities.Content.Data.DataService.AddMetaData(ContentItem contentItem, String name, String value) at DotNetNuke.Entities.Content.Data.DataService.SynchronizeMetaData(ContentItem contentItem, IEnumerable`1 added, IEnumerable`1 deleted) at DotNetNuke.Entities.Content.ContentController.SaveMetadataDelta(ContentItem contentItem) at DotNetNuke.Entities.Content.ContentController.AddContentItem(ContentItem contentItem) at DotNetNuke.Entities.Modules.DesktopModuleController.CreateContentItem(DesktopModuleInfo desktopModule) at DotNetNuke.Entities.Modules.DesktopModuleController.SaveDesktopModule(DesktopModuleInfo desktopModule, Boolean saveChildren, Boolean clearCache, Boolean saveTerms) at DotNetNuke.Services.Installer.Installers.ModuleInstaller.Install()

Info:: Installation Failed - Module

Info:: Rolling back component install - Script

Info:: Component rolled back successfully - Script

Info:: Rolling back component install - ResourceFile

Info:: Exception - Could not find file 'C:\inetpub\vhosts\zldnnmodule.com\httpdocs\Install\Temp\sxcxtucwResources.zip'.

Info:: Component rolled back successfully - ResourceFile

Info:: Installation Failed - AdvancedAudioPlayer

Info:: Deleted temporary install folder

Info:: Installation Failed

Any ideas?

Lei

 


Professional DNN Extensions, custom solutions since 2004
 
New Post
12/5/2012 4:15 AM
Accepted Answer 

Lei,
I wonder if you're having the same problem as I had - duplicate blank names?
Oh, I didn't come up with this fix - Sebastian Leupold did!
I just deleted duplicate items

... there seems to be an issue executing AddMetaData stored procedeure due to some duplicate items in one of the tables. Please check table MetaData for duplicate values in column MetaDataName, which unfortunately is missing a unique key constraint. You may find these values by running the following query in Host > SQL menu item:

SELECT MetaDataName, Count(1) N FROM {databaseOwner}{objectQualifier}Metadata GROUP BY MetaDataName Having Count(1) > 1

 
New Post
12/5/2012 4:42 AM
 

Hello John,

Thanks for your reply!

Yes, it solves my issue! There many duplicate names in the MetaData table. After I delete them, the module installation works!.

Thanks again.

Lei

 

 

 

 

 


Professional DNN Extensions, custom solutions since 2004
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Cannot install modules after upgrade from DNN 6.2.2 to DNN 7Cannot install modules after upgrade from DNN 6.2.2 to DNN 7


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