Forums / Developer / Attribute Filter - works on one server but not another...

Attribute Filter - works on one server but not another...

Author Message

steve walker

Wednesday 15 February 2006 10:55:52 am

Hi there,

We have a strange issue that I hope is just a config tweak somewhere.

We have a legacy (shared) server we have developed a site on, its unix based (freebsd I think), php4.3.3, Apache/1.3.28, Mysql 4.0.14.

The url to the site on this box is http://dev2.oneworldmarket.org/ - its all working fine.

We have just setup our new dedicated server (hurray :) which is runnnig linux, php 4.3.1, Apache 2, Mysql 4.1.15 with eaccelerator

We've migrated the site to this new box http://ccb.owmnameserver.com/ - what we've found is that in any situation where an attribute filter is used in a fetvh no data is displayed. You'll see nothing displays on the home page because of this, but if you click to other pages it works fine.

We have sussed the issue is with attribute filter because if you have:

{let front_banners=fetch( 'content', 'tree', hash( 'parent_node_id', 1372,
		class_filter_type, "include", class_filter_array, array(153),
		attribute_filter, array( array( 'adverts/frontpage', '=', 1 ) )
		))|shuffle}

nothing is displayed, but if we change the fetch to:

{let front_banners=fetch( 'content', 'tree', hash( 'parent_node_id', 1372,
		class_filter_type, "include", class_filter_array, array(153)
		))|shuffle}	

the data is displayed fine...

You can view all data from the admin interface fine, so I dont believe this is to do with the change in mysql versions (the import normally errors if there is) and the boxes are pretty similar in spec.

Does anyone know why this is happening and what the fix is?

Many thanks, Steve.

http://www.oneworldmarket.co.uk

Kristof Coomans

Wednesday 15 February 2006 11:36:36 pm

Did you see any errors or warnings (related to the attribute filter) in the debug output?

Take a look in the cache directory (probably var/<i>yoursiteaccessname</i>/cache). Are there two files classattributeidentifiers_<i>yoursiteaccessname</i>.php and classidentifiers_<i>yoursiteaccessname</i>.php? Has the webserver write access to this folder? Remove these two files and try again.

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

steve walker

Thursday 16 February 2006 1:51:55 am

Hey Kristof,

Many thanks for helping with this.

Have now got it working - the site.ini file was pointing to var/news and I changed it over to var/ccb and it started working - those files were absent from the var folders.

Why specifiying a different cache folder should make a difference when it worked on the proevious server I dont know, but hey it works!

Kind regards, Steve

http://www.oneworldmarket.co.uk

eZ debug

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

Main resources:

Total runtime0.2998 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0068 589.1016180.8125
Module start 'content' 0.00680.0078 769.914197.9922
Module end 'content' 0.01460.2852 867.9063527.9219
Script end 0.2998  1,395.8281 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00331.0869200.0002
Check MTime0.00120.4107200.0001
Mysql Total
Database connection0.00080.282510.0008
Mysqli_queries0.242080.72831410.0017
Looping result0.00190.63051390.0000
Template Total0.284895.010.2848
Template load0.00080.255510.0008
Template processing0.284194.742210.2841
Override
Cache load0.00050.172110.0005
Sytem overhead
Fetch class attribute can translate value0.00080.282910.0008
XML
Image XML parsing0.00030.094110.0003
General
dbfile0.01364.5325200.0007
String conversion0.00000.002330.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
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0002 secs