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/