Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsParameter count error when trying to access settings in 5.1.5Parameter count error when trying to access settings in 5.1.5
Previous
 
Next
New Post
12/29/2010 11:27 AM
 
Ron Miles


Joined: 8/27/2006
Posts: 54
I have a website running DNN v5.6.0, and I just recently installed the Events v5.1.5 module.  It installs without error, and I can add events/locations/categories without a problem, but when I try to access the Settings (that's the Events Settings from the toolbar, not the module settings from the action menu), the settings screen does  not come up and instead I get the message "A critical error has occurred. Parameter count does not match Parameter Value count."  The full stack dump in the event log is as follows:

AssemblyVersion: 5.6.0
PortalID: 0
PortalName: People of Faith
UserID: 1
UserName: host
ActiveTabID: 88
ActiveTabName: New Calendar
RawURL: /NewCalendar/tabid/88/ctl/EventSettings/mid/496/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.peopleoffaith.org/NewCalendar.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13 ( .NET CLR 3.5.30729; .NET4.0E)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: bd6c7071-960e-4563-82e5-619981eddcd9
InnerException: Parameter count does not match Parameter Value count.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: 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.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddListEntry(String ListName, String Value, String Text, Int32 ParentID, Int32 Level, Boolean EnableSortOrder, Int32 DefinitionID, String Description, Int32 PortalID, Boolean SystemList, Int32 CreatedByUserID) at DotNetNuke.Common.Lists.ListController.AddListEntry(ListEntryInfo ListEntry) at DotNetNuke.Modules.Events.EventController.AddLists() at DotNetNuke.Modules.Events.EventController.CreateListsAndSchedule() at DotNetNuke.Modules.Events.EventSettings.LoadSettings() at DotNetNuke.Modules.Events.EventSettings.Page_Load(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

I have tried uninstalling the module (including checking the box for Remove All Files) and reinstalling.  The install still goes without error, but I still get the same exception when trying to access the Events Settings screen.

The site was originally installed with DNN v4.9.x and has been regularly updated ever since.  The updates have never thrown any errors, and the site has functioned without any errors except this new one.  An earlier version of the Events module was installed, but was never used.

Any suggestions on how to resolve this error and access the Settings screen?
 
New Post
12/29/2010 12:33 PM
 
Roger Selwyn


www.thedivingclub.co.uk
Joined: 9/23/2004
Posts: 3531
Hi,

The location of the error suggests that one of your past DNN upgrades has not gone without error, since the fault is in the DNN core. This is shown by the first none Microsoft error location in the list 'at DotNetNuke.Common.Lists.ListController.AddListEntry'. This shows a call to the stored procedure AddListEntry is passing different parameters to the ones expected by the procedure. Since the ones shown are in line with what you would expect for DNN 5.6.0, this indicates the AddListEntry sproc stored in your database is out of sync. I'm not sure why...

Could you check the last entry returned by this 'Select * from {databaseOwner}{objectQualifier}Version' by entering it into the Host/SQL dialogue. Make sure the Major/Minor/Build versions are 5/6/0.

Also try running this - 'sp_helptext @objname = '{databaseOwner}{objectQualifier}AddListEntry'' and matching the parameter list shown in the first few lines to the parameter list shown in the error - 'String ListName, String Value, String Text, Int32 ParentID, Int32 Level, Boolean EnableSortOrder, Int32 DefinitionID, String Description, Int32 PortalID, Boolean SystemList, Int32 CreatedByUserID'.

Post back your results and we can advise from there.

Cheers
Roger
DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
New Post
12/29/2010 1:24 PM
 
Ron Miles


Joined: 8/27/2006
Posts: 54
The version table correctly lists 5.6.0, but looking at the AddListEntry sproc it appears I am missing the next-to-last parameter, Boolean SystemList.

Where would I find the drop/create script for the current version of that stored procedure?
 
New Post
12/29/2010 1:46 PM
 
Roger Selwyn


www.thedivingclub.co.uk
Joined: 9/23/2004
Posts: 3531
Looks like the last time it changed was in DNN 5.4.2. You can find all the dataproviders in the following folder under you website root:-

\Providers\DataProviders\SqlDataProvider

You will also find the log files in their showing any error messages from when they were run, so you should be able to trace back the error.

Shout if it isn't obvious which bit you need to re-run.

Roger
DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
New Post
12/29/2010 2:12 PM
 
Ron Miles


Joined: 8/27/2006
Posts: 54
That took care of me, thanks for the help!
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsParameter count error when trying to access settings in 5.1.5Parameter count error when trying to access settings in 5.1.5


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out