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

Home All Forums

Home

Using DNN Platf...

Upgrading DNN P...

Error: Upgrading 7.3.4 to 7.4.1 (Urgent)

8/2/2015 4:31 AM

nectar

Joined: 4/14/2005

Posts: 232

Error: Upgrading 7.3.4 to 7.4.1 (Urgent)

I tried to upload our website from 7.3.4 to 7.4.1 but I'm getting the following error:

I run this https://dnnscript.codeplex.com/releases/view/132420

and this: https://dnnscript.codeplex.com/releases/view/132975

and also AdjustDNNPortalSettings740.sql

but no success. Any ideas?

Server Error in '/' Application.

Input string was not in a correct format.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.FormatException: Input string was not in a correct format.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


            [FormatException: Input string was not in a correct format.]
   System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +10725735
   System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +145
   System.String.System.IConvertible.ToInt32(IFormatProvider provider) +46
   System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) +510
   DotNetNuke.Collections.CollectionExtensions.ConvertValue(Object value) +100
   DotNetNuke.Collections.CollectionExtensions.GetValueOrDefault(IDictionary dictionary, String key, T defaultValue, Func`2 converter) +64
   DotNetNuke.Collections.CollectionExtensions.GetValueOrDefault(IDictionary dictionary, String key, T defaultValue) +55
   DotNetNuke.Entities.Portals.PortalSettingsController.LoadPortalSettings(PortalSettings portalSettings) +898
   DotNetNuke.Entities.Portals.PortalSettings.BuildPortalSettings(Int32 tabId, PortalInfo portal) +28
   DotNetNuke.Entities.Portals.PortalSettings..ctor(Int32 tabId, PortalAliasInfo portalAliasInfo) +94
   DotNetNuke.HttpModules.UrlRewrite.BasicUrlRewriter.RewriteUrl(Object sender, EventArgs e) +2131
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +136
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +69

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34249

8/2/2015 4:41 AM

nectar

Joined: 4/14/2005

Posts: 232

Re: Error: Upgrading 7.3.4 to 7.4.1 (Urgent) Modified By nectar on 8/2/2015 4:42:32 AM

When running the SQL AdjustDNNPortalSettings

I am getting the following error at the bottom:

(0 row(s) affected)

(6 row(s) affected)

(1 row(s) affected)

(0 row(s) affected)

Msg 8672, Level 16, State 1, Procedure sys_AdjustPortalSettingString, Line 18

The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row. A MERGE statement cannot UPDATE/DELETE the same row of the target table multiple times. Refine the ON clause to ensure a target row matches at most one source row, or use the GROUP BY clause to group the source rows.

8/2/2015 5:05 AM

Richard Howells

www.dynamisys.co.uk
Joined: 3/26/2006

Posts: 2001

Re: Error: Upgrading 7.3.4 to 7.4.1 (Urgent)

These things...

DotNetNuke.Entities.Portals.PortalSettingsController.LoadPortalSettings(PortalSettings portalSettings) +898
DotNetNuke.Entities.Portals.PortalSettings.BuildPortalSettings(Int32 tabId, PortalInfo portal) +28
DotNetNuke.Entities.Portals.PortalSettings..ctor(Int32 tabId, PortalAliasInfo portalAliasInfo)

...appearing in the stack trace make it a reasonable guess that your PortalSettings table contains bad data. The error message from Sebastian's script then suggests it's bad in a way that seriously upsets the script.

The presence of System.Number.ParseInt32 in the stack trace suggests it hit a PortalSetting that should be an integer but isn't.

So if it really is urgent then I suggest you take a very careful look at your PortalSettings table and use your intuition. You'll have to guess a bit. You are looking for a setting (or settings) that sounds like it should be an integer but is either empty or not an integer. In this context something like 1.0 is *not* an integer. Once you find some suspect data you need to change it to a 'reasonable' value.

I would *very strongly* advise you to take a backup of the data before you start hacking in there. You are operating without a safety net and you need a recovery plan if things go wrong.

I'm sure Sebastian would be interested in the before data. He may want to know why it caused his script to fail.

Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk

8/2/2015 5:51 AM

nectar

Joined: 4/14/2005

Posts: 232

Re: Error: Upgrading 7.3.4 to 7.4.1 (Urgent)

Thanks for the reply. I have reviewed the PortalSettings file but cannot find anything that might be wrong.

From what I've noticed, in the upgraded PortalSettings file most of the 'CultureCode' entries were null. Only a few were set to en-GB.

I have my PortalSettings (before the upgrade) uploaded as Excel file here: http://filebin.ca/2AjwNtGuCkGh

I have restored the database/files to their original version to keep the website running.

Please let me know if you have any further ideas.

8/2/2015 8:34 AM

Richard Howells

www.dynamisys.co.uk
Joined: 3/26/2006

Posts: 2001

Re: Error: Upgrading 7.3.4 to 7.4.1 (Urgent)

There is a JIRA ticket about PortalSettings https://dnntracker.atlassian.net/brow...

SMTPConnectionLimit and SMTPMaxIdleTime are mentioned. In your settings they are empty which is not a valid integer.

You have a cluster of SMTP* settings that are empty. I don't know what they should be, but I think it's suspicious that they are empty. I would try deleting the empty ones to get back to the default values.

Finally there is an SMTPPassword in your spreadsheet that maybe ought not to be publicly visible.

Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk

Page 1 of 2

Home

Using DNN Platf...

Upgrading DNN P...

Error: Upgrading 7.3.4 to 7.4.1 (Urgent)

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:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
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.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Server Error in '/' Application.

Input string was not in a correct format.

DNN Corp. (DotNetNuke)