Siteaccess trying to access contentobjects via cluster db

Author Message

Geoff Bentley

Thursday 09 October 2008 2:14:10 pm

I've clusterized a 4.0.1 site (in an extension), and get the following when visiting the front-end siteaccess:

<i>
Fatal error: Call to a member function sortArray() on a non-object in ezpublish-4.0.1/kernel/common/eztreemenuoperator.php
</i>

Further down in the debug, I can see it's accessing contentobjects (& everything) using the file.ini.append.php details:

<i>
Query error: Table 'dev-data.ezcontentobject_tree' doesn't exist.
</i>

Have searched issues.ez.no & the forum for clues, to no avail. Permissions and ownership on var dir is fine. Removing the file.ini.append.php resolves the problem of db access. Have updated index_treemenu.php to SVN version as per docs, but have also tested on the old version, with no success.

Any suggestions for debugging this?

Björn Dieding@xrow.de

Thursday 09 October 2008 9:07:40 pm

Your database base is totally broken. Start all over.

There is no help if ezcontentobject_tree is lost.

Else recover from backup.

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

Geoff Bentley

Sunday 12 October 2008 12:56:38 pm

Thanks for your thoughts Bjorn. The database is actually fine, and works well for the admin siteaccess - the problem is when using the file.ini.append.php in the front-end siteaccess. Unclustering and removing the file.ini.append.php works fine, but doesn't provide the solution I'm after.

eZ Publish is incorrectly using DB connection details from file.ini for ALL DB connections, rather than just for media/content-cache etc. What I want to know is, has anybody else experienced this problem?

Björn Dieding@xrow.de

Monday 13 October 2008 4:59:55 pm

This is odd. The clustering storage engine has nothing to do with the all the other eZ tables. I can`t imagine what side effect could cause this. DB connections are definitly seperate. I havn`t heard about a bug like this in the past.

Please already report for the others your PHP version and eZ version. So far i hope you use latest stable of both.

If you have found the cause on your own let us know about it.

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

Björn Dieding@xrow.de

Monday 13 October 2008 5:06:28 pm

Wait are you saying you have the cluster tables in a different DB as your is ez installed?

If so please put all tables in one db and report back.

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

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 18 2025 10:16:10
Script start
Timing: Jan 18 2025 10:16:10
Module start 'layout'
Timing: Jan 18 2025 10:16:10
Module start 'content'
Timing: Jan 18 2025 10:16:10
Module end 'content'
Timing: Jan 18 2025 10:16:10
Script end

Main resources:

Total runtime0.7893 sec
Peak memory usage4,096.0000 KB
Database Queries63

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0057 588.3672152.6563
Module start 'layout' 0.00570.0033 741.023439.4922
Module start 'content' 0.00900.7789 780.5156569.2188
Module end 'content' 0.78790.0013 1,349.734416.0938
Script end 0.7892  1,365.8281 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00340.4284160.0002
Check MTime0.00140.1717160.0001
Mysql Total
Database connection0.00110.138210.0011
Mysqli_queries0.723091.6018630.0115
Looping result0.00070.0843610.0000
Template Total0.749394.920.3746
Template load0.00250.311520.0012
Template processing0.746894.622020.3734
Template load and register function0.00010.013310.0001
states
state_id_array0.00230.286310.0023
state_identifier_array0.00140.176820.0007
Override
Cache load0.00220.2789320.0001
Sytem overhead
Fetch class attribute can translate value0.00100.125020.0005
Fetch class attribute name0.00090.119970.0001
XML
Image XML parsing0.00110.138220.0005
class_abstraction
Instantiating content class attribute0.00000.0035100.0000
General
dbfile0.00200.2571220.0001
String conversion0.00000.001440.0000
Note: percentages do not add up to 100% because some accumulators overlap

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
5content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
5content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
7content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 21
 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs