I can't load any version of the Events Module into my DNN 6.0 portal. I even blew up my database and tried a fresh install. Following is the message I get. Searched the forum- couldn't find a related thread. If I missed something, will appreciate a link. <br />
<br />
This was specifically while trying to install Events 5.02.00 into a hosted portal running DNN 6.0.2<br />
<br />
Thanks,<br />
Ross<br />
<br />
<table id="dnn_ctr_Install_wizInstall" style="width: 100%; border-collapse: collapse;" cellspacing="0" cellpadding="0">
<tbody>
<tr style="height: 100%;">
<td valign="top">
<div class="dnnFormItem dnnInstallLogs dnnClear">
<table>
<tbody>
<tr>
<td class="NormalBold">StartJob</td>
<td class="NormalBold">Starting Installation</td>
</tr>
<tr>
<td class="Normal">Info</td>
<td class="Normal">Starting Installation - DNN_Events</td>
</tr>
<tr>
<td class="Normal">Info</td>
<td class="Normal">Starting Installation - Script</td>
</tr>
<tr>
<td class="Normal">Info</td>
<td class="Normal">Begin Sql execution</td>
</tr>
<tr>
<td class="Normal">Info</td>
<td class="Normal">Creating backup of previous version - Installation\03.01.00.SqlDataProvider</td>
</tr>
<tr>
<td class="Normal">Info</td>
<td class="Normal">Created - Installation\03.01.00.SqlDataProvider</td>
</tr>
<tr>
<td class="Normal">Info</td>
<td class="Normal">Executing 03.01.00.SqlDataProvider</td>
</tr>
<tr>
<td class="Normal">Info</td>
<td class="Normal">Start Sql execution: 03.01.00.SqlDataProvider file</td>
</tr>
<tr>
<td class="NormalRed">Failure</td>
<td class="NormalRed">SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): 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'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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 (0x80131904): Invalid column name 'ItemId'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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 (0x80131904): Invalid column name 'CreatedByUser'. Invalid column name 'IconFile'. Invalid column name 'ItemId'. 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'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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 (0x80131904): Invalid column name 'IconFile'. Invalid column name 'DateTime'. Invalid column name 'DateTime'. 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'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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 (0x80131904): Invalid column name 'IconFile'. Invalid column name 'ExpireDate'. Invalid column name 'ExpireDate'. 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 'IconFile'. Invalid column name 'ExpireDate'. Invalid column name 'ExpireDate'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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 (0x80131904): Invalid column name 'ItemId'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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 </td>
</tr>
<tr>
<td class="Normal">Info</td>
<td class="Normal">End Sql execution: 03.01.00.SqlDataProvider file</td>
</tr>
<tr>
<td class="Normal">Info</td>
<td class="Normal">Finished Sql execution</td>
</tr>
<tr>
<td class="NormalRed">Failure</td>
<td class="NormalRed">Installation Failed - Script</td>
</tr>
<tr>
<td class="Normal">Info</td>
<td class="Normal">Installation Failed - DNN_Events</td>
</tr>
<tr>
<td class="Normal">Info</td>
<td class="Normal">Deleted temporary install folder</td>
</tr>
<tr>
<td class="NormalBold">EndJob</td>
<td class="NormalBold">Installation Failed</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
<tr>
<td align="right">
<ul class="dnnActions dnnClear">
<li><a href=" __doPostBack('dnn$ctr$Install$wizInstall$FinishNavigationTemplateContainerID$finishButtonStep','')" title="Return" class="dnnPrimaryAction" id="dnn_ctr_Install_wizInstall_FinishNavigationTemplateContainerID_finishButtonStep">Return</a> </li>
</ul>
</td>
</tr>
</tbody>
</table>
<br />
|