after I got the sql debug and make the query via phpmysql i got duplicated rows .. this mean my code is ok, and also the bug is either the inserting to the DB or the query from DB .. I hope is the query is the error rather than the insertion !
this is the query from sql debug :
__________
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
, ezcontentobject_attribute as a0
WHERE
path_string like '/1/2/43/49/51/%' and depth <= 5 and
a0.contentobject_id = ezcontentobject.id AND
a0.contentclassattribute_id = 207 AND
a0.version = ezcontentobject_name.content_version AND
ezcontentclass.version=0 AND
node_id != 51 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
( ezcontentobject.contentclass_id = '15' ) AND
ezcontentobject_tree.contentobject_is_published = 1
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
ezcontentobject_name.content_translation = 'he'
ORDER BY a0.sort_key DESC
LIMIT 0, 10 _____________________________
pls don`t take this as I flooding the forum, just adding the latest what i get to discover who need to modify, me or ez crew !
