Hi,
When i try to install module following error has raise. How can i over come this
| Error loading files from temporary folder - see below |
| StartJob |
Starting Installation |
| Info |
Starting Installation - theDraftInclude |
| Info |
Starting Installation - Script |
| Info |
Begin Sql execution |
| Info |
Creating backup of previous version - 01.00.00.SqlDataProvider |
| Info |
Created - 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: Line 16: Incorrect syntax near '.'. 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 Stored Procedures **/ create procedure dbo.YourCompany_GettheDraftIncludes @ModuleId int as select ModuleId, ItemId, Content, CreatedByUser, $YourCompany$_$safeprojectname$.CreatedDate from YourCompany_theDraftInclude with (nolock) left outer join Users on YourCompany_theDraftInclude.CreatedByUser = Users.UserId where ModuleId = @ModuleId System.Data.SqlClient.SqlException: Line 14: Incorrect syntax near '.'. 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.YourCompany_GettheDraftInclude @ModuleId int, @ItemId int as select ModuleId, ItemId, Content, CreatedByUser, $YourCompany$_$safeprojectname$.CreatedDate from YourCompany_theDraftInclude with (nolock) left outer join Users on YourCompany_theDraftInclude.CreatedByUser = Users.UserId where ModuleId = @ModuleId and ItemId = @ItemId |
| Info |
End Sql execution: 01.00.00.SqlDataProvider file |
| Info |
Finished Sql execution |
| Failure |
Installation Failed - Script |
| Info |
Installation Failed - theDraftInclude |
| Info |
Deleted temporary install folder |
| EndJob |
Installation Failed |
|