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

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsSurveySurveyModulLoadExceptionModulLoadException
Previous
 
Next
New Post
2/11/2007 12:45 PM
 

Hi,

after installing it on my localsystem it runs fine, but on a host system i get always the following error:

ModuleId: 379
ModuleDefId: 102
FriendlyName: Survey
ModuleControlSource: DesktopModules/Survey/Survey.ascx
AssemblyVersion: 04.04.01
PortalID: 0
PortalName: KBT-Hurricanes
UserID: 1
UserName: host
ActiveTabID: 36
ActiveTabName: Home
RawURL: /Home/tabid/36/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 2ce0c83e-4b51-4095-a570-3361f3993666
InnerException: Input string was not in a correct format.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Number.StringToNumber
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: 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 System.String.System.IConvertible.ToInt32(IFormatProvider provider) at System.Convert.ToInt32(Object value) at DotNetNuke.Modules.Survey.SurveyController.GetSurvey(Int32 SurveyID, Int32 ModuleId) at DotNetNuke.Modules.Survey.Survey.lstSurvey_ItemDataBound(Object sender, DataListItemEventArgs e) at System.Web.UI.WebControls.DataList.OnItemDataBound(DataListItemEventArgs e) at System.Web.UI.WebControls.DataList.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) at System.Web.UI.WebControls.DataList.CreateControlHierarchy(Boolean useDataSource) at System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) at System.Web.UI.WebControls.BaseDataList.DataBind() at DotNetNuke.Modules.Survey.Survey.DisplaySurvey() at DotNetNuke.Modules.Survey.Survey.DisplaySurveyPage() at DotNetNuke.Modules.Survey.Survey.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source:
Server-Name: NTXPW15

It is the 4.00.50 Version.

Any suggestion's to that?

Best regards

Frank


 
New Post
2/11/2007 4:44 PM
 

Can you log in as host, select SQL from the HOST menu and paste this in the box:

Select SurveyID,
 ModuleID,
Question,
ViewOrder,
OptionType,
CreatedByUser,
CreatedDate,
'Votes' = ( select sum(Votes) from SurveyOptions where SurveyOptions.SurveyID = surveys.SurveyID )
from  Surveys where  ModuleID = 379

and click the execute link. Are there any missing or null fields besides "ViewOrder"?

The error indicates that it is executing the "GetSurvey" stored procedure and it returns these fields that are integers:

       SurveyID,
       ModuleID,
       ViewOrder,
       CreatedByUser,
       'Votes'

One of them has either a null value or a non integer. The code already handles "ViewOrder" so that shouldn't be the problem.



Michael Washington
http://ADefWebserver.com
www.ADefHelpDesk.com
A Free Open Source DotNetNuke Help Desk Module
 
New Post
2/12/2007 1:32 AM
 

Thanks for your reply,

I got this out:

SurveyID ModuleID Question ViewOrder OptionType CreatedByUser CreatedDate Votes
1 379 test 2 R 1 2/11/2007 6:18:09 PM 0

It seems to be ok, or?

I host on 1and1. it was not easy to get dnn work. could it be a problem with "subdirectory" in web.config?

<codeSubDirectories>
        <add directoryName="Survey" />
      </codeSubDirectories>

 

Frank

 
New Post
2/12/2007 9:01 AM
 
Kociemba wrote

SurveyID ModuleID Question ViewOrder OptionType CreatedByUser CreatedDate Votes
1 379 test 2 R 1 2/11/2007 6:18:09 PM 0

 

When I try to duplicate yur data I can't get the error. I need to dig deeper.

Can you run this query and tell me what you get?

select * from SurveyOptions

Also can you run this query:

exec getsurvey 1,379

It should be the same results as you just gave me. Thank you for your help. 



Michael Washington
http://ADefWebserver.com
www.ADefHelpDesk.com
A Free Open Source DotNetNuke Help Desk Module
 
New Post
2/12/2007 9:02 AM
 
Kociemba wrote

I host on 1and1. it was not easy to get dnn work. could it be a problem with "subdirectory" in web.config?

I don't think the subdirectoy is a problem. The entire site would crash if that entry were wrong.



Michael Washington
http://ADefWebserver.com
www.ADefHelpDesk.com
A Free Open Source DotNetNuke Help Desk Module
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsSurveySurveyModulLoadExceptionModulLoadException


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