Forums / Setup & design / EzSelection.options id jumping 0 to 2, skipping 1, bug ???

EzSelection.options id jumping 0 to 2, skipping 1, bug ???

Author Message

Tore Skobba

Friday 06 February 2004 8:21:22 am

Hi all

I am making overall statistics on my users, the statistics are grouped by various status in several EZSelection data types each user has. For instance total number of articles posted grouped by sex. My algorithm for doing this is basically.

Fetch the attribute (EZSelection)
Fetch the attribute options

Section loop for each attribute.option
Fetch tree_count for each option set for the users
Calcualte and print statistics
End section

This is working fine, except that there seems to be an HOLE between 0 and 2 in the users selections, 1 is always missing in the user attributes. Example: an EZSelection with options: Class of, options: 1999,2000,2001. Then attribute options are (fetched from the class):
0 -> 1999
1 -> 2000
2 -> 2001

HOWEVER, EZ selection in the users has!
0 -> 1999
2 -> 2000
3 -> 2001

Is this a bug or is it me

Cheers
Tore

UPDATE:

Searching the database "ezcontentclass_attribute.data_text5" I find:
<?xml version="1.0" encoding="UTF-8"?>
<ezselection>
<options>
<option id="0"
name="Male" />
<option id="2"
name="Female" />
</options>
</ezselection>

The jump from 0 to 2 is consistent in all EZSelections, Could someone please tell me if this is a bug or if it is there for a reason. Am I doing my statistics wrongly ?

Cheers
Tore

Bård Farstad

Friday 06 February 2004 10:22:13 am

Hi Tore,

this was a known bug in eZ publish 3.2. I belive it was fixed for 3.3. If you see this with 3.3 please file a bugreport and we wil fix it.

-bård

Documentation: http://ez.no/doc

eZ debug

Timing: Jan 19 2025 06:09:45
Script start
Timing: Jan 19 2025 06:09:45
Module start 'content'
Timing: Jan 19 2025 06:09:45
Module end 'content'
Timing: Jan 19 2025 06:09:45
Script end

Main resources:

Total runtime0.1631 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0061 589.1953180.8125
Module start 'content' 0.00610.0065 770.007893.9766
Module end 'content' 0.01260.1504 863.9844525.4219
Script end 0.1630  1,389.4063 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00362.2171200.0002
Check MTime0.00140.8796200.0001
Mysql Total
Database connection0.00080.499910.0008
Mysqli_queries0.117271.86391410.0008
Looping result0.00150.89881390.0000
Template Total0.149891.910.1498
Template load0.00100.643310.0010
Template processing0.148891.248010.1488
Override
Cache load0.00080.466710.0008
Sytem overhead
Fetch class attribute can translate value0.00080.466710.0008
XML
Image XML parsing0.00020.145910.0002
General
dbfile0.00452.7630200.0002
String conversion0.00000.003730.0000
Note: percentages do not add up to 100% because some accumulators overlap

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

CacheTypePacklevelSourceFiles
CSS0extension/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
JS0extension/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:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs