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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 31 2025 08:13:38
Script start
Timing: Jan 31 2025 08:13:38
Module start 'layout'
Timing: Jan 31 2025 08:13:38
Module start 'content'
Timing: Jan 31 2025 08:13:38
Module end 'content'
Timing: Jan 31 2025 08:13:38
Script end

Main resources:

Total runtime0.0171 sec
Peak memory usage2,048.0000 KB
Database Queries3

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0069 588.2813151.2266
Module start 'layout' 0.00690.0028 739.507836.6797
Module start 'content' 0.00960.0058 776.187594.2500
Module end 'content' 0.01540.0017 870.437533.9922
Script end 0.0171  904.4297 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.002313.6527140.0002
Check MTime0.00116.3356140.0001
Mysql Total
Database connection0.00095.515710.0009
Mysqli_queries0.004124.047030.0014
Looping result0.00000.064110.0000
Template Total0.00137.610.0013
Template load0.00095.391710.0009
Template processing0.00042.198810.0004
Override
Cache load0.00063.672510.0006
General
dbfile0.002213.000280.0003
String conversion0.00000.034940.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs