How to correctly update information in a table with nested sets?

Question

MySQL

Problem - figures in some records in right and left fields got off. There is information about the hierarchy (parent_id field) and it is correct. How to recalculate right and left for the whole tree?

Answer 1

First, solve the problem with the downed code. Some rubbish destroyed your structure.
And secondly, restart the build.
PS How do you imagine editing errors? Let's say you lost a parent. How will you contribute?
In theory, take the entire range and lay it out to the right to the left, but without seeing the code and not knowing what the mistake is, this is mother's occupation.

Answer 2

1. Write a structure integrity check in the code.
2. Watch for validation errors and correct them consistently.