check and repair for missing parentID in classifications

Description

We have do redundant data in table MCRCategory describing the hierarchy of category. Adjacent list using parentID and positionInParent and nested sets using leftValue and rightValue. If the check command shows no error for leftValue and rightValue, there may still a problem with parentID == null. We need a command to detect and fix those columns.

Environment

None

Assignee

Thomas Scheffler

Reporter

Thomas Scheffler

Labels

None

URL

None

External issue ID

None

Fix versions

Priority

Medium
Configure