1

Resolved

A critical error has occurred: Circular reference in self-nested table 'Menu'.

description

To correctly create a Sub Category, the user should:
  1. Go to Admin/ProductManagement/ProductCategories/
  2. Click ROOT
  3. On the right Hand side, select ROOT as a Parent Category Or select another category.
  4. Enter Name
  5. Select Save
     
    A major error occurs when a user tries to create a sub category and does not select ROOT in step 2.
    If a user selects a sub-category in step two and selects the same category name as its parent category on the right hand side, an error message of "A critical error has occurred: Circular reference in self-nested table 'Menu'." after pressing on save.
    The application is unusable at this point. The only way of fixing the application is to reinstall the database or edit the tables in the database.
     
    To recreate the error:
  6. Go to Admin/ProductManagement/ProductCategories/
  7. On the left side, click a subcategory under root.
  8. On the right Hand side, select the same category as its parent Category.
  9. Enter Name
  10. click Save.
     
    Images are attached.

file attachments

comments

katipunan wrote Aug 25, 2011 at 5:50 PM

in /web/admin/caegoryedit.aspx.cs, line 172, we used an if statement to check if Category ID and Parent ID is the same.

//if (category.CategoryId != parentId)

wrote Feb 14, 2013 at 12:29 AM

wrote May 16, 2013 at 5:12 AM

wrote May 16, 2013 at 5:12 AM

wrote Jun 14, 2013 at 7:49 AM