Copied to clipboard

Flag this post as spam?

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


These support forums are now closed for new topics and comments.
Please head on over to http://eureka.ucommerce.net/ for support.

  • Sonni Tost 20 posts 72 karma points
    Feb 04, 2014 @ 15:44
    Sonni Tost
    0

    Error / Multiple controls with the same ID

    Hi again,

    I have a customer whose website has been running without problems for 6 to 8 months.

    All of a sudden a couple of products cannot be edited and returns an Application Error. When I read the Umbraco Log it says:

    At /umbraco/ucommerce/catalog/editproduct.aspx?id=1369&parentcategoryId=177 (Referred by: http://www.shop4her.dk/umbraco/ucommerce/catalog/editcategory.aspx?id=177): System.Web.HttpException (0x80004005): Multiple controls with the same ID 'InventoryOnHand' were found. FindControl requires that controls have unique IDs.     at System.Web.UI.Control.FillNamedControlsTable(Control namingContainer, ControlCollection controls)     at System.Web.UI.Control.FindControl(String id, Int32 pathOffset)     at System.Web.UI.Control.FindControl(String id)     at System.Web.UI.WebControls.BaseValidator.CheckControlValidationProperty(String name, String propertyName)     at System.Web.UI.WebControls.BaseValidator.ControlPropertiesValid()     at System.Web.UI.WebControls.BaseValidator.OnPreRender(EventArgs e)     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    How can this be?

    Fortunately both products are up for deletion - but how do I do that? Does anybody have an SQL Query that I can run to delete the two products?

    The site is running on uCommerce 3.0.8.13078

    Kind regards

     

    Sonni T.

  • Morten Skjoldager 440 posts 1499 karma points
    Feb 06, 2014 @ 11:54
    Morten Skjoldager
    0

    This will happen from time to time if you switch between multi lingual properties and/or some bizare timing issues force a duplicate row in the database.

    You should take a look at your product properties table and see if there's a duplicate row with InventoryOnHand and then delete the one. 

    You can find inspiration here:

    http://www.publicvoid.dk/DeleteAllProductsStoredInUCommerceUsingSQL.aspx

    Note that you might want to have a where clause that holds the id of the product you want to delete :)

    Hope this helps.

    Regards

    Morten

Please Sign in or register to post replies

Write your reply to:

Draft