Forums / General / Strange fetch error in EZ 4

Strange fetch error in EZ 4

Author Message

H. K.

Friday 07 March 2008 1:34:22 am

In EZ publish 4.0 I have stumbled upon a strange error when fetching a multi class front page folder.

I currently use this code to fetch a video section on the front page.

{def $video1=fetch( content, tree, hash( parent_node_id, 2,
                                         limit, 1,

                                         sort_by, array( published, false() ),

                                         'class_filter_array', array( 37 ),

                                          ) )}
{foreach $video1 as $vid1}


<div class="video1">
<div class="child">
<a href={$vid1.data_map.url.content|ezurl()}>
{attribute_view_gui attribute=$vid1.data_map.image image_class=videoremote}


{$vid1.name|wash}
</a>

</div>
</div>

{/foreach}

{undef $video1}

The code works, but when I publish a article and the front page is updated the video sections not longer works.

Output
No relation + Name of article (should not be there, since it’s not supposed to be fetch!!!)

When I clear all the case the problem remains, but when I publish a new video the section works again.

In my page I mainly use let not def, is this a likely cause of the problem or is it a bug?

H. K.

Thursday 13 March 2008 9:12:40 am

Since there have been no inputs, the error has been reported as a bug.

Hans Melis

Thursday 13 March 2008 10:24:15 am

You are using 'class_filter_array', but you haven't specified 'class_filter_type'. Without the type of class filtering, the filter array won't be used at all. The possible values for the type are 'include' and 'exclude'.

Use 'include' to restrict the fetch to objects of the content classes specified in the filter array. Use 'exclude' to fetch all objects except those of the content classes specified in the filter array.

So basically, all you do now is fetching the most recently published node instead of the most recently published video.

And do you have any special reason to use a foreach? It's not wrong of course, but you are limiting the fetch to 1 result so it's a bit of a waste to loop. You can also access the first element of an array by using an index, e.g. $video1[0].

Hans
http://blog.hansmelis.be

eZ debug

Timing: Jan 18 2025 11:10:18
Script start
Timing: Jan 18 2025 11:10:18
Module start 'content'
Timing: Jan 18 2025 11:10:19
Module end 'content'
Timing: Jan 18 2025 11:10:19
Script end

Main resources:

Total runtime0.7439 sec
Peak memory usage4,096.0000 KB
Database Queries194

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0054 588.8203180.8438
Module start 'content' 0.00540.6047 769.6641537.5547
Module end 'content' 0.61020.1336 1,307.2188332.7578
Script end 0.7438  1,639.9766 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00390.5257210.0002
Check MTime0.00150.2070210.0001
Mysql Total
Database connection0.00090.114710.0009
Mysqli_queries0.675590.80791940.0035
Looping result0.00210.28271920.0000
Template Total0.715296.120.3576
Template load0.00210.275820.0010
Template processing0.713195.864220.3566
Template load and register function0.00020.030710.0002
states
state_id_array0.00090.121410.0009
state_identifier_array0.00080.101820.0004
Override
Cache load0.00170.2294190.0001
Sytem overhead
Fetch class attribute can translate value0.00140.184530.0005
Fetch class attribute name0.00120.160840.0003
XML
Image XML parsing0.00080.106930.0003
class_abstraction
Instantiating content class attribute0.00000.001240.0000
General
dbfile0.00290.3920260.0001
String conversion0.00000.000730.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
3content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
5content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 13
 Number of unique templates used: 7

Time used to render debug report: 0.0002 secs