Forums / Install & configuration / Siteaccess trying to access contentobjects via cluster db

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/

eZ debug

Timing: Jan 18 2025 02:57:17
Script start
Timing: Jan 18 2025 02:57:17
Module start 'content'
Timing: Jan 18 2025 02:57:17
Module end 'content'
Timing: Jan 18 2025 02:57:17
Script end

Main resources:

Total runtime0.0473 sec
Peak memory usage2,048.0000 KB
Database Queries4

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0085 589.4219180.7891
Module start 'content' 0.00850.0167 770.2109102.0078
Module end 'content' 0.02520.0220 872.218878.7031
Script end 0.0472  950.9219 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00285.8971120.0002
Check MTime0.00122.5105120.0001
Mysql Total
Database connection0.00112.305410.0011
Mysqli_queries0.00388.099840.0010
Looping result0.00000.050920.0000
Template Total0.021545.410.0215
Template load0.00071.570410.0007
Template processing0.020843.864810.0208
Override
Cache load0.00051.022710.0005
General
dbfile0.017336.5994100.0017
String conversion0.00000.015130.0000
Note: percentages do not add up to 100% because some accumulators overlap

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.0001 secs