I'm running dNN 3.3.4 (recently upgraded from 3.3.3 to try and correct this problem).  I've been getting this error since I installed dNN 3.3.3.  Tonight I spotted the comments about the dbo. issue in the install SQL scripts, so I edited the scripts and updated the install ZIP, deleted the module from my portal and then re-uploaded the install file.  But I still have this error.

Any ideas?

Thanks
Craig

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 ---

Sorry for not replying to this thread earlier, been kinda bussy last few weeks

Getting this module to run is not very difficult, something has gone wrong in creating the sql scripts. What i'd suggest is the following procedure:

1. download the announcements 03.03.04 install package
2. unzip the downloaded file to an empty directory
3. replace in all sqlDataProvider files this:
     {databaseOwner}sysObjects
   into
     dbo.sysObjects
4. rezip all files into a zip file (you can call the zip file anything you like
5. logon as host into your portal, and go to the host>sql page
6. [edit] add expireDate field back to table, run the following script (select "run as script" and click "execute"):
   

   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
   
   [/edit]

7. enter the following command (this will reset the version of the module, that will allow dnn to run all sql scripts for this module again):
   
   update {objectQualifier}DesktopModules set version = '00.00.00' where ModuleName='DNN_Announcements'
   
8. Select "Run as Script", and click the "Execute" link
9. install the zip file you just created (and which contains the modified sqldataprovider files) just like you would install any other module (host > module definitions > upload module)

Mind you, the errors experienced with this module are not caused by a difference between SQL2000 and SQL2005, but are caused by the wrong usage of {databaseOwner}sysobjects, which will result in errors when your db user is not the dbo.

Cheers,

Erik

DNN Blog | Twitter: @erikvb | LinkedIn: