Forums / General / Error on deleting article

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 10:23:49

Script start

Timing:

Jan 18 2025 10:23:49

Module start 'content'

Timing:

Jan 18 2025 10:23:49

Module end 'content'

Timing:

Jan 18 2025 10:23:49

Script end

Main resources:

Total runtime

0.0145 sec

Peak memory usage

2,048.0000 KB

Database Queries

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0057	588.8359	180.8438
Module start 'content'	0.0057	0.0049	769.6797	97.8359
Module end 'content'	0.0106	0.0038	867.5156	74.7031
Script end	0.0145		942.2188

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0057

588.8359

180.8438

Module start 'content'

0.0057

0.0049

769.6797

97.8359

Module end 'content'

0.0106

0.0038

867.5156

74.7031

Script end

0.0145

942.2188

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0022	14.9608	12	0.0002
Check MTime	0.0010	6.8905	12	0.0001
Mysql Total
Database connection	0.0008	5.3341	1	0.0008
Mysqli_queries	0.0026	17.6656	4	0.0006
Looping result	0.0000	0.1859	2	0.0000
Template Total	0.0034	23.4	1	0.0034
Template load	0.0008	5.7964	1	0.0008
Template processing	0.0025	17.5702	1	0.0025
Override
Cache load	0.0006	3.8780	1	0.0006
General
dbfile	0.0004	2.4433	10	0.0000
String conversion	0.0000	0.0395	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0022

14.9608

0.0002

Check MTime

0.0010

6.8905

0.0001

Mysql Total

Database connection

0.0008

5.3341

0.0008

Mysqli_queries

0.0026

17.6656

0.0006

Looping result

0.0000

0.1859

0.0000

Template Total

0.0034

23.4

0.0034

Template load

0.0008

5.7964

0.0008

Template processing

0.0025

17.5702

0.0025

Override

Cache load

0.0006

3.8780

0.0006

General

dbfile

0.0004

2.4433

0.0000

String conversion

0.0000

0.0395

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	Edit	Override
1	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Usage

Requested template

Template

Template loaded

Edit

Override

pagelayout.tpl

<No override>

extension/sevenx/design/simple/templates/pagelayout.tpl

Number of times templates used: 1
Number of unique templates used: 1

Time used to render debug report: 0.0001 secs