Hello everybody, We at VUB have an issue with the group application.
We have generated about 17000 groups. After adding a single group with the group creator the left and right values got mixed up: It's left value is greater than it's right value. It turns out the left_value is the same as the parent's right value. Once one group's left and right values are incorrectly assigned, the problem cascades, because upon creation, update and deletion the left and right values are calculated based upon incorrect values. Groups that were added later on still have inversed left and right values. It took us a while to notice the issue. At first sight there is nothing wrong : the group tree in the group browser renders correctly. This is because the rendering relies on the parent_id of the group objects and not on their left and right values. The problem only appears where the left and right values are used : eg.the element finder fails to show a specific group when searched. Before, we already fixed a problem that happened in case multiple groups were generated. In this case it was due to caching of the database retrieval of groups. The cache had to be bypassed. In this case we cannot find the issue. Caching doesn't interfere (and might as well be removed, since it messes up multiple group creation and does nothing with single group creation), since only the parent group (the node) is fetched from the database. I didn't manage to reproduce the issue. I have already made a script to rebuild the groups table, recalculating the left and right values based on the parent_ids. This is, however, no permanent solution. I was wondering if anybody has had similar experiences or if there are any thoughts/considerations on the matter. We are stuck for the moment. This could be a serious bug, considering that platform groups are very crucial to the platform. Best, -- Jens Vanderheyden Onderwijstechnoloog Departement Onderwijszaken Vrije Universiteit Brussel - Rectoraat Tel 02 629 13 06 _______________________________________________ Dev mailing list [email protected] http://lists.chamilo.org/listinfo/dev
