Forums / General / Error when deleting objects

Error when deleting objects

Previous topic

General

Next topic

Author	Message
Ionel GARDAIS	Monday 13 March 2006 8:50:10 am Hi, I got EzP 3.7.2 working as an extranet for our company. Everything's fine except that objects cannot be deleted. Example for a user. A user can register. Admin can modify some values (like user's last name) But when Admin tries to delete a user, I got an error with a TRANSID. EzP has sufficients rights on DB (GRANT ALL on ezp.* to user) Any ideas ? Thanks, 1010
Georg Franz	Monday 13 March 2006 9:12:34 am Hi, probably the db user isn't allowed to create temporary tables. (Thats needed for the deletion process.) Best wishes, Georg. -- http://www.schicksal.com Horoskop website which uses eZ Publish since 2004

Author

Message

Ionel GARDAIS

Monday 13 March 2006 8:50:10 am

Hi,

I got EzP 3.7.2 working as an extranet for our company.
Everything's fine except that objects cannot be deleted.

Example for a user.
A user can register.
Admin can modify some values (like user's last name)

But when Admin tries to delete a user, I got an error with a TRANSID.

EzP has sufficients rights on DB (GRANT ALL on ezp.* to user)

Any ideas ?

Thanks,
1010

Georg Franz

Monday 13 March 2006 9:12:34 am

Hi,

probably the db user isn't allowed to create temporary tables. (Thats needed for the deletion process.)

Best wishes,
Georg.

--
http://www.schicksal.com Horoskop website which uses eZ Publish since 2004

eZ debug

Timing:

Jan 20 2025 02:33:04

Script start

Timing:

Jan 20 2025 02:33:04

Module start 'content'

Timing:

Jan 20 2025 02:33:04

Module end 'content'

Timing:

Jan 20 2025 02:33:04

Script end

Main resources:

Total runtime

0.1872 sec

Peak memory usage

2,048.0000 KB

Database Queries

141

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0061	588.9453	180.8438
Module start 'content'	0.0061	0.0057	769.7891	93.8359
Module end 'content'	0.0118	0.1753	863.6250	522.5234
Script end	0.1871		1,386.1484

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0061

588.9453

180.8438

Module start 'content'

0.0061

0.0057

769.7891

93.8359

Module end 'content'

0.0118

0.1753

863.6250

522.5234

Script end

0.1871

1,386.1484

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0037	1.9504	20	0.0002
Check MTime	0.0016	0.8697	20	0.0001
Mysql Total
Database connection	0.0007	0.3650	1	0.0007
Mysqli_queries	0.1337	71.4542	141	0.0009
Looping result	0.0014	0.7747	139	0.0000
Template Total	0.1748	93.4	1	0.1748
Template load	0.0009	0.5007	1	0.0009
Template processing	0.1739	92.9053	1	0.1739
Override
Cache load	0.0007	0.3484	1	0.0007
Sytem overhead
Fetch class attribute can translate value	0.0009	0.4803	1	0.0009
XML
Image XML parsing	0.0003	0.1358	1	0.0003
General
dbfile	0.0078	4.1707	20	0.0004
String conversion	0.0000	0.0024	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.0037

1.9504

0.0002

Check MTime

0.0016

0.8697

0.0001

Mysql Total

Database connection

0.0007

0.3650

0.0007

Mysqli_queries

0.1337

71.4542

141

0.0009

Looping result

0.0014

0.7747

139

0.0000

Template Total

0.1748

93.4

0.1748

Template load

0.0009

0.5007

0.0009

Template processing

0.1739

92.9053

0.1739

Override

Cache load

0.0007

0.3484

0.0007

Sytem overhead

Fetch class attribute can translate value

0.0009

0.4803

0.0009

XML

Image XML parsing

0.0003

0.1358

0.0003

General

dbfile

0.0078

4.1707

0.0004

String conversion

0.0000

0.0024

0.0000

Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

Cache	Type	Packlevel	SourceFiles
	CSS	0	extension/community/design/community/stylesheets/ext/jquery.autocomplete.css extension/community_design/design/suncana/stylesheets/scrollbars.css extension/community_design/design/suncana/stylesheets/tabs.css extension/community_design/design/suncana/stylesheets/roadmap.css extension/community_design/design/suncana/stylesheets/content.css extension/community_design/design/suncana/stylesheets/star-rating.css extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css extension/community_design/design/suncana/stylesheets/buttons.css extension/community_design/design/suncana/stylesheets/tweetbox.css extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css extension/sevenx/design/simple/stylesheets/star_rating.css extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css extension/sevenx/design/simple/stylesheets/main.v02.css extension/sevenx/design/simple/stylesheets/main.v02.res.css
	JS	0	extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js extension/community_design/design/suncana/javascript/jquery.ui.core.min.js extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js extension/community_design/design/suncana/javascript/jquery.easing.1.3.js extension/community_design/design/suncana/javascript/jquery.ui.tabs.js extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js extension/community_design/design/suncana/javascript/jquery.popmenu.js extension/community_design/design/suncana/javascript/jScrollPane.js extension/community_design/design/suncana/javascript/jquery.mousewheel.js extension/community_design/design/suncana/javascript/jquery.cycle.all.js extension/sevenx/design/simple/javascript/jquery.scrollTo.js extension/community_design/design/suncana/javascript/jquery.cookie.js extension/community_design/design/suncana/javascript/ezstarrating_jquery.js extension/community_design/design/suncana/javascript/jquery.initboxes.js extension/community_design/design/suncana/javascript/app.js extension/community_design/design/suncana/javascript/twitterwidget.js extension/community_design/design/suncana/javascript/community.js extension/community_design/design/suncana/javascript/roadmap.js extension/community_design/design/suncana/javascript/ez.js extension/community_design/design/suncana/javascript/ezshareevents.js extension/sevenx/design/simple/javascript/main.js

Cache

Type

Packlevel

SourceFiles

CSS

extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css

extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

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.0002 secs