The ORDER BY problem for table style is not solved with 6.x-2.8
I run the update.php but it's same as before : column header order by is not working; order is still based on default parameter.

Comments

dawehner’s picture

Status: Active » Postponed (maintainer needs more info)

Here it does work, so i suggest you to read #571990: Views issue queue guidelines and provide the informations which are needed.

sahuni’s picture

Website is : http://www.lamurithienne.ch/collection

View export gives :

<? php
$view = new view;
$view->name = 'publiste';
$view->description = 'une ligne par publication';
$view->tag = 'liste des publicationss';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
$handler = $view->new_display('default', 'Paramètres par défaut', 'default');
$handler->override_option('fields', array(
'field_collection_value' => array(
'label' => 'Collection',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'strip_tags' => 0,
'html' => 0,
),
'link_to_node' => 0,
'label_type' => 'widget',
'format' => 'default',
'multiple' => array(
'group' => TRUE,
'multiple_number' => '',
'multiple_from' => '',
'multiple_reversed' => FALSE,
),
'exclude' => 0,
'id' => 'field_collection_value',
'table' => 'node_data_field_collection',
'field' => 'field_collection_value',
'relationship' => 'none',
),
'field_annee_value' => array(
'label' => 'Année ',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'strip_tags' => 0,
'html' => 0,
),
'link_to_node' => 0,
'label_type' => 'widget',
'format' => 'default',
'multiple' => array(
'group' => TRUE,
'multiple_number' => '',
'multiple_from' => '',
'multiple_reversed' => FALSE,
),
'exclude' => 0,
'id' => 'field_annee_value',
'table' => 'node_data_field_annee',
'field' => 'field_annee_value',
'relationship' => 'none',
),
'title' => array(
'label' => ' Titre',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'strip_tags' => 0,
'html' => 0,
),
'link_to_node' => 1,
'exclude' => 0,
'id' => 'title',
'table' => 'node',
'field' => 'title',
'relationship' => 'none',
'override' => array(
'button' => 'Supplanter',
),
),
'field_auteur_value' => array(
'label' => 'Auteur',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'strip_tags' => 0,
'html' => 0,
),
'link_to_node' => 0,
'label_type' => 'widget',
'format' => 'default',
'multiple' => array(
'group' => TRUE,
'multiple_number' => '',
'multiple_from' => '',
'multiple_reversed' => FALSE,
),
'exclude' => 0,
'id' => 'field_auteur_value',
'table' => 'node_data_field_auteur',
'field' => 'field_auteur_value',
'relationship' => 'none',
),
));
$handler->override_option('sorts', array(
'field_annee_value' => array(
'order' => 'DESC',
'delta' => -1,
'id' => 'field_annee_value',
'table' => 'node_data_field_annee',
'field' => 'field_annee_value',
'override' => array(
'button' => 'Supplanter',
),
'relationship' => 'none',
),
));
$handler->override_option('filters', array(
'status' => array(
'operator' => '=',
'value' => '1',
'group' => '0',
'exposed' => FALSE,
'expose' => array(
'operator' => FALSE,
'label' => '',
),
'id' => 'status',
'table' => 'node',
'field' => 'status',
'relationship' => 'none',
),
'type' => array(
'operator' => 'in',
'value' => array(
'publication' => 'publication',
),
'group' => '0',
'exposed' => FALSE,
'expose' => array(
'operator' => FALSE,
'label' => '',
),
'id' => 'type',
'table' => 'node',
'field' => 'type',
'relationship' => 'none',
),
'field_collection_value_many_to_one' => array(
'operator' => 'and',
'value' => array(),
'group' => '0',
'exposed' => TRUE,
'expose' => array(
'use_operator' => 0,
'operator' => 'field_collection_value_many_to_one_op',
'identifier' => 'field_collection_value_many_to_one',
'label' => 'Collection : ',
'optional' => 1,
'single' => 1,
'remember' => 0,
'reduce' => 0,
),
'id' => 'field_collection_value_many_to_one',
'table' => 'node_data_field_collection',
'field' => 'field_collection_value_many_to_one',
'relationship' => 'none',
'reduce_duplicates' => 0,
'override' => array(
'button' => 'Supplanter',
),
),
));
$handler->override_option('access', array(
'type' => 'none',
));
$handler->override_option('cache', array(
'type' => 'none',
));
$handler->override_option('header_format', '2');
$handler->override_option('header_empty', 0);
$handler->override_option('use_pager', '1');
$handler->override_option('style_plugin', 'table');
$handler->override_option('style_options', array(
'grouping' => '',
'override' => 0,
'sticky' => 0,
'order' => 'asc',
'columns' => array(
'field_collection_value' => 'field_collection_value',
'field_annee_value' => 'field_annee_value',
'title' => 'title',
'field_auteur_value' => 'field_auteur_value',
),
'info' => array(
'field_collection_value' => array(
'sortable' => 1,
'separator' => '',
),
'field_annee_value' => array(
'sortable' => 1,
'separator' => '',
),
'title' => array(
'sortable' => 1,
'separator' => '',
),
'field_auteur_value' => array(
'sortable' => 1,
'separator' => '',
),
),
'default' => 'title',
));
$handler = $view->new_display('block', 'Bloc', 'block_1');
$handler->override_option('block_description', 'Collections');
$handler->override_option('block_caching', -1);
$handler = $view->new_display('page', 'Page', 'page_1');
$handler->override_option('path', 'collection');
$handler->override_option('menu', array(
'type' => 'normal',
'title' => 'Collections',
'description' => '',
'weight' => '0',
'name' => 'menu-menu-murithienne',
));
$handler->override_option('tab_options', array(
'type' => 'none',
'title' => '',
'description' => '',
'weight' => 0,
));

?>

merlinofchaos’s picture

"The ORDER BY problem"

I guess there was another issue that you're referring to, but you don't link to it. Maybe you assume that whoever reads this will automatically know what you're talking about. AS it happens, I think I do, but that's not going to be true for, oh, anyone else.

This is not an acceptable way to write a bug report. Please think about the audience you're writing for and use a little courtesy. Write complete reports and include all of the information, or at least link to the information.

sahuni’s picture

No I refer to :
http://drupal.org/project/Views , details for release 6.x-2.8 , bug fixes section :
#622602: Missing ORDER BY in some views with tables due to incorrect test for default table sorting.

The view proposed in Website is : http://www.lamurithienne.ch/collection is not working. When clicking on column header, we cannot change the sorting order.
This was working in version 6.x-2.6, incorrect in version 6.x-2.7 and still incorrect in 6.x-2.8

dawehner’s picture

Status: Postponed (maintainer needs more info) » Active

Its only not working for the "Annee" field. which seams to be a cck field.

sahuni’s picture

It's not working for all the 4 columns which are cck Fields. It's a view field.
What do you think?

sahuni’s picture

I solved my problem when I removed a sort criteria that was setteld in general sort criteria section.
When I created first that view, I put there a sort criteria on year. Then later, I created a table view with sortable fields and I never removed the general sort criteria. It was working fine. Since view 6.x-2.7, it was not working.
So I cleaned my view and it's OK now.
All the best

merlinofchaos’s picture

Status: Active » Fixed
razunter’s picture

Status: Fixed » Active

It's not fixed, this is the same bug as http://drupal.org/node/657700

merlinofchaos’s picture

Status: Active » Fixed

#9: The guy who reported the problem reported it fixed. Re-openingit without providing information doesn't do any good for anybody.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.