sort by class attribute .. bug or not complate ?

Tuesday 19 August 2003 8:16:51 am

Hi ..

am trying to sort data by class attribute work fine, but the data is duplicated , when take a look at 'ezcontentclass_attribute' table in the DB I found there is 2 version of the class .. maybe this the wrong ?
here is the the tmp code :

_________________________

{let tree=fetch('content','list',hash(parent_node_id,$node.node_id,
class_filter_type, "include",
class_filter_array, array($CompanyDataClassID),
sort_by,array(array('attribute',false(),207))
))}
{*sort_by,array(array("name",true()))*}
{section loop=$tree sequence=array(bglight,bgdark) name=Tree}
{section show=eq($Tree:item.data_map.first_ad_view.data_int,"1")}
{run-once}
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="1" valign="top"><img src={"spacer.gif"|ezimage} width="1" height="20">
</td>
<td valign="bottom"><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td bgcolor="#CCCCCC"><img src={"spacer.gif"|ezimage} width="1" height="1"></td>
</tr>
</table></td>
</tr>
</table>
<div style="BACKGROUND:#EFF0F0">{/run-once}
{node_view_gui view=first_ad content_node=$Tree:item}
{run-once}</div>{/run-once}
{section-else}
{node_view_gui view=ads content_node=$Tree:item Key=$Tree:number}
{/section}
{/section}

{/let}
________________________

207 is boolen (0,1) checkbox and just this line is duplicat the result :
{node_view_gui view=ads content_node=$Tree:item Key=$Tree:number}

any idea ?

thx.

Tuesday 19 August 2003 11:27:11 pm

any plz :(

Saturday 23 August 2003 8:31:09 am

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 !

thx in advance!

Friday 16 January 2004 8:22:20 am

Maybe its late but I had the same problem and I managed to solve it.

Look at:
http://ez.no/developer/ez_publish...ttribute_filter_ignores_translations

and

http://ez.no/developer/ez_publish...slation_duplicates_bug_incl_quickfix

-Berto