Can two groups have the same Left or Right values?

SELECT t.bundle, t.entity_id, t.subgroup_tree_value, l.subgroup_left_value, r.subgroup_right_value -> FROM group__subgroup_tree AS t LEFT JOIN group__subgroup_left AS l ON t.entity_id=l.entity_id -> RIGHT JOIN group__subgroup_right AS r ON t.entity_id=r.entity_id; +-------------+-----------+---------------------+---------------------+----------------------+ | bundle | entity_id | subgroup_tree_value | subgroup_left_value | subgroup_right_value | +-------------+-----------+---------------------+---------------------+----------------------+ | factory | 1 | 1 | 1 | 6 | | factory | 11 | 11 | 1 | 30 | | HR | 12 | 11 | 2 | 3 | | development | 20 | 11 | 4 | 5 | | development | 21 | 11 | 6 | 7 | | HR | 22 | 11 | 8 | 9 | | HR | 23 | 11 | 10 | 31 | | HR | 24 | 11 | 10 | 11 | | HR | 25 | 11 | 12 | 13 | | HR | 26 | 11 | 14 | 15 | | HR | 27 | 11 | 16 | 17 | | development | 28 | 11 | 18 | 19 | | development | 29 | 11 | 20 | 21 | | HR | 30 | 11 | 22 | 23 | | development | 31 | 11 | 24 | 25 | | HR | 32 | 11 | 26 | 27 | | HR | 33 | 11 | 28 | 29 | +-------------+-----------+---------------------+---------------------+----------------------+

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Comment over 1 year ago →
🇳🇱Netherlands Jan-E
Could it be that you have revisions enabled and reverted one of the groups to an earlier revision? That might lead to a corrupted tree:
See https://www.drupal.org/project/subgroup/issues/3281672#comment-14880993 🐛 doAddLeaf & doRemoveLeaf: timestamp bug and scalability Fixed
Comment about 1 year ago →
🇺🇸United States aytee
@Jan-E Would you be willing to share the script to rebuild trees from scratch?

I'm encountering challenges when cloning a Group that is in a Tree.
Comment about 1 year ago →
🇳🇱Netherlands Jan-E
Sorry, I overlooked this one. See https://gist.github.com/Jan-E/20218ef0b471756e0075287d3df761bc
Very unedited and only applicable with our structure: project = tree, case = subgroup, session = subsubgroup.
The idea is that you loop through the trees, loop through the subgroups below it, loop though the subsubgroups below the subgroups, start counting and formulate the queries to re-initialize all left & right values. With the argument tfr-rebuild-trees.php?execute=1 you execute all the queries.
db_left and db_right are the values from the database, sb_left and sb_right is what they should be. If they differ the query will bolded. See screenshot, made on my iPad. With no differences, because it was a long time agon that I had a corrupt tree.