Can't find log file - where is it ?

Author Message

Z W

Monday 15 March 2010 1:27:58 pm

Hi

I'm getting this error when trying to login as admin.

Where is the log file located ? I can't seem to find it.

I stop/start ezp from windows programs files and I keep getting this error.

Is there a workaround to this ?

Any help is appreciated.

Good day

Fatal error: A database transaction in eZ Publish failed.
The current execution was stopped to prevent further problems.
You should contact the System Administrator of this site with the information on this page.
The current transaction ID is TRANSID-0de6b3517e1889d99c67c3a248304a94 and has been logged.
Please include the transaction ID and the current URL when contacting the system administrator.

Z W

Monday 15 March 2010 2:22:39 pm

Hi

I found the log file under /var/log/error.log

Could someone explain this error and how do I recover from this error ?

Thank you for your help

[ Mar 15 2010 22:10:26 ] [192.168.1.134] eZMySQLDB:
Query error: Table 'bitnami_ezpublish.ezfind_elevate_configuration' doesn't exis
t. Query: DELETE FROM ezfind_elevate_configuration
WHERE contentobject_id='175'
[ Mar 15 2010 22:10:26 ] [192.168.1.134] eZDBInterface::commit TRANSID-68f7f0dac
09142db76763bc5e05ba1e3:
Transaction in progress failed due to DB error, transaction was rollbacked. Tran
saction ID is TRANSID-68f7f0dac09142db76763bc5e05ba1e3.
[ Mar 15 2010 22:18:52 ] [192.168.1.134] eZMySQLDB:
Query error: Table 'bitnami_ezpublish.ezfind_elevate_configuration' doesn't exis
t. Query: DELETE FROM ezfind_elevate_configuration
WHERE contentobject_id='175'
[ Mar 15 2010 22:18:52 ] [192.168.1.134] eZDBInterface::commit TRANSID-20bc0b489
e48b35ffad5d97eefa9942a:
Transaction in progress failed due to DB error, transaction was rollbacked. Tran
saction ID is TRANSID-20bc0b489e48b35ffad5d97eefa9942a.

Z W

Monday 15 March 2010 2:26:25 pm

Hi

Fixed it; uncheck ezfind in setup>extensions.

But why doesn't it work in the first place ?

It would be great to know.

Thanks

Gaetano Giunta

Tuesday 16 March 2010 2:02:57 am

Currently there is no automated mechanism for extensions that need extra tables in the eZP db to add them.

eZfind needs one extra table - you can find the sql used to create it in the extension itself, in the sql folder.

It is most likely going to be fixed in version 4.4 - in 4.3 you will have a first help: going to "upgraed check" -> "db" page in admin interface will suggest to create those missing tables.

Principal Consultant International Business
Member of the Community Project Board

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