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.

eZ debug

Timing: Jan 18 2025 11:24:29
Script start
Timing: Jan 18 2025 11:24:29
Module start 'layout'
Timing: Jan 18 2025 11:24:29
Module start 'content'
Timing: Jan 18 2025 11:24:30
Module end 'content'
Timing: Jan 18 2025 11:24:30
Script end

Main resources:

Total runtime0.9849 sec
Peak memory usage4,096.0000 KB
Database Queries60

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0071 589.1484152.6406
Module start 'layout' 0.00710.0033 741.789139.4766
Module start 'content' 0.01040.9730 781.2656551.3672
Module end 'content' 0.98340.0015 1,332.632812.1406
Script end 0.9849  1,344.7734 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00350.3543160.0002
Check MTime0.00150.1513160.0001
Mysql Total
Database connection0.00100.104410.0010
Mysqli_queries0.925693.9750600.0154
Looping result0.00090.0864580.0000
Template Total0.951296.620.4756
Template load0.00200.206420.0010
Template processing0.949296.372620.4746
Template load and register function0.00030.028210.0003
states
state_id_array0.00080.086110.0008
state_identifier_array0.00140.137220.0007
Override
Cache load0.00180.1809490.0000
Sytem overhead
Fetch class attribute can translate value0.00090.093320.0005
Fetch class attribute name0.00090.092750.0002
XML
Image XML parsing0.00090.092620.0005
class_abstraction
Instantiating content class attribute0.00000.000950.0000
General
dbfile0.00190.1909160.0001
String conversion0.00000.001040.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
4content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
6content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezxmltags/strong.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/strong.tplEdit templateOverride template
3content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 18
 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs