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

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...5.1.2 error (new thread)5.1.2 error (new thread)
Previous
 
Next
New Post
9/6/2009 12:20 PM
 

The original  thread for this post was "5.1.2 Error"  but has become inaccessible, so I am going to try again.  I believe that Sebastian Leupold had responded to an earlier post where I mentioned that I had upgraded 2 local dev instances of 5.1.1 to the new 5.1.2 version but I got a couple of errors that look like this:

 
00:00:07.910 - Installing Optional Modules:
00:00:07.914 -   Installing Package File HTML_Community_05.01.02_Install:  Success
00:00:09.355 -   Installing Package File HTML_Community_05.01.03_Install:  Error!
00:00:12.419 - Installing Optional Skins:
00:00:12.419 -   Installing Package File DNN-MinimalExtropySkin_01.00.04_Install:  Error!
00:00:13.651 - Installing Optional Containers:
00:00:13.652 -   Installing Package File DNN-MinimalExtropyContainer_01.00.04_Install:  Error!
 
Sebastian  had asked if I had modified the default skin or container (MinimalExtropy)  and  for the event log entry around the error. The only change I made to the skin was to the css file for it where I had added a background image to the .logo_pad class. So the change was from this:
 
.logo_pad{background:#FFF; margin: 0 19px 0 7px; padding:0 ;height:100px;}
 
To this:
.logo_pad
{
    background: #FFF;
    margin: 0 19px 0 7px;
    padding: 0;
    height: 100px;
    background-image: url(images/CHAbackground.jpg);
    background-repeat: repeat-x;
}
 
Sebastian also asked for the event log entry around the error, so here it is:
AssemblyVersion: 5.1.2
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL: /main/Install/Install.aspx?mode=upgrade
AbsoluteURL: /main/Install/Install.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; GTB6; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; Media Center PC 5.0; SLCC1)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: eb32eb66-af41-4500-bfa3-0c9505b640fc
InnerException: Cannot insert duplicate key row in object 'dbo.Packages' with unique index 'IX_Packages'. The statement has been terminated.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
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, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddPackage(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 CreatedByUserID) at DotNetNuke.Services.Installer.Packages.PackageController.AddPackage(PackageInfo package, Boolean includeDetail) at DotNetNuke.Services.Installer.Packages.PackageController.SavePackage(PackageInfo package) at DotNetNuke.Services.Upgrade.Upgrade.UpgradeApplication()
Source:
Server Name: P3NW3SH029
 

Gene W
 
New Post
9/6/2009 2:30 PM
 

I got one error with upgrade to 5.1.2:

00:00:09.355 -   Installing Package File HTML_Community_05.01.03_Install:  Error!

 

Is there a way to try to reinstall this package manually? Or should I revert to 5.1.1

On log viewer I get this error:

AssemblyVersion: 5.1.2
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL: /Install/Install.aspx?mode=upgrade
AbsoluteURL: /Install/Install.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; InfoPath.2; .NET CLR 3.5.30729; .NET CLR 3.0.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 8a080e5c-1d34-48f7-9be8-9a83136e45d3
InnerException: Cannot insert duplicate key row in object 'dbo.Packages' with unique index 'IX_Packages'. The statement has been terminated.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
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, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddPackage(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 CreatedByUserID) at DotNetNuke.Services.Installer.Packages.PackageController.AddPackage(PackageInfo package, Boolean includeDetail) at DotNetNuke.Services.Installer.Packages.PackageController.SavePackage(PackageInfo package) at DotNetNuke.Services.Upgrade.Upgrade.UpgradeApplication()
Source:
Server Name: WEB22

 
New Post
9/6/2009 2:44 PM
 

My site still seems to be working despite error installing HTML_Community_05.01.03_Install

I tried to install the package manually as an extension from the Install/Module/HTML_Community_05.01.03_Install.zip and got the following error:

Error loading files from temporary folder - see below
StartJob Starting Installation
Info Starting Installation - DNN_HTML
Info Starting Installation - Script
Info Begin Sql execution
Info Creating backup of previous version - Providers\DataProviders\SqlDataProvider\05.01.03.SqlDataProvider
Info Created - Providers\DataProviders\SqlDataProvider\05.01.03.SqlDataProvider
Info Executing 05.01.03.SqlDataProvider
Info Start Sql execution: 05.01.03.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_ModuleSettings'. Cannot insert duplicate key in object 'dbo.ModuleSettings'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /***** SqlDataProvider *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and *****/ /***** *****/ /************************************************************/ update dbo.ModuleSettings set SettingName = 'HtmlText_ReplaceTokens' where SettingName = 'TEXTHTML_ReplaceTokens'
Info End Sql execution: 05.01.03.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - DNN_HTML
Info Deleted temporary install folder
EndJob Installation Failed
 

 
New Post
9/6/2009 3:44 PM
 

on first sight it looks like both errors with are caused by uncautious programming, not checking for the exisitence of the key first. AFAIK this has already been reported and fixed in code base for next version, please check out the issue in support.gemini.com, whether there is a workaround (e.g. by manually extending the SQL scripts).


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
9/6/2009 4:36 PM
 

Thanks Sebastian.

I could not find it in Gemini.

I logged it here: http://support.dotnetnuke.com/issue/ViewIssue.aspx?id=10717&PROJID=23

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...5.1.2 error (new thread)5.1.2 error (new thread)


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