Forums / Developer / 3.1 to 3.2 ezcontentobject_attribute table

3.1 to 3.2 ezcontentobject_attribute table

Next topic

Author	Message
Michele Franceschi	Friday 19 September 2003 8:23:29 am I update from 3.1 to 3.2 mysql update script add two fields (sort_key_int and sort_key_string) in ezcontentobject_attribute table. I see that ezpublish use this fields to sort in fetch function but in my database sort_key_string is blank in every record. Why? In fact in my installation sort function not work correctly.

Author

Message

Friday 19 September 2003 8:23:29 am

I update from 3.1 to 3.2
mysql update script add two fields (sort_key_int and sort_key_string) in ezcontentobject_attribute table.
I see that ezpublish use this fields to sort in fetch function but in my database sort_key_string is blank in every record.
Why?
In fact in my installation sort function not work correctly.

eZ debug

Timing:

Jan 18 2025 16:28:13

Script start

Timing:

Jan 18 2025 16:28:13

Module start 'content'

Timing:

Jan 18 2025 16:28:13

Module end 'content'

Timing:

Jan 18 2025 16:28:13

Script end

Main resources:

Total runtime

0.1945 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.0073	587.8438	180.8125
Module start 'content'	0.0073	0.0049	768.6563	88.8203
Module end 'content'	0.0122	0.1823	857.4766	518.3750
Script end	0.1945		1,375.8516

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0073

587.8438

180.8125

Module start 'content'

0.0073

0.0049

768.6563

88.8203

Module end 'content'

0.0122

0.1823

857.4766

518.3750

Script end

0.1945

1,375.8516

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0038	1.9345	20	0.0002
Check MTime	0.0014	0.7285	20	0.0001
Mysql Total
Database connection	0.0011	0.5702	1	0.0011
Mysqli_queries	0.1341	68.9371	141	0.0010
Looping result	0.0012	0.6420	139	0.0000
Template Total	0.1819	93.5	1	0.1819
Template load	0.0008	0.4262	1	0.0008
Template processing	0.1811	93.0836	1	0.1811
Override
Cache load	0.0006	0.2858	1	0.0006
Sytem overhead
Fetch class attribute can translate value	0.0012	0.6061	1	0.0012
XML
Image XML parsing	0.0003	0.1522	1	0.0003
General
dbfile	0.0060	3.0666	20	0.0003
String conversion	0.0000	0.0032	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.0038

1.9345

0.0002

Check MTime

0.0014

0.7285

0.0001

Mysql Total

Database connection

0.0011

0.5702

0.0011

Mysqli_queries

0.1341

68.9371

141

0.0010

Looping result

0.0012

0.6420

139

0.0000

Template Total

0.1819

93.5

0.1819

Template load

0.0008

0.4262

0.0008

Template processing

0.1811

93.0836

0.1811

Override

Cache load

0.0006

0.2858

0.0006

Sytem overhead

Fetch class attribute can translate value

0.0012

0.6061

0.0012

XML

Image XML parsing

0.0003

0.1522

0.0003

General

dbfile

0.0060

3.0666

0.0003

String conversion

0.0000

0.0032

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