Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Alex Hill 7 posts 32 karma points
    Aug 03, 2009 @ 18:38
    Alex Hill
    0

    Unable to edit member types when Umbraco installed on MySQL

    Hi there I'm using:

     - Umbraco v4.0.0 (Assembly version: 1.0.3317.32692)
     - MySQL
     - ASP .NET 3.5
     - XP and IIS 5.1

    I originally had Umbraco installed on a Sql Server 2005 database where I created 3 different member types with various properties. I loaded data against this and decided at some point to switch to MySQL. It all seems to work fine except for the fact that I can't edit my member types anymore as I'm served with the following error:

    [InvalidCastException]: Specified cast is not valid.
       at umbraco.DataLayer.SqlHelper`1.ConvertScalar[T](Object scalar)
       at umbraco.DataLayer.SqlHelper`1.ExecuteScalar[T](String commandText, IParameter[] parameters)
    [SqlHelperException]: Umbraco Exception (DataLayer): SQL helper exception in ExecuteScalar
       at umbraco.DataLayer.SqlHelper`1.ExecuteScalar[T](String commandText, IParameter[] parameters)
       at umbraco.cms.businesslogic.member.MemberType.MemberCanEdit(PropertyType pt)
       at umbraco.cms.presentation.members.EditMemberType.dgEditExtras_itemdatabound(Object sender, DataGridItemEventArgs e)
       at System.Web.UI.WebControls.DataGrid.OnItemDataBound(DataGridItemEventArgs e)
       at System.Web.UI.WebControls.DataGrid.CreateItem(Int32 itemIndex, Int32 dataSourceIndex, ListItemType itemType, Boolean dataBind, Object dataItem, DataGridColumn[] columns, TableRowCollection rows, PagedDataSource pagedDataSource)
       at System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource)
       at System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e)
       at System.Web.UI.WebControls.BaseDataList.DataBind()
       at umbraco.cms.presentation.members.EditMemberType.setupExtraEditorControls()
       at umbraco.cms.presentation.members.EditMemberType.Page_Load(Object sender, EventArgs e)
       at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
       at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
       at System.Web.UI.Control.OnLoad(EventArgs e)
       at umbraco.BasePages.BasePage.OnLoad(EventArgs e)
       at System.Web.UI.Control.LoadRecursive()
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    [HttpUnhandledException]: Exception of type 'System.Web.HttpUnhandledException' was thrown.
       at System.Web.UI.Page.HandleError(Exception e)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest()
       at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
       at System.Web.UI.Page.ProcessRequest(HttpContext context)
       at ASP.umbraco_members_editmembertype_aspx.ProcessRequest(HttpContext context) in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\80eb830a\34fd6ea9\App_Web_editmembertype.aspx.590a8cbd.huwnweem.0.cs:line 0
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
    

    Any help would be greatly appreciated.

    Alex

  • Alex Hill 7 posts 32 karma points
    Aug 19, 2009 @ 15:11
    Alex Hill
    0

    Has anybody had this problem?

    Alex

  • Alex Hill 7 posts 32 karma points
    Aug 19, 2009 @ 16:16
    Alex Hill
    0

    For anyone who is interested, I upgraded to Umbraco version 4.0.2.1 and this problem seems to have gone away.

    Alex

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies