Products

Solutions

Resources

Partners

Community

Blog

About

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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Error when updating Admin Site SettingsError when updating Admin Site Settings
Previous
 
Next
New Post
7/11/2011 10:19 PM
 
ModuleId: 358
ModuleDefId: 14
FriendlyName: Site Settings
ModuleControlSource: DesktopModules/Admin/Portals/SiteSettings.ascx
AssemblyVersion: 5.6.3
PortalID: 0
PortalName:
UserID: 1
UserName:
ActiveTabID: 42
ActiveTabName: Site Settings
RawURL: /Admin/SiteSettings.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: https://www.website.com/Admin/SiteSettings.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; InfoPath.2; .NET4.0E; IPH 1.1.21.4019; Zune 4.7; .NET CLR 1.1.4322)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 51198172-13da-4f77-a3d2-e6bca04d4a6f
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.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.UpdatePortalInfo(Int32 PortalId, String PortalName, String LogoFile, String FooterText, DateTime ExpiryDate, Int32 UserRegistration, Int32 BannerAdvertising, String Currency, Int32 AdministratorId, Double HostFee, Double HostSpace, Int32 PageQuota, Int32 UserQuota, String PaymentProcessor, String ProcessorUserId, String ProcessorPassword, String Description, String KeyWords, String BackgroundFile, Int32 SiteLogHistory, Int32 SplashTabId, Int32 HomeTabId, Int32 LoginTabId, Int32 RegisterTabId, Int32 UserTabId, Int32 SearchTabId, String DefaultLanguage, Int32 TimeZoneOffset, String HomeDirectory, Int32 lastModifiedByUserID, String CultureCode) at DotNetNuke.Entities.Portals.PortalController.UpdatePortalInfo(Int32 PortalId, String PortalName, String LogoFile, String FooterText, DateTime ExpiryDate, Int32 UserRegistration, Int32 BannerAdvertising, String Currency, Int32 AdministratorId, Double HostFee, Double HostSpace, Int32 PageQuota, Int32 UserQuota, String PaymentProcessor, String ProcessorUserId, String ProcessorPassword, String Description, String KeyWords, String BackgroundFile, Int32 SiteLogHistory, Int32 SplashTabId, Int32 HomeTabId, Int32 LoginTabId, Int32 RegisterTabId, Int32 UserTabId, Int32 SearchTabId, String DefaultLanguage, Int32 TimeZoneOffset, String HomeDirectory, String CultureCode) at DotNetNuke.Modules.Admin.Portals.SiteSettings.cmdUpdate_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---
 
New Post
7/11/2011 10:22 PM
 
latest upgrade Fixed issue related to Module Settings access rights maybe this is related to my problem? What exactly was the issue here maybe this has some fall out on my application.
 
New Post
7/11/2011 10:32 PM
 
Maybe i should try upgrading to 6.0 beta??? :(
 
New Post
7/11/2011 11:01 PM
 
Cody,

Using SQL Server Management Studio or other similar tool compare the script of the UpdatePortalInfo stored procedure currently in the DNN installation's database with that found in the upgrade package's \Providers\DataProviders\SqlDataProvider\05.06.00.SqlDataProvider file. That is the most recently modified version of this stored procedure. I have seen this error mentioned in other forum posts - as I recall a tip off was that the @CultureCode parameter is missing from the stored procedure's parameters. If that is the case, the issue may go all the way back to the 05.02.00.SqlDataProvider script when the PortalLocalization table was first added. Unfortunately, if the UpdatePortalInfo stored procedure was not modified in 05.02.00, 05.02.03, 05.04.00 and finally in 05.06.00 there may be other problems with related database object updates having also failed.

I would also suggest looking at any non-empty  xx.xx.xx.log or xx.xx.xx.log.resources files found in the installations \Providers\DataProviders\SqlDataProvider folder. These would contain any SQL script errors logged during each upgrade. You may also examine the log files by navigating to the Host -->Host Settings page.

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
7/12/2011 1:04 PM
 
That's correct, the latest version of UpdatePortalInfo SP for 5.6.3 is located in Website\Providers\DataProviders\SqlDataProvider\05.06.00.SqlDataProvider. You may want to copy paste SQL script from line 855 to 917 into Host-SQL with Run as Script checkbox turned on. First statemenet will drop the existing SP, the second will create the new version. This should allow you to setup the UpdatePortalInfo SP the way code expects.

However, as William pointed out, it's likely more SPs didn't get updated due to an upgrade error. So, do look into the log files as William pointed to find out what exactly happened.

Also, verify that the DLL version of Bin\DotNetNuke.SqlDataProvider.dll file is 5.6.3 (right click->properties->details)

NOTE: ALWAYS BACKUP YOUR DATABASE BEFORE MAKING ADHOC CHANGES LIKE ABOVE.

Ash Prasad
Director of Engineering
DNN Corp.
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Error when updating Admin Site SettingsError when updating Admin Site Settings


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