When Installing the Events Module version 3.2 on DNN 4.3.4 Platform running on a MS SQL 2000 Database I receive exceptions errors (see below). All other module uloads went fine thus for.  Is there a fix for this problem with the Event Module?

Thanks

Jeroen van Craaikamp
Netherlands

TaakBeginnen	Begin uitvoer Sql
Info	Uitvoeren03.01.00.SqlDataProvider
TaakBeginnen	Start uitvoer Sql: 03.01.00.SqlDataProvider bestand
Mislukt	SQL uitvoer leverde de volgende uitzonderingen op: System.Data.SqlClient.SqlException: Invalid column name 'Description'. 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.AddEvent @ModuleID int, @Description nvarchar(2000), @DateTime datetime, @Title nvarchar(100), @ExpireDate datetime = null, @UserName nvarchar(200), @Every int, @Period char(1), @IconFile nvarchar(256), @AltText nvarchar(50) as insert into Events ( ModuleID, Description, DateTime, Title, ExpireDate, CreatedByUser, CreatedDate, Every, Period, IconFile, AltText ) values ( @ModuleID, @Description, @DateTime, @Title, @ExpireDate, @UserName, getdate(), @Every, @Period, @IconFile, @AltText ) select SCOPE_IDENTITY() System.Data.SqlClient.SqlException: Invalid column name 'ItemId'. 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.DeleteEvent @ItemId int as delete from Events where ItemId = @ItemId System.Data.SqlClient.SqlException: Invalid column name 'CreatedByUser'. Invalid column name 'IconFile'. Invalid column name 'ItemId'. Invalid column name 'Description'. Invalid column name 'DateTime'. Invalid column name 'Title'. Invalid column name 'ExpireDate'. Invalid column name 'IconFile'. Invalid column name 'AltText'. Invalid column name 'ItemId'. 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.GetEvent @ItemId int, @ModuleId int as select Events.ItemId, Events.ModuleId, Events.Description, Events.DateTime, Events.Title, Events.ExpireDate, 'CreatedByUser' = Users.FirstName + ' ' + Users.LastName, Events.CreatedDate, Events.Every, Events.Period, 'IconFile' = case when Files.FileName is null then Events.IconFile else Files.Folder + Files.FileName end, Events.AltText from Events left outer join Users on Events.CreatedByUser = Users.UserId left outer join Files on Events.IconFile = 'fileid=' + convert(varchar,Files.FileID) where ItemId = @ItemId and ModuleId = @ModuleId System.Data.SqlClient.SqlException: Invalid column name 'IconFile'. Invalid column name 'ItemId'. Invalid column name 'Description'. Invalid column name 'DateTime'. Invalid column name 'Title'. Invalid column name 'ExpireDate'. Invalid column name 'CreatedByUser'. Invalid column name 'IconFile'. Invalid column name 'AltText'. Invalid column name 'DateTime'. Invalid column name 'DateTime'. Invalid column name 'DateTime'. 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.GetEventsByDate @ModuleId int, @StartDate datetime, @EndDate datetime as select Events.ItemId, Events.ModuleId, Events.Description, Events.DateTime, Events.Title, Events.ExpireDate, Events.CreatedByUser, Events.CreatedDate, Events.Every, Events.Period, 'IconFile' = case when Files.FileName is null then Events.IconFile else Files.Folder + Files.FileName end, Events.AltText from Events left outer join Files on Events.IconFile = 'fileid=' + convert(varchar,Files.FileID) where ModuleId = @ModuleId and ( (Period is null and (DateTime >= @StartDate and DateTime <= @EndDate)) or Period is not null ) order by DateTime System.Data.SqlClient.SqlException: Invalid column name 'IconFile'. Invalid column name 'IconFile'. Invalid column name 'ItemId'. Invalid column name 'Description'. Invalid column name 'DateTime'. Invalid column name 'Title'. Invalid column name 'ExpireDate'. Invalid column name 'CreatedByUser'. Invalid column name 'IconFile'. Invalid column name 'AltText'. Invalid column name 'ExpireDate'. Invalid column name 'ExpireDate'. Invalid column name 'DateTime'. Invalid column name 'ExpireDate'. Invalid column name 'ExpireDate'. 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.GetEvents @ModuleId int as select Events.ItemId, Events.ModuleId, Events.Description, Events.DateTime, Events.Title, Events.ExpireDate, Events.CreatedByUser, Events.CreatedDate, Events.Every, Events.Period, 'IconFile' = case when Files.FileName is null then Events.IconFile else Files.Folder + Files.FileName end, Events.AltText, 'MaxWIdth' = (select max(WIdth) from Events left outer join Files on Events.IconFile = 'fileid=' + convert(varchar,Files.FileID) where ModuleId = @ModuleId and (ExpireDate > getdate() or ExpireDate is null)) from Events left outer join Files on Events.IconFile = 'fileid=' + convert(varchar,Files.FileID) where ModuleId = @ModuleId and (ExpireDate > getdate() or ExpireDate is null) order by DateTime System.Data.SqlClient.SqlException: Invalid column name 'Description'. Invalid column name 'ItemId'. 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.UpdateEvent @ItemId int, @Description nvarchar(2000), @DateTime datetime, @Title nvarchar(100), @ExpireDate datetime = null, @UserName nvarchar(200), @Every int, @Period char(1), @IconFile nvarchar(256), @AltText nvarchar(50) as update Events set Description = @Description, DateTime = @DateTime, Title = @Title, ExpireDate = @ExpireDate, CreatedByUser = @UserName, CreatedDate = getdate(), Every = @Every, Period = @Period, IconFile = @IconFile, AltText = @AltText where ItemId = @ItemId
TaakEindigen	Einde Sql uitvoer: 03.01.00.SqlDataProvider gereed