Scripts to validate object relations

«

Previous topic

|

|

Next topic

»

Author	Message
David Boman	Friday 24 February 2006 1:39:54 am Hi, Browsing my logs I have found error messages related to missing objects (null-values). Tracking it a little bit further I relalised that I had forum posting that had no (or perhaps falty) user object associated with the 'modifier'-field. I have not further inestigated the root cause for this, but it leads me to question of object relation consistency. I wonder if there exists any script to check the consistency of relations between objects in database? Tnx, /Boman
David Boman	Tuesday 28 February 2006 11:05:40 am Anyone? If such a script exists or not should be a rather easy question for someone in the eZCrew...
Sergiy Pushchin	Thursday 02 March 2006 8:19:21 am We do not have it for now, but we are planning to add consistancy check in the future, the first step will be to add correct foreign key definition to all persistant objects, check out the spec: http://ez.no/community/developer/specs/foreign_key_definition_in_ezpersistenceobject
David Boman	Wednesday 22 March 2006 5:59:23 am Looks promising! I'll have to write togheter something myself to solve the problem then! Thanx!

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing:	Jan 30 2025 21:44:18
Script start
Timing:	Jan 30 2025 21:44:18
Module start 'layout'
Timing:	Jan 30 2025 21:44:18
Module start 'content'
Timing:	Jan 30 2025 21:44:18
Module end 'content'
Timing:	Jan 30 2025 21:44:18
Script end

Main resources:

Total runtime	0.0234 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.0059	588.1328	151.2109
Module start 'layout'	0.0059	0.0042	739.3438	220.7031
Module start 'content'	0.0102	0.0117	960.0469	997.7734
Module end 'content'	0.0218	0.0015	1,957.8203	33.9922
Script end	0.0233		1,991.8125

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0027	11.7087	14	0.0002
Check MTime	0.0011	4.7504	14	0.0001
Mysql Total
Database connection	0.0011	4.8963	1	0.0011
Mysqli_queries	0.0028	11.9851	3	0.0009
Looping result	0.0000	0.0643	1	0.0000
Template Total	0.0010	4.4	1	0.0010
Template load	0.0008	3.3893	1	0.0008
Template processing	0.0002	0.9509	1	0.0002
Override
Cache load	0.0006	2.4140	1	0.0006
General
dbfile	0.0003	1.2937	8	0.0000
String conversion	0.0000	0.0429	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