 |
|
|
www.chapmantripp.com
Joined: 3/11/2004
Posts: 19
|
|
|
Thanks Erik,
got a few errors during the install, but I'm guessing that's due to the DB being at the Announcements v3.3.4 level at the start.
But I'm still getting an error in the Announcements module:
Error: Announcements is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Parameter count does not match Parameter Value count. ---> System.ArgumentException: Parameter count does not match Parameter Value count. at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Announcements.SqlDataProvider.GetAnnouncements(Int32 ModuleId, DateTime StartDate, DateTime EndDate) at DotNetNuke.Modules.Announcements.AnnouncementsController.GetAnnouncements(Int32 ModuleId, DateTime StartDate, DateTime EndDate) at DotNetNuke.Modules.Announcements.Announcements.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
Any other ideas?
Thanks
Craig
Error during install:
| StartJob |
Begin Sql execution |
| Info |
Executing 03.01.00.SqlDataProvider |
| StartJob |
Start Sql execution: 03.01.00.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'ExpireDate'. 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 recchurch.dnn3_AddAnnouncement @ModuleId int, @UserName nvarchar(100), @Title nvarchar(150), @URL nvarchar(150), @ExpireDate DateTime, @Description nvarchar(2000), @ViewOrder int as insert into dnn3_Announcements ( ModuleId, CreatedByUser, CreatedDate, Title, URL, ExpireDate, Description, ViewOrder ) values ( @ModuleId, @UserName, getdate(), @Title, @URL, @ExpireDate, @Description, @ViewOrder ) select SCOPE_IDENTITY() System.Data.SqlClient.SqlException: Invalid column name 'ExpireDate'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE procedure recchurch.dnn3_GetAnnouncement @ItemId int, @ModuleId int as select dnn3_Announcements.ItemID, dnn3_Announcements.ModuleID, dnn3_Announcements.Title, 'URL' = case when dnn3_Files.FileName is null then dnn3_Announcements.URL else dnn3_Files.Folder + dnn3_Files.FileName end, dnn3_Announcements.ExpireDate, dnn3_Announcements.Description, 'CreatedByUser' = dnn3_Users.FirstName + ' ' + dnn3_Users.LastName, dnn3_Announcements.CreatedDate, dnn3_Announcements.ViewOrder, dnn3_UrlTracking.TrackClicks, dnn3_UrlTracking.NewWindow from dnn3_Announcements left outer join dnn3_Users on dnn3_Announcements.CreatedByUser = dnn3_Users.UserId left outer join dnn3_UrlTracking on dnn3_Announcements.URL = dnn3_UrlTracking.Url and dnn3_UrlTracking.ModuleId = @ModuleID left outer join dnn3_Files on dnn3_Announcements.URL = 'fileid=' + convert(varchar,dnn3_Files.FileID) where dnn3_Announcements.ItemId = @ItemId and dnn3_Announcements.ModuleId = @ModuleId System.Data.SqlClient.SqlException: Invalid column name 'ExpireDate'. Invalid column name 'ExpireDate'. Invalid column name 'ExpireDate'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE procedure recchurch.dnn3_GetAnnouncements @ModuleId int as select dnn3_Announcements.ItemId, dnn3_Announcements.ModuleID, dnn3_Announcements.CreatedByUser, dnn3_Announcements.CreatedDate, dnn3_Announcements.Title, 'URL' = case when dnn3_Files.FileName is null then dnn3_Announcements.URL else dnn3_Files.Folder + dnn3_Files.FileName end, dnn3_Announcements.ExpireDate, dnn3_Announcements.Description, dnn3_Announcements.ViewOrder, dnn3_UrlTracking.TrackClicks, dnn3_UrlTracking.NewWindow from dnn3_Announcements left outer join dnn3_UrlTracking on dnn3_Announcements.URL = dnn3_UrlTracking.Url and dnn3_UrlTracking.ModuleId = @ModuleID left outer join dnn3_Files on dnn3_Announcements.URL = 'fileid=' + convert(varchar,dnn3_Files.FileID) where dnn3_Announcements.ModuleId = @ModuleId and (dnn3_Announcements.ExpireDate > GetDate() or dnn3_Announcements.ExpireDate is null) order by dnn3_Announcements.ViewOrder asc, dnn3_Announcements.CreatedDate desc System.Data.SqlClient.SqlException: Invalid column name 'ExpireDate'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure recchurch.dnn3_UpdateAnnouncement @ItemId int, @UserName nvarchar(100), @Title nvarchar(150), @URL nvarchar(150), @ExpireDate datetime, @Description nvarchar(2000), @ViewOrder int as update dnn3_Announcements set CreatedByUser = @UserName, CreatedDate = GetDate(), Title = @Title, URL = @URL, ExpireDate = @ExpireDate, Description = @Description, ViewOrder = @ViewOrder where ItemId = @ItemId |
| EndJob |
End Sql execution: 03.01.00.SqlDataProvider file |
| |
| Info |
Executing 03.03.00.SqlDataProvider |
| StartJob |
Start Sql execution: 03.03.00.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because column 'ExpireDate' does not exist in table 'dnn3_Announcements'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE recchurch.dnn3_Announcements DROP COLUMN ExpireDate |
| EndJob |
End Sql execution: 03.03.00.SqlDataProvider file |
| |
| Info |
Executing 03.03.01.SqlDataProvider |
| StartJob |
Start Sql execution: 03.03.01.SqlDataProvider file |
| EndJob |
End Sql execution: 03.03.01.SqlDataProvider file |
| |
| Info |
Executing 03.03.02.SqlDataProvider |
| StartJob |
Start Sql execution: 03.03.02.SqlDataProvider file |
| EndJob |
End Sql execution: 03.03.02.SqlDataProvider file |
| |
| Info |
Executing 03.03.04.SqlDataProvider |
| StartJob |
Start Sql execution: 03.03.04.SqlDataProvider file |
| EndJob |
End Sql execution: 03.03.04.SqlDataProvider file |
| |
| EndJob |
Finished Sql execution |
|
| |
|
|
 | |
|
|
 |
 |
erikvanballegoij.com
Joined: 4/7/2004
Posts: 4445
|
|
|
Craig,
Thanks for bearing with me...
Indeed this is caused by the db already being in 3.3.4 state. If you add this sql script between steps 5 and 6 in my previous post, the process should run correct:
if not exists (select * from dbo.syscolumns where id = object_id(N'{databaseOwner}{objectQualifier}Announcements') and name=N'ExpireDate')
begin
ALTER TABLE {databaseOwner}{objectQualifier}Announcements ADD [ExpireDate] [datetime] NULL
end
Cheers,
Erik
Erik van Ballegoij, Former DNN Corp. Employee and DNN Expert
DNN Blog | Twitter: @erikvb | LinkedIn: 
|
| |
|
|
| |
|
|
www.chapmantripp.com
Joined: 3/11/2004
Posts: 19
|
|
|
Hi Erik,
thanks for that, but unfortunatly, aside from clearing the errors when the module is imported, it hasn't cleared the problem.
Very strange!
Soon'ish
Craig
|
| |
|
|
| |
|
|
|
|
erikvanballegoij.com
Joined: 4/7/2004
Posts: 4445
|
|
|
craig,
can you contact me on msn at support@apollo-software.nl?
If you like i can have a look at your install to try to find out what's wrong
cheers,
Erik
Erik van Ballegoij, Former DNN Corp. Employee and DNN Expert
DNN Blog | Twitter: @erikvb | LinkedIn:
|
| |
|
|
| |
|
|
Joined: 8/4/2005
Posts: 28
|
|
|
I have basically the same problem. After following all the steps as outlined, it's still not working. The difference is that I am still having an error while installing the new corrected module. It doesn't seem to accept {databaseOwner}Announcements as a valid table.
I went ahead and deleted the Announcements module entirely, then tried to install the corrected module (03.03.04 install package with the corrections as outlined above), but am still getting the same error.
Help!
|
| |
|
|
| |