Issue while trying to insert data in EZP from XML

Previous topic

Developer

Next topic

Author	Message
Jeremy B.	Monday 05 May 2008 5:10:12 am Hi there, I'm having trouble with a PHP script that used to work for around 6 months. I'm using EZP 3.9.2. This cronjob reads XML file, and puts its content in the database. For injecting content to my new object/updated object, i'm using many lines like : $contentObjectAttributes['title']->setAttribute( 'data_text', $title ); $contentObjectAttributes['title']->store(); It all works correctly, but when i'm trying to publish my new object with : include_once('lib/ezutils/classes/ezoperationhandler.php'); $operationResult = eZOperationHandler::execute('content', 'publish', array( 'object_id' => $object->attribute( 'id' ), 'version' => $object->attribute('current_version' ) ) ); i am having a <i>"Fatal error: A database transaction in eZ publish failed."</i> Does someone had the same problem ? Can someone help me ? Does this error has nothing to do with SQL mode STRICT_TRANS_TABLE ? Many thanks in advance.
Piotrek Karaś	Monday 05 May 2008 11:39:17 am This is just a pure guess, cause I have never touched that part directly, but maybe this would be a hint. This transaction error seems like a common message also for situations, when you try to carry out an operation that would clearly violate database rules, for example reinsert the same value for a primary key or a unique key. Now, looking at your example, this could be happening (knowing that publication should always create a new version)... I would inspect all the operations to see what is happening, and compare that to the db table state... include_once('lib/ezutils/classes/ezoperationhandler.php'); $operationResult = eZOperationHandler::execute('content', 'publish', array( 'object_id' => $object->attribute( 'id' ), 'version' => $object->attribute('current_version' ) ) ); -- Company: mediaSELF Sp. z o.o., http://www.mediaself.pl eZ references: http://ez.no/partners/worldwide_partners/mediaself eZ certified developer: http://ez.no/certification/verify/272585 eZ blog: http://ez.ryba.eu
Jeremy B.	Monday 05 May 2008 3:28:49 pm Thanks for your response Piotrek. In fact, this was a misconfiguration in my site.ini file. Someone turned on "transactions" for SQL queries. The entiere site work well, but the cronjob wasn't. I don't really understand why. I'm done with it now =)

Author

Message

Jeremy B.

Monday 05 May 2008 5:10:12 am

Hi there,

I'm having trouble with a PHP script that used to work for around 6 months.
I'm using EZP 3.9.2.

This cronjob reads XML file, and puts its content in the database.
For injecting content to my new object/updated object, i'm using many lines like :

$contentObjectAttributes['title']->setAttribute( 'data_text', $title );
$contentObjectAttributes['title']->store();

It all works correctly, but when i'm trying to publish my new object with :

include_once('lib/ezutils/classes/ezoperationhandler.php');
$operationResult = eZOperationHandler::execute('content', 'publish', array( 'object_id' => $object->attribute( 'id' ), 'version' => $object->attribute('current_version' ) ) );

i am having a <i>"Fatal error: A database transaction in eZ publish failed."</i>

Does someone had the same problem ? Can someone help me ?
Does this error has nothing to do with SQL mode STRICT_TRANS_TABLE ?

Many thanks in advance.

Piotrek Karaś

Monday 05 May 2008 11:39:17 am

This is just a pure guess, cause I have never touched that part directly, but maybe this would be a hint. This transaction error seems like a common message also for situations, when you try to carry out an operation that would clearly violate database rules, for example reinsert the same value for a primary key or a unique key. Now, looking at your example, this could be happening (knowing that publication should always create a new version)... I would inspect all the operations to see what is happening, and compare that to the db table state...

include_once('lib/ezutils/classes/ezoperationhandler.php');
$operationResult = eZOperationHandler::execute('content', 'publish', array( 'object_id' => $object->attribute( 'id' ), 'version' => $object->attribute('current_version' ) ) );

--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu

Jeremy B.

Monday 05 May 2008 3:28:49 pm

Thanks for your response Piotrek.

In fact, this was a misconfiguration in my site.ini file. Someone turned on "transactions" for SQL queries.

The entiere site work well, but the cronjob wasn't. I don't really understand why.

I'm done with it now =)

eZ debug

Timing:	Jan 18 2025 18:41:00
Script start
Timing:	Jan 18 2025 18:41:00
Module start 'layout'
Timing:	Jan 18 2025 18:41:00
Module start 'content'
Timing:	Jan 18 2025 18:41:01
Module end 'content'
Timing:	Jan 18 2025 18:41:01
Script end

Main resources:

Total runtime	1.1493 sec
Peak memory usage	4,096.0000 KB
Database Queries	57

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0052	588.0469	152.6406
Module start 'layout'	0.0052	0.0030	740.6875	39.4922
Module start 'content'	0.0081	1.1395	780.1797	550.7109
Module end 'content'	1.1477	0.0016	1,330.8906	12.1250
Script end	1.1492		1,343.0156

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0036	0.3106	16	0.0002
Check MTime	0.0013	0.1136	16	0.0001
Mysql Total
Database connection	0.0006	0.0513	1	0.0006
Mysqli_queries	1.0935	95.1486	57	0.0192
Looping result	0.0008	0.0735	55	0.0000
Template Total	1.1097	96.6	2	0.5549
Template load	0.0021	0.1808	2	0.0010
Template processing	1.1076	96.3769	2	0.5538
Template load and register function	0.0001	0.0125	1	0.0001
states
state_id_array	0.0015	0.1264	1	0.0015
state_identifier_array	0.0024	0.2094	2	0.0012
Override
Cache load	0.0017	0.1497	26	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0008	0.0726	2	0.0004
Fetch class attribute name	0.0010	0.0827	5	0.0002
XML
Image XML parsing	0.0027	0.2328	2	0.0013
class_abstraction
Instantiating content class attribute	0.0000	0.0007	6	0.0000
General
dbfile	0.0038	0.3300	23	0.0002
String conversion	0.0000	0.0008	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
3	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
8	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
3	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
3	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 22 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs