'Published' Date value 0, DB update error ?!

Next topic

Author	Message
Selmah Maxim	Wednesday 28 May 2003 2:24:50 am Hi .. After user submiting his data, and admin approve it, the 'published' value in ezcontentobject table in the DB still 0 , just the modified get value !! is this normal ?! i have workflow wich will check the data expiry basd on the publish value from ezcontentobject table, so if the value is 0, then ... ?!?! or should i take the published value from ezcontentobject_version table ?! and for what the status value is there in ezcontentobject_version ? please someone help me ! thx in advance.

Author

Message

Wednesday 28 May 2003 2:24:50 am

Hi ..

After user submiting his data, and admin approve it, the 'published' value in ezcontentobject table in the DB still 0 , just the modified get value !!

is this normal ?!

i have workflow wich will check the data expiry basd on the publish value from ezcontentobject table, so if the value is 0, then ... ?!?!

or should i take the published value from ezcontentobject_version table ?!
and for what the status value is there in ezcontentobject_version ?

please someone help me !

thx in advance.

eZ debug

Timing:	Jan 18 2025 11:41:15
Script start
Timing:	Jan 18 2025 11:41:15
Module start 'layout'
Timing:	Jan 18 2025 11:41:15
Module start 'content'
Timing:	Jan 18 2025 11:41:16
Module end 'content'
Timing:	Jan 18 2025 11:41:16
Script end

Main resources:

Total runtime	0.5717 sec
Peak memory usage	4,096.0000 KB
Database Queries	46

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0067	589.1484	152.6406
Module start 'layout'	0.0067	0.0030	741.7891	39.4609
Module start 'content'	0.0097	0.5606	781.2500	400.1172
Module end 'content'	0.5702	0.0014	1,181.3672	8.1406
Script end	0.5716		1,189.5078

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	0.5261	16	0.0002
Check MTime	0.0012	0.2091	16	0.0001
Mysql Total
Database connection	0.0011	0.1973	1	0.0011
Mysqli_queries	0.5354	93.6609	46	0.0116
Looping result	0.0004	0.0615	44	0.0000
Template Total	0.5369	93.9	2	0.2684
Template load	0.0020	0.3432	2	0.0010
Template processing	0.5349	93.5671	2	0.2674
Template load and register function	0.0001	0.0213	1	0.0001
states
state_id_array	0.0010	0.1830	1	0.0010
state_identifier_array	0.0007	0.1272	2	0.0004
Override
Cache load	0.0016	0.2754	11	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0011	0.1851	1	0.0011
Fetch class attribute name	0.0006	0.1043	1	0.0006
XML
Image XML parsing	0.0001	0.0205	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0007	1	0.0000
General
dbfile	0.0007	0.1154	10	0.0001
String conversion	0.0000	0.0013	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
1	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
2	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 6 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs