 |
|
|
 |
Joined: 11/9/2006
Posts: 5
|
|
|
Hi, I'm getting an error when trying to save basic portal settings at Admin - Site settings / Host - Portals - Edit Portal. Any suggestions? Thank you very much.
ModuleId: 321
ModuleDefId: 63
FriendlyName:
ModuleControlSource: DesktopModules/Admin/Portals/SiteSettings.ascx
AssemblyVersion: 5.6.2
PortalID: 0
PortalName: 14. sraz Fiat Marea Fan Clubu: Plzeň 2011
UserID: 1
UserName: vwaic
ActiveTabID: 17
ActiveTabName: Portals
RawURL: /Host/Portals/tabid/17/ctl/Edit/mid/321/pid/0/portalid/0/language/cs-CZ/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://14sraz.fiatmareaclub.com/Host/Portals/tabid/17/ctl/Edit/mid/321/pid/0/portalid/0/language/cs-CZ/Default.aspx
UserAgent: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 3d818a3b-47ab-4118-bd5c-9eb6fbb5668b
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 ---
Source:
Název serveru:DHARA
|
| |
|
|
 | |
|
|
 |
www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3253
|
|
|
Did you recently upgrade your DotNetNuke installation to 5.06.02?
The error is due to a version mismatch between the DotNetNuke code and the stored database procedure which updates the Portals table. Quite likely the UpdatePortalInfo stored procedure did not get modified as necessary as part of the upgrade to 5.06.00. If this is the only issue you have found and have access to the Host-->Sql command it will be relatively simple to rerun just that portion of the 5.06.00.SqlDataProvider script.
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
|
| |
|
|
| |
|
|
Joined: 12/29/2005
Posts: 10
|
|
|
I'm facing a similar problem. I've upgraded to 05.06.02 (previous installed version was 05.06.01) and now I can't change the site settings anymore.
Error is:
DotNetNuke.Services.Exceptions.ModuleLoadException: Parameter count does not match Parameter Value count. ---> System.ArgumentException: Parameter count does not match Parameter Value count. bei Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) bei Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) bei 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) bei 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) bei DotNetNuke.Modules.Admin.Portals.SiteSettings.cmdUpdate_Click(Object sender, EventArgs e)
I've already tried to re-run the UpdatePortalInfo-related part of the 05.06.00 update script but the problem still exists...
Is there anything else I can try?
|
| |
|
|
| |
|
|
Joined: 12/29/2005
Posts: 10
|
|
|
Okay, got it working by simply re-applying the 05.06.02 update. Now everything seems to work.
|
| |
|
|
| |
|
|
|
Joined: 11/9/2006
Posts: 5
|
|
|
Hi, I finally had time and wanted to fix this...
The error was in the UpdatePortalInfo stored procedure, which didn't get update probably when uprading from 05.06.01 to 02. I compared the db scheme with RedGate SQL Compare with a clean install 05.06.02 db and found it missing TimeZoneOffset. Red Gate SQL Compare generated an update script, which I executed and voilá... Fixed.
Thanks for the suggestion.
|
| |
|
|
| |