I have a entity that use doctrine extension, tree behaviuor, i found problems in tree and don't know it's reason.
my entity:
MyEntity:
type: entity
gedmo:
tree:
type: nested
id:
id:
type: integer
generator:
strategy: AUTO
fields:
# ...
lft:
type: integer
gedmo:
- treeLeft
rgt:
type: integer
gedmo:
- treeRight
lvl:
type: integer
gedmo:
- treeLevel
root:
type: integer
gedmo:
- treeRoot
createdAt:
column: created_at
type: datetime
gedmo:
timestampable:
on: create
updatedAt:
column: updated_at
type: datetime
gedmo:
timestampable:
on: update
oneToMany:
children:
targetEntity: MyEntity
mappedBy: parent
orderBy:
lft: ASC
manyToOne:
parent:
targetEntity: MyEntity
inversedBy: children
joinColumn:
name: parent_id
referencedColumnName: id
onDelete: "restrict"
gedmo:
- treeParent
tree problem:(reported by verify() method)
0 => "index [8], duplicate on tree root: 1"
1 => "index [9], duplicate on tree root: 1"
2 => "index [20], duplicate on tree root: 1"
3 => "index [21], duplicate on tree root: 1"
4 => "node [8], left is greater than right on tree root: 1"
5 => "node [10] left is less than parent`s [7] left value"
6 => "node [16] right is greater than parent`s [7] right value"
7 => "node [19] right is greater than parent`s [6] right value"
8 => "node [20] right is greater than parent`s [6] right value"
9 => "node [21] right is greater than parent`s [6] right value"
10 => "node [22] right is greater than parent`s [6] right value"
11 => "node [23] right is greater than parent`s [6] right value"
12 => "node [24] right is greater than parent`s [6] right value"
13 => "node [31] left is less than parent`s [30] left value"
14 => "node [35] left is less than parent`s [8] left value"
15 => "node [36] left is less than parent`s [8] left value"
I found problem, when i delete a entity by $em->remove
method, doctrine extension assume that onDelete=cascade
for entity & change lft
& rgt
values of tree, then run query for removing of entity(and all children), but my entity have onDelete=restrict
, then lft
& rgt
values are updated, but children is not deleted and this raise error in tree