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 ...exception After upgrade to 4.3.3 - logging in to host acctexception After upgrade to 4.3.3 - logging in to host acct
Previous
 
Next
New Post
7/20/2006 11:35 AM
 

Ok guys - here's a fun one for you.

I upgraded from 4.3.2 to 4.3.3 - running sql 2000 - and logged in to host acct - I received the following exception (now, this is pulled from the logs - obviously not what it displayed on the screen right then - it just gave the output from the exception)

AssemblyVersion: 04.03.03
PortalID: 0
PortalName: South Carolina State Constables Association
UserID: 1
UserName: host
ActiveTabID: 59
ActiveTabName: Home
RawURL: /Default.aspx?tabid=59&error=Input+string+was+not+in+a+correct+format.&content=0
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.scconstables.org/Login/tabid/188/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 00f467d9-6ebd-4fae-9759-39a4101dc9c1
InnerException: Input string was not in a correct format.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Number.StringToNumber
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Input string was not in a correct format. ---> System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at DotNetNuke.Entities.Users.UserProfile.get_TimeZone() at DotNetNuke.Entities.Users.UserTime.get_ClientToServerTimeZoneFactor() at DotNetNuke.Entities.Users.UserTime.get_CurrentUserTime() at DotNetNuke.UI.Skins.Controls.CurrentDate.Page_Load(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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Server Name: SCTWMHWEB01

Now - this DID NOT happen when I logged in under my personal account (which does have admin rights) on this site.

I noticed this part of the exception:
DotNetNuke.Entities.Users.UserProfile.get_TimeZone() at DotNetNuke.Entities.Users.UserTime.get_ClientToServerTimeZoneFactor() at

and of course, since the host acct doesn't necessarily have a profile, this property is not going to exist, ergo it causes an exception.

I went into the database and manually added a timezone entry for the host profile and the problem went away.

Someone may want to look at that, though...

Thanks,

Chavous

 


--- Chavous P. Camp
 
New Post
7/24/2006 7:53 AM
 

I went into the database and manually added a timezone entry for the host profile and the problem went away.

Can you tell me how you did this please, do you have a script?

 

Thanks

 
New Post
7/24/2006 3:05 PM
 

I don't have a script - i just went in and added an entry in sql enterprise manager.  Shouldn't be too hard to come up w/ a script tho...

Open the ProfilePropertyDefinition table...

find the PropertyDefinitionID where the PortalID=null and the propertyname is "TimeZone"

In MY case, it happens to be 18.

I then created an entry in the UserProfile table

ProfileID UserID PropertyDefinitionID PropertyValue PropertyText Visibility LastUpdatedDate
(auto) 1 (or whatever uid your host acct has) 18 (or whatever yours is) -300 (this is for US/Eastern) <leave null> 0 CURRENT_TIMESTAMP

YOUR MILEAGE MAY VARY.  I'M NOT RESPONSIBLE IF YOU BLOW UP YOUR DATABASE.

Good Luck!


--- Chavous P. Camp
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...exception After upgrade to 4.3.3 - logging in to host acctexception After upgrade to 4.3.3 - logging in to host acct


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