| Author |
Messages |
|
shamunda
Posts: 2
 |
| 25 Sep 2009 3:55 PM |
|
| Hello,
I'm trying to install your Extension demo, however upon doing so, it throws and exception :
-----------------------------------------------------------
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 7: Incorrect syntax near 'MAX'. Line 34: Incorrect syntax near 'MAX'. Line 35: Incorrect syntax near 'MAX'. Must declare the variable '@LoIdList'. 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.Zoo_Interzoic_LMS_ConditionGetByLoList @PortalID int, @ModuleId int, @LoIdList nvarchar(MAX) as DECLARE @query as VarChar(4000) set @query = ' select Zoo_Interzoic_LMS_Condition.[PortalId],' set @query = @query + ' Zoo_Interzoic_LMS_Condition.[ModuleId],' set @query = @query + ' Zoo_Interzoic_LMS_Condition.[ConditionId],' set @query = @query + ' Zoo_Interzoic_LMS_Condition.[LOID], ' set @query = @query + ' ConditionLO.[Title] as LOTitle, ' set @query = @query + ' Zoo_Interzoic_LMS_Condition.[Type], ' set @query = @query + ' Zoo_Interzoic_LMS_AttemptLimit.[AttemptLimit], ' set @query = @query + ' Zoo_Interzoic_LMS_AttemptLimit.[AttemptLimitCriteria], ' set @query = @query + ' Zoo_Interzoic_LMS_LOPrerequisite.[ConstraintId], ' set @query = @query + ' Zoo_Interzoic_LMS_LO.[Title] as ConstraintTitle, ' set @query = @query + ' Zoo_Interzoic_LMS_LOPrerequisite.[PrerequisiteCriteria], ' set @query = @query + ' Zoo_Interzoic_LMS_LORoleRequirements.[RoleId], ' set @query = @query + ' Zoo_Interzoic_LMS_LORoleRequirements.[RoleReqCriteria], ' set @query = @query + ' Zoo_Roles.[RoleName] ' set @query = @query + ' from dbo.Zoo_Interzoic_LMS_Condition ' set @query = @query + ' left join dbo.Zoo_Interzoic_LMS_LO as ConditionLO on dbo.Zoo_Interzoic_LMS_Condition.LOID = ConditionLO.LOID ' set @query = @query + ' left join dbo.Zoo_Interzoic_LMS_AttemptLimit on dbo.Zoo_Interzoic_LMS_Condition.ConditionId = dbo.Zoo_Interzoic_LMS_AttemptLimit.ConditionId ' set @query = @query + ' left join dbo.Zoo_Interzoic_LMS_LOPrerequisite on dbo.Zoo_Interzoic_LMS_Condition.ConditionId = dbo.Zoo_Interzoic_LMS_LOPrerequisite.ConditionId ' set @query = @query + ' left join dbo.Zoo_Interzoic_LMS_LORoleRequirements on dbo.Zoo_Interzoic_LMS_Condition.ConditionId = dbo.Zoo_Interzoic_LMS_LORoleRequirements.ConditionId ' set @query = @query + ' left join dbo.Zoo_Roles on dbo.Zoo_Interzoic_LMS_LORoleRequirements.RoleId = dbo.Zoo_Roles.RoleId ' set @query = @query + ' left join dbo.Zoo_Interzoic_LMS_LO on dbo.Zoo_Interzoic_LMS_LO.LOId = dbo.Zoo_Interzoic_LMS_LOPrerequisite.ConstraintId ' set @query = @query + ' where Zoo_Interzoic_LMS_Condition.PortalID = ' + Convert(nvarchar(MAX),@PortalID) set @query = @query + ' and Zoo_Interzoic_LMS_Condition.ModuleId = ' + Convert(nvarchar(MAX),@ModuleId) set @query = @query + ' and Zoo_Interzoic_LMS_Condition.LOId in (' + @LoIdList + ')' Exec ( @query) IF @@ERROR <> 0 BEGIN -- Raise an error and return RAISERROR ( @query, 16, 1) RETURN END
-----------------------------------------------------------
Could someone explain what is basically happening?
Thank you,
Sham |
|
|
|
|
Horacio
Interzoic Staff
Posts: 52
|
| 25 Sep 2009 4:43 PM |
|
Hello Sham,
Thanks for the request.
I guess you are running SQL Server 2000.
The module requires SQL Server 2005+. Any version will be ok, even the free SQL Express edition.
Please let us know if you have any question.
Thanks,
Horacio.- |
|
Interzoic Media
Accord LMS – Affordable, Flexible, Scalable - The Right Choice |
|
|
shamunda
Posts: 2
|
| 29 Sep 2009 1:05 PM |
|
| Ah that'll do it then :)
Thank you for the quick response! |
|
|
|
|
|