Looking help on issue - have started noticing error when trying to change settings on any page or module. the error i get is
for page
Error: 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.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.UpdateTab(Int32 TabId, Int32 PortalId, String TabName, Boolean IsVisible, Boolean DisableLink, Int32 ParentId, String IconFile, String IconFileLarge, String Title, String Description, String KeyWords, Boolean IsDeleted, String Url, String SkinSrc, String ContainerSrc, String TabPath, DateTime StartDate, DateTime EndDate, Int32 RefreshInterval, String PageHeadText, Boolean IsSecure, Boolean PermanentRedirect, Single SiteMapPriority, Int32 LastModifiedByUserID, String CultureCode) at DotNetNuke.Entities.Tabs.TabController.UpdateTab(TabInfo updatedTab, String CultureCode) at DotNetNuke.Entities.Tabs.TabController.UpdateTab(TabInfo updatedTab) at DotNetNuke.Modules.Admin.Tabs.ManageTabs.SaveTabData(String strAction) at DotNetNuke.Modules.Admin.Tabs.ManageTabs.cmdUpdate_Click(Object Sender, EventArgs e) --- End of inner exception stack trace ---
or
for module
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.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.UpdateModule(Int32 ModuleId, String ModuleTitle, Boolean AllTabs, String Header, String Footer, DateTime StartDate, DateTime EndDate, Boolean InheritViewPermissions, Boolean IsDeleted, Int32 lastModifiedByUserID) at DotNetNuke.Entities.Modules.ModuleController.UpdateModule(ModuleInfo objModule) at DotNetNuke.Modules.Admin.Modules.ModuleSettingsPage.cmdUpdate_Click(Object Sender, EventArgs e) --- End of inner exception stack trace ---
recently hade a problem with an update from 5.2.2 > 5.2.3. which required deleting the sproc UpdatePortalInfo and running the sql that failed. sql ran ok
http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/200/postid/353614/scope/posts/Default.aspx#353614
i see the above error is related to UpdateTab/UpdateModule but looking for issues to check for relating to Parameter count does not match Parameter Value count