How to correctly update the information in the table with nested sets?
Problem - lost the numbers in some entries in right and left fields. Information about the hierarchy is (parent_id field), and it is correct. How to convert right and left for the whole tree?
asked April 4th 20 at 00:45
Firstly solve the problem with the downed code. Some sort of crap has ruined your structure.
And secondly, restart the build.
PS how do you imagine editing errors? Let's say you have lost a parent. How to make a will?
The idea is to take the whole range and spread right to the left, but without seeing code and without knowing what the error is MATUSHKINO occupation.
1. List the integrity of the structure in the code.
2. Follow the validation errors and correct them consistently.
Find more questions by tags MySQLNested set