1
Vote

Installation Failed - Script

description

Hello having a problem with the install...
I am running : DotNetNuke 6.1.2, trying to install: Contest 01.01.02 and am getting the following error.
 
 
Package Installation Report
 
See below for the results of the package installation
Error loading files from temporary folder - see below
StartJob Starting Installation
Info Starting Installation - DotNetNuke Content Library
Info Starting Installation - Assembly
Info Assembly registered - bin\DotNetNuke.ContentLibrary.dll
Info Created - bin\DotNetNuke.ContentLibrary.dll
Info Component installed successfully - Assembly
Info Starting Installation - File
Info Folder Created - D:\Hosting\6275181\html\dnn\DesktopModules\ContentLibrary\Documentation\
Info Created - DCL_License.txt
Info Created - DCL_ReleaseNotes.txt
Info Component installed successfully - File
Info Starting Installation - Script
Info Begin Sql execution
Info Folder Created - D:\Hosting\6275181\html\dnn\DesktopModules\ContentLibrary\Components\Data\DCL
Info Created - DCL\01.00.00.SqlDataProvider
Info Executing 01.00.00.SqlDataProvider
Info Start Sql execution: 01.00.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near '('. Must declare the scalar variable
 
"@UserFavoriteCount". Incorrect syntax near the keyword 'ELSE'. 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) CREATE
 
PROCEDURE dbo.[DCL_Favorite_Update] @Title NVARCHAR(50), @ContentItemID INT, @CreatedByUserID INT, @CreatedOnDate DATETIME AS BEGIN DECLARE
 
@UserFavoriteCount INT = ( SELECT COUNT(*) FROM dbo.DCL_Favorite WHERE CreatedByUserID = @CreatedByUserID AND ContentItemID = @ContentItemID ) IF
 
@UserFavoriteCount < 1 BEGIN INSERT dbo.DCL_Favorite ( Title, ContentItemID, CreatedByUserID, CreatedOnDate ) VALUES ( @Title, @ContentItemID,
 
@CreatedByUserID, @CreatedOnDate ) END ELSE BEGIN DELETE dbo.DCL_Favorite WHERE CreatedByUserID = @CreatedByUserID AND ContentItemID = @ContentItemID END END
 
System.Data.SqlClient.SqlException: Incorrect syntax near '('. Must declare the scalar variable "@UserRatingCount". Incorrect syntax near the keyword 'ELSE'.
 
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) CREATE PROCEDURE dbo.[DCL_Rating_Update] @RatingValue DECIMAL,
 
@ContentItemID INT, @ChildKeyID INT, @ChildTypeID INT, @CreatedByUserID INT, @CreatedOnDate DATETIME AS BEGIN DECLARE @UserRatingCount INT = ( SELECT COUNT
 
(*) FROM dbo.DCL_Rating WHERE CreatedByUserID = @CreatedByUserID AND ContentItemID = @ContentItemID AND ChildKeyID = @ChildKeyID AND ChildTypeID =
 
@ChildTypeID ) IF @UserRatingCount < 1 BEGIN INSERT dbo.DCL_Rating ( Value, ContentItemID, ChildKeyID, ChildTypeID, CreatedByUserID, CreatedOnDate ) VALUES (
 
@RatingValue, @ContentItemID, @ChildKeyID, @ChildTypeID, @CreatedByUserID, @CreatedOnDate ) END ELSE BEGIN UPDATE dbo.DCL_Rating SET Value = @RatingValue,
 
LastModifiedByUserID = @CreatedByUserID, LastModifiedOnDate = @CreatedOnDate WHERE CreatedByUserID = @CreatedByUserID AND ContentItemID = @ContentItemID AND
 
ChildKeyID = @ChildKeyID AND ChildTypeID = @ChildTypeID END END
Info End Sql execution: 01.00.00.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Rolling back component install - Assembly
Info Assembly unregistered - bin\DotNetNuke.ContentLibrary.dll
Info Component rolled back successfully - Assembly
Info Rolling back component install - File
Info Component rolled back successfully - File
Info Installation Failed - DotNetNuke Content Library
Info Deleted temporary install folder
EndJob Installation Failed

Return
Thank you not only for this module, your other modules and skins but also the time you may take to assist those of us in need.

file attachments

comments

cpaterra wrote Jun 11, 2012 at 5:34 PM

I am not exactly sure how this happened. I just tested this against SQL 2005 (where it would most likely be an issue and I already did 2008) and its fine. There will be a new release for 6.2 of the module that shouldn't be a problem.

wrote Dec 20, 2012 at 3:36 PM

bdlpb wrote Dec 20, 2012 at 3:36 PM

ok I am now running dnn 6.2.5 and deployed the latest Contest module and am still receiving the same error.

bdlpb wrote Jan 7, 2013 at 3:01 PM

Just wanted to update. I tried again and failed again. I tried the deploy method for this ext. however that did fail with the same errors as above. I then downloaded and installed that way with no issues. Thank you for the module and your time.

wrote Jan 7, 2013 at 3:20 PM

bdlpb wrote Jan 7, 2013 at 3:20 PM

Although I do I have another question...is the error shown in this picture just a styling issue or do I need to change some coding? This is the way it is formatted with all entries.

wrote Feb 13, 2013 at 9:44 PM