Details
-
Bug
-
Resolution: Done
-
Blocker
-
None
-
None
-
None
Description
Transmogrification currently uses the code
$insql = "SELECT * FROM " . $this->tables[$t]['source'] . " ORDER BY id ASC"; |
to get the rows from the source table. The rows are ordered by id in ascending order and processed in that order.
The problem is that for the cous table the parent_id column may have a value for a row with a much larger id. This can happen when an "old" COU is made the child of a "new" COU.
The result currently is that any row (COU) where the parent id is greater than the id for the row being processed results in a foreign key constraint violation and the row (COU) is skipped.
Besides missing COUs, this causes problems later when roles are processed since the COU doesn't exist in the new table.
Attachments
Issue Links
- is subtask of
-
CFM-29 Transmogrify Command
- In Progress