Error on deleting article

Next topic

Author	Message
M Tonissen	Wednesday 09 August 2006 8:03:02 am Whenever I try to delete an article in admin screen I get these errors: 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-3bd0af6bebb8b3a6d5cef1cc4ba13c4c and has been logged. Please include the transaction ID and the current URL when contacting the system administrator. What does this mean and where can I find that log??
M Tonissen	Friday 11 August 2006 4:40:10 am No one can help me with this one???
Matt Brady	Tuesday 15 August 2006 7:06:27 pm I'm having the same problem... however, reading through the forums I found this: The MySQL user needs the CREATE_TMP_TABLE permission. It's not easy being easy.
Marko Žmak	Tuesday 15 August 2006 10:53:12 pm This means that the deletion of the article didn't succeed entriely. But you should provide more details about your problem. What version of eZ, PHP, Apache, MySql are you using? Does the problem happen only when you try deleting an article or it happens with other classes as well? Does the problem happen EVERY time you try to delete an article? Does the same problem happen when you try creating or changing an article? -- Nothing is impossible. Not if you can imagine it! Hubert Farnsworth
M Tonissen	Tuesday 15 August 2006 11:35:14 pm EZ version 3.8 php version 4.4.3 mysql version 4.0.22 webserver version ???? Deleting classes is no problem, the problem concerns only deleting articles, and happens allways. Creating or editing an article isn't a problem and can be done.
Matt Brady	Thursday 17 August 2006 4:24:33 pm I'm still experiencing the same problem after getting the grant set up to allow create_tmp_tables I cannot delete any article, folder, forum etc etc regardless on wheter I created them or not. Specs are as follows: ez version 3.8.3 php version 4.4.2 mysql version 4.1.2 No No No... I tell lies.... the grant wasn't set up properly... that definately fixed the problem :) It's not easy being easy.

eZ debug

Timing:	Jan 18 2025 14:51:31
Script start
Timing:	Jan 18 2025 14:51:31
Module start 'layout'
Timing:	Jan 18 2025 14:51:31
Module start 'content'
Timing:	Jan 18 2025 14:51:32
Module end 'content'
Timing:	Jan 18 2025 14:51:32
Script end

Main resources:

Total runtime	0.6092 sec
Peak memory usage	4,096.0000 KB
Database Queries	68

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0051	589.0391	152.6250
Module start 'layout'	0.0051	0.0028	741.6641	39.4453
Module start 'content'	0.0079	0.6001	781.1094	605.2969
Module end 'content'	0.6079	0.0012	1,386.4063	12.1641
Script end	0.6091		1,398.5703

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.5552	16	0.0002
Check MTime	0.0014	0.2276	16	0.0001
Mysql Total
Database connection	0.0008	0.1389	1	0.0008
Mysqli_queries	0.5503	90.3446	68	0.0081
Looping result	0.0010	0.1686	66	0.0000
Template Total	0.5792	95.1	2	0.2896
Template load	0.0022	0.3607	2	0.0011
Template processing	0.5770	94.7217	2	0.2885
Template load and register function	0.0002	0.0277	1	0.0002
states
state_id_array	0.0010	0.1609	1	0.0010
state_identifier_array	0.0012	0.1970	2	0.0006
Override
Cache load	0.0019	0.3125	37	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0980	3	0.0002
Fetch class attribute name	0.0019	0.3075	7	0.0003
XML
Image XML parsing	0.0007	0.1200	3	0.0002
class_abstraction
Instantiating content class attribute	0.0000	0.0025	7	0.0000
General
dbfile	0.0012	0.1953	18	0.0001
String conversion	0.0000	0.0014	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
6	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
9	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
4	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.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: 6

Time used to render debug report: 0.0001 secs