Getting deleting orphans from ezcontentobject and ezcontentobject_tree

Next topic

Author	Message
Erik Weinmaster	Monday 29 March 2010 9:34:38 am Hello, I created a different delete function, which purges an object if the main node is selected to be deleted (the subtree is deleted too), otherwise just the tree node is removed. However, before I was able to fully implement this, I notice that there have been orphaned records in ezcontentobject and ezcontentobject_tree. I guess I have one simple question. Can an Object exist without a corresponding record in ezcontentobject_tree? From what I find, I'd say no, because how would you get to this object? But I'd like some confirmation too. Please. Also, here are the two queries I am using to find orphaned records. Type 1: No corresponding tree node SELECT DISTINCT co.id FROM ezcontentobject co LEFT JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id WHERE node_id IS NULL Type 2: No parent node SELECT DISTINCT contentobject_id AS id FROM ezcontentobject_tree WHERE parent_node_id NOT IN (SELECT DISTINCT node_id FROM ezcontentobject_tree) Do these queries look right? Thanks
Robin Muilwijk	Monday 29 March 2010 11:05:40 am Hi, I saw a post about orphans some time ago, so sharing here in case it's worth something for you to compare your own sql scripts: http://share.ez.no/forums/developer/zombie-check-script/%28language%29/eng-GB Regards Robin Board member, eZ Publish Community Project Board - Member of the share.ez.no team - Key values: Openness and Innovation. LinkedIn: http://nl.linkedin.com/in/robinmuilwijk // Twitter: http://twitter.com/i_robin // Skype: robin.muilwijk

Author

Message

Monday 29 March 2010 9:34:38 am

Hello,

I created a different delete function, which purges an object if the main node is selected to be deleted (the subtree is deleted too), otherwise just the tree node is removed. However, before I was able to fully implement this, I notice that there have been orphaned records in ezcontentobject and ezcontentobject_tree.

I guess I have one simple question. Can an Object exist without a corresponding record in ezcontentobject_tree? From what I find, I'd say no, because how would you get to this object? But I'd like some confirmation too. Please.

Also, here are the two queries I am using to find orphaned records.

Type 1: No corresponding tree node

SELECT DISTINCT co.id

FROM ezcontentobject co

LEFT JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id

WHERE node_id IS NULL

Type 2: No parent node

SELECT DISTINCT contentobject_id AS id

FROM ezcontentobject_tree

WHERE parent_node_id NOT IN (SELECT DISTINCT node_id FROM ezcontentobject_tree)

Do these queries look right?

Thanks

Robin Muilwijk

Monday 29 March 2010 11:05:40 am

Hi,

I saw a post about orphans some time ago, so sharing here in case it's worth something for you to compare your own sql scripts: http://share.ez.no/forums/developer/zombie-check-script/%28language%29/eng-GB

Regards Robin

Board member, eZ Publish Community Project Board - Member of the share.ez.no team - Key values: Openness and Innovation.

LinkedIn: http://nl.linkedin.com/in/robinmuilwijk // Twitter: http://twitter.com/i_robin // Skype: robin.muilwijk

eZ debug

Timing:	Jan 30 2025 16:33:38
Script start
Timing:	Jan 30 2025 16:33:38
Module start 'layout'
Timing:	Jan 30 2025 16:33:38
Module start 'content'
Timing:	Jan 30 2025 16:33:38
Module end 'content'
Timing:	Jan 30 2025 16:33:38
Script end

Main resources:

Total runtime	0.0275 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0079	588.6172	151.2734
Module start 'layout'	0.0079	0.0053	739.8906	220.7500
Module start 'content'	0.0131	0.0126	960.6406	997.7578
Module end 'content'	0.0257	0.0018	1,958.3984	29.9922
Script end	0.0275		1,988.3906

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0027	9.7738	14	0.0002
Check MTime	0.0010	3.5571	14	0.0001
Mysql Total
Database connection	0.0014	5.0654	1	0.0014
Mysqli_queries	0.0048	17.2701	3	0.0016
Looping result	0.0000	0.0658	1	0.0000
Template Total	0.0014	5.1	1	0.0014
Template load	0.0011	3.8473	1	0.0011
Template processing	0.0003	1.2466	1	0.0003
Override
Cache load	0.0007	2.3650	1	0.0007
General
dbfile	0.0003	1.0283	8	0.0000
String conversion	0.0000	0.0329	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	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs