the faulty {databaseOwner}sysObjects can be found in the following files:
- 03.03.00.SqlDataProvider
- 03.03.02.SqlDataProvider
- 03.03.04.SqlDataProvider
The "Parameter count does not match Parameter Value count" error is caused by a change in the sprocs that is not applied if you db user does not have DBO rights. This seems to be a common practice in shared hosting environments
Maybe a quicker fix would be this (run all scripts from host>sql)
drop procedure {databaseOwner}{objectQualifier}GetAnnouncements
next run this script:
CREATE procedure {databaseOwner}{objectQualifier}GetAnnouncements
@ModuleId int,
@StartDate datetime,
@EndDate datetime
as
select {objectQualifier}Announcements.ItemId,
{objectQualifier}Announcements.ModuleId,
{objectQualifier}Announcements.CreatedByUser,
{objectQualifier}Announcements.CreatedDate,
{objectQualifier}Announcements.Title,
{objectQualifier}Announcements.URL,
{objectQualifier}Announcements.Description,
{objectQualifier}Announcements.ViewOrder,
{objectQualifier}Announcements.PublishDate,
{objectQualifier}UrlTracking.TrackClicks,
{objectQualifier}UrlTracking.NewWindow
from {objectQualifier}Announcements
left outer join {objectQualifier}UrlTracking on {objectQualifier}Announcements.URL = {objectQualifier}UrlTracking.Url and {objectQualifier}UrlTracking.ModuleId = @ModuleID
where {objectQualifier}Announcements.ModuleId = @ModuleId
and ( (({objectQualifier}Announcements.PublishDate >= @StartDate) or @StartDate is null) and (({objectQualifier}Announcements.PublishDate <= @EndDate) or @EndDate is null) )
order by {objectQualifier}Announcements.ViewOrder asc, {objectQualifier}Announcements.PublishDate desc
These two scripts will fix the GetAnnouncements sproc on your dnn instance.
The next version of announcements just entered the module release process, i hope it will be cleared for release soon.....
cheers,
Erik