Forum Tags

pageLocalization fails on intall,..how can i solve this?

Info	Starting Installation - ModuleLocalization
Info	Starting Installation - Script
Info	Begin Sql execution
Info	Creating backup of previous version - Providers\DataProviders\SqlDataProvider\01.00.00.SqlDataProvider
Info	Created - Providers\DataProviders\SqlDataProvider\01.00.00.SqlDataProvider
Info	Executing 01.00.00.SqlDataProvider
Info	Start Sql execution: 01.00.00.SqlDataProvider file
Info	End Sql execution: 01.00.00.SqlDataProvider file
Info	Creating backup of previous version - Providers\DataProviders\SqlDataProvider\02.00.00.SqlDataProvider
Info	Created - Providers\DataProviders\SqlDataProvider\02.00.00.SqlDataProvider
Info	Executing 02.00.00.SqlDataProvider
Info	Start Sql execution: 02.00.00.SqlDataProvider file
Info	End Sql execution: 02.00.00.SqlDataProvider file
Info	Creating backup of previous version - Providers\DataProviders\SqlDataProvider\03.00.00.SqlDataProvider
Info	Created - Providers\DataProviders\SqlDataProvider\03.00.00.SqlDataProvider
Info	Executing 03.00.00.SqlDataProvider
Info	Start Sql execution: 03.00.00.SqlDataProvider file
Failure	SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.Packages' with unique index 'IX_Packages'. Cannot insert the value NULL into column 'PackageID', table 'SCOTTURB_DNN.dbo.SkinControls'; column does not allow nulls. INSERT fails. The statement has been terminated. 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 *****/ /***** ModuleLocalization *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and *****/ /***** *****/ /************************************************************/ /* copyright (c) 2008 by Erik van Ballegoij ( erik@apollo-software.nl ) ( http://www.apollo-software.nl )*/ IF ( SELECT TOP 1 [Major] FROM dbo.[Version] ORDER BY VersionId DESC ) <= 4 BEGIN IF ( SELECT COUNT(*) FROM dbo.[ModuleControls] WHERE ControlKey = 'MLTITLE' ) = 0 BEGIN INSERT INTO dbo.[ModuleControls] ( ControlKey, ControlSrc, ControlType, ControlTitle ) VALUES ( 'MLTITLE', 'DesktopModules/ModuleLocalization/MLTitle.ascx', -2, 'CONTAINER' ) END END ELSE BEGIN DECLARE @PackageId INT INSERT INTO dbo.[Packages] ( [Name], [FriendlyName], [Description], [PackageType], [Version], [License] ) VALUES ( N'Apollo.MLTITLE', N'MLTITLE SkinObject', N'This SkinObject is part of the Apollo ModuleLocalization Module', N'SkinObject', N'1.0.0', N'See for complete license text: http://www.apollo-software.nl/Over/SoftwareLicense/tabid/77/language/en-US/Default.aspx' ) SELECT @PackageId = SCOPE_IDENTITY() INSERT INTO dbo.[SkinControls] ( [PackageID], [ControlKey], [ControlSrc], [IconFile], [HelpUrl], [SupportsPartialRendering] ) VALUES ( @PackageId, N'MLTITLE', N'DesktopModules/ModuleLocalization/MLTitle.ascx', NULL, NULL, 0 ) END
Info	End Sql execution: 03.00.00.SqlDataProvider file
Info	Finished Sql execution
Failure	Installation Failed - Script
Info	Installation Failed - ModuleLocalization
Info	Deleted temporary install folder
EndJob	Installation Failed

please use the latest version of the module, 05.00.09, some bugs with later dnn version were fixed. You can download the newest version from the snowcovered patch area

also, i see you are installing moduleLocalization instead of PageLocalization. Can you clarify please?

Sorry Erik,..my mistake,....you are right i'm instaling moduleLocalization 05.00.00. who can i solve this instalation error?

Ok, I soved the problem,...i deleted the rows mentioned the sql exception,..and it worked fine!