Hi I'm trying to install DNN 4.3.5 as a non dbo user (I've got db_ddladmin and dB-security role and changed databaseOwner to my ms sql username).

I still get two error messages in the installation  log, but at least I have  a working portal now. The text, event and blog work fine, but when I try to use the Survey module I get an error.

I'm able to add the module to the page without any problems, when I then try to add a question I get the following error message:

A critical error has occurred. Input string was not in a correct format.

And my event log says:

AssemblyVersion: 04.03.05
PortalID: 0
PortalName: My Website
UserID: 1
UserName: host
ActiveTabID: 53
ActiveTabName: test
RawURL: /Home/test/tabid/53/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://xxx/Home/test/tabid/53/ctl/Edit/mid/403/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1) Gecko/20061010 Firefox/2.0
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: eb8c1aad-3968-4d30-a176-0159e6224072
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 System.String.System.IConvertible.ToInt32(IFormatProvider provider) at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at System.Convert.ChangeType(Object value, Type conversionType) at DotNetNuke.Common.Utilities.CBO.CreateObject(Type objType, IDataReader dr, ArrayList objProperties, Int32[] arrOrdinals) at DotNetNuke.Common.Utilities.CBO.FillObject(IDataReader dr, Type objType, Boolean ManageDataReader) at DotNetNuke.Common.Utilities.CBO.FillObject(IDataReader dr, Type objType) 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.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.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: xxx

After this error the Add Question option also disappears from the Actions Menu.

Has this got something to do with my installation or with the module? Has anyone got experience installing dnn without the db owner role?

Thanks!

whow, that's quick ;-)

03.03.00, from the 4.3.5 install version

thanks again!

If you still get the error:

open up the file "SurveyController.vb" and change the line:

SurveyInfo.CreatedByUser = Convert.ToInt32(dr("CreatedByUser"))

to:

SurveyInfo.CreatedByUser = Convert.ToInt32(ConvertNullInteger(dr("CreatedByUser")))

 

Please report back. Thank You

---

Michael Washington
http://ADefWebserver.com

A Free Open Source DotNetNuke Help Desk Module