I have an MPTT tree of over 100,000 records stored in MySQL using lft, rght and parent_id columns. Now the left/right values became corrupted, while the parent ids are still intact. It would require tons of queries to repair it in the application layer. Is there a good way to put the burden on the database and have it recalculate the lef...
I'm trying to make a copy of a FeinCMS page tree, which is managed using django-mptt. I wrote this function: def make_tree_copy(page, parent=None): ''' Makes a copy of the tree starting at "page", reparenting it to "parent" ''' new_page = Page.objects.create_copy(page) new_page.save() Page.tree.move_node(new_page...
I have a MPTT organized MySql database which i need to display , there is no level limit and i can't alter the database, i've tryed http://dev.mysql.com/tech-resources/articles/hierarchical-data.html, but still got me a few headeachs. ...