Forums / Install & configuration / Can't find log file - where is it ?
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.
Monday 15 March 2010 2:22:39 pm
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. Transaction ID is TRANSID-20bc0b489e48b35ffad5d97eefa9942a.
Monday 15 March 2010 2:26:25 pm
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