Closed (fixed)
Project:
Date
Version:
5.x-2.0-rc2
Component:
Code
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
11 Jul 2008 at 19:14 UTC
Updated:
31 Jul 2008 at 04:47 UTC
continue from http://drupal.org/node/277420#comment-917980
(after update to date rc2, sorting in views by date is wrong)
I am using Drupal 5.8, php version: 5.2.3-1ubuntu6.3, mysql: 5.0.45,
export of my CCK date node is:
$content[type] = array (
'name' => 'Akcia - Naša vzájomná akcia',
'type' => 'komunitna_akcia',
'description' => 'komunitna akcia',
'title_label' => 'Nadpis',
'body_label' => 'Text',
'min_word_count' => '0',
'help' => '<div class="important"><strong>Pozor: Akcie prešli od 20. 3 zásadnými zmenami k lepšiemu.</strong><br /><br />Rozdelili sa na dva typy (naše vzájomné akcie a všeobecné akcie) a odteraz sa zobrazujú krásne prehľadne podľa dátumu konania v <a href="http://www.somvprahe.sk/kalendar/akcie/komunitne">kalendári</a>, na <a href="http://www.somvprahe.sk/timeline/akcie/komunitne">časovej osi</a> a v <a href="http://www.somvprahe.sk/akcie/komunitne/zoznam-najblizsie">zozname</a>. Preto musí mať odteraz každá akcia pevný začiatok a povinne aspoň približný koniec.<br /><br />Akcia je teda konkrétna udalosť v nejakom termíne. Pokiaľ chceš zverejniť napr., že hľadáš niekoho na leto kto hrá volejbal, atď., tak to nepíš sem, ale do diskusného fóra - kategória "hľadám niekoho".</div><br />
Naša vzájomná akcia je akcia ktorú práve pridávaš, je akcia ktorú organizuješ <strong>TY</strong>, napr. ide sa piť, ide sa do kina, divadla, na koncert, na výlet, na bicykel, na lodičky na Vltavu, prejsť do Stromovky, zahrať si futbal, volejbal, badminton, hádzať tanier...
<br />
Ak chceš pridať inú akciu (len informovať ostatných, že sa niečo koná, napr. informácia o koncerte, festivale) tak pridaj <a href="http://www.somvprahe.sk/node/add/vseobecna-akcia">všeobecnú akciu</a>.
<br /><br />
Naša vzájomná akcia sa zobrazuje v kalendári našich vzájomných akcií, na časovej osi s blížiacimi sa naimi vzájomnými akciami, a v zozname blížiacich sa naich vzájomných akcií.
<br />
<br />',
'node_options' =>
array (
'status' => true,
'promote' => true,
'sticky' => false,
'revision' => false,
),
'nodefamily_max' => '0',
'nodeprofile' => 0,
'comment' => '2',
'upload' => '1',
'excerpt' => '1',
'excerpt_wt' => '1',
'og_content_type_usage' => 'group_post_standard_mail',
'phpfreechat_nodeapi' => 'never',
'phpfreechat_nodeapi_custom' => 0,
'phpfreechat_nodeapi_title' => '',
'phpfreechat_nodeapi_channels' => '',
'privatemsg_link' =>
array (
'node' => true,
'teaser' => true,
'comment' => true,
),
'signup_node_default_state' => 'enabled_on',
'signup_form_date' => '',
'old_type' => 'komunitna_akcia',
'orig_type' => '',
'module' => 'node',
'custom' => '1',
'modified' => '1',
'locked' => '0',
'old_og_content_type_usage' => 'group_post_standard_mail',
'send_type' => 'komunitna_akcia',
'send_komunitna_akcia_fulltext' => '',
'send_komunitna_akcia_linktext' => 'Pošli kamarátom',
'send_komunitna_akcia_subject' => 'Personálna agentúra na SomvPrahe.sk',
'send_komunitna_akcia_message' => '',
'send_komunitna_akcia_template' => '%message
%body
',
'send_komunitna_akcia' => 1,
'send_komunitna_akcia_pernode' => '',
'ant' => 0,
'ant_pattern' => '',
'ant_php' => 0,
'feedapi' =>
array (
'enabled' => '',
'refresh_on_create' => 0,
'update_existing' => 1,
'skip' => 0,
'items_delete' => 0,
'parsers' =>
array (
'parser_common_syndication' =>
array (
'enabled' => true,
'weight' => 0,
),
),
'processors' =>
array (
'feedapi_node' =>
array (
'enabled' => '',
'weight' => 0,
'content_type' => 'story',
'node_date' => 'feed',
'promote' => 3,
'x_dedupe' => 0,
),
'feedapi_aggregator' =>
array (
'enabled' => '',
'weight' => 0,
'block' => 3,
'categories' =>
array (
1 => false,
2 => false,
),
),
),
),
'formtweaker' =>
array (
'taxonomy' =>
array (
'style' => 'select',
28 =>
array (
'style' => 'default',
),
),
),
);
$content[fields] = array (
0 =>
array (
'widget_type' => 'date_select',
'label' => 'Dátum akcie',
'weight' => '-2',
'default_value' => 'now',
'default_value_code' => '',
'default_value2' => 'now',
'default_value_code2' => '',
'input_format' => 'j M Y - H:i:s',
'input_format_custom' => '',
'year_range' => '-0:+1',
'increment' => '5',
'advanced' =>
array (
'label_position' => 'none',
'text_parts' =>
array (
'year' => 0,
'month' => 0,
'day' => 0,
'hour' => 0,
'minute' => 0,
'second' => 0,
),
),
'description' => '',
'group' => false,
'required' => '1',
'multiple' => '0',
'repeat' => 0,
'todate' => 'optional',
'granularity' =>
array (
'year' => 'year',
'month' => 'month',
'day' => 'day',
'hour' => 'hour',
'minute' => 'minute',
'second' => 0,
),
'output_format_date' => 'j. F Y - G:i',
'output_format_custom' => '',
'output_format_date_long' => 'l, j F, Y - H:i',
'output_format_custom_long' => '',
'output_format_date_medium' => 'j F, Y - H:i',
'output_format_custom_medium' => '',
'output_format_date_short' => 'd/m/Y - H:i',
'output_format_custom_short' => '',
'tz_handling' => 'none',
'timezone_db' => 'UTC',
'field_name' => 'field_odkedy',
'field_type' => 'date',
'module' => 'date',
'label_position' => 'none',
'text_parts' =>
array (
),
),
);
export of my view is:
$view = new stdClass();
$view->name = 'blok_komunitne_akcie_bliziac_dlh';
$view->description = 'BLOK Naše komunitné akcie - Zoznam najbližších akcií DLHSIE';
$view->access = array (
);
$view->view_args_php = '';
$view->page = TRUE;
$view->page_title = 'pokus-zoradene-akcie';
$view->page_header = '';
$view->page_header_format = '3';
$view->page_footer = '';
$view->page_footer_format = '3';
$view->page_empty = '';
$view->page_empty_format = '3';
$view->page_type = 'list';
$view->url = 'pokus-zoradene-akcie';
$view->use_pager = TRUE;
$view->nodes_per_page = '30';
$view->block = TRUE;
$view->block_title = 'Naše vzájomné akcie - najbližšie';
$view->block_header = '';
$view->block_header_format = '3';
$view->block_footer = 'Ukáž všetky: <a href="http://www.somvprahe.sk/akcie/komunitne/zoznam-najblizsie">zoznam</a>, <a href="http://www.somvprahe.sk/kalendar/akcie/komunitne">kalendár</a>, <a href="http://www.somvprahe.sk/timeline/akcie/komunitne">časová os</a>';
$view->block_footer_format = '3';
$view->block_empty = '';
$view->block_empty_format = '3';
$view->block_type = 'list';
$view->nodes_per_block = '6';
$view->block_more = FALSE;
$view->block_use_page_header = FALSE;
$view->block_use_page_footer = FALSE;
$view->block_use_page_empty = FALSE;
$view->sort = array (
array (
'tablename' => 'node_data_field_odkedy',
'field' => 'field_odkedy_value',
'sortorder' => 'ASC',
'options' => '',
),
);
$view->argument = array (
);
$view->field = array (
array (
'tablename' => 'node',
'field' => 'title',
'label' => '',
'handler' => 'views_handler_field_nodelink_with_mark',
'options' => 'link',
),
array (
'tablename' => 'node_data_field_odkedy',
'field' => 'field_odkedy_value',
'label' => '',
'handler' => 'content_views_field_handler_ungroup',
'options' => 'timestamp',
),
);
$view->filter = array (
array (
'tablename' => 'node',
'field' => 'status',
'operator' => '=',
'options' => '',
'value' => '1',
),
array (
'tablename' => 'node',
'field' => 'type',
'operator' => 'OR',
'options' => '',
'value' => array (
0 => 'komunitna_akcia',
),
),
array (
'tablename' => 'node_data_field_odkedy',
'field' => 'field_odkedy_value_default',
'operator' => '>=',
'options' => 'now',
'value' => '',
),
);
$view->exposed_filter = array (
);
$view->requires = array(node_data_field_odkedy, node);
$views[$view->name] = $view;
thanks for your work on date and calendar module
Igorik
http://www.somvprahe.sk
Comments
Comment #1
karens commentedI'm unable to reproduce this in the latest -dev code. Floating is a very simple thing and the date module doesn't even do anything special with its sorts -- it uses the regular sorts created by CCK that works the way all CCK sorts work because date values sort naturally and don't need any special handling.
Try tomorrow's tarball to make sure you have the same code I am working with today and be sure you're using the -dev version, not rc2. If you still have trouble, I need more information, like a copy of the query that's created or a screen shot showing me what the sorting looks ike.
Comment #2
igorik commentedI can confirm that with views - dev version and your latest date module it is fixed.
thanks
Igorik
http://www.somvprahe.sk
Comment #3
igorik commentedComment #4
karens commentedI see a typo in my response above -- I said 'floating' instead of 'sorting', but I guess you figured it out. Thanks!
Comment #5
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.