It seems that 122818 breaks sorting of grouped fields with an unknown column error:
user warning: Unknown column 'node_data_field_date_field_date_value' in 'order clause' query: SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed, node_data_field_series.field_series_value AS node_data_field_series_field_series_value, node_data_field_segment.field_segment_value AS node_data_field_segment_field_segment_value FROM node node LEFT JOIN content_field_date node_data_field_date ON node.vid = node_data_field_date.vid LEFT JOIN content_field_speaker node_data_field_speaker ON node.vid = node_data_field_speaker.vid LEFT JOIN content_type_service node_data_field_series ON node.vid = node_data_field_series.vid LEFT JOIN content_type_service node_data_field_segment ON node.vid = node_data_field_segment.vid WHERE (node.type IN ('service')) AND (node.status = '1') GROUP BY node.nid ORDER BY node_data_field_date_field_date_value DESC LIMIT 0, 25 in /usr/local/www/drupal-5/includes/database.mysql.inc on line 172.
In this case, the field is a date field with multiple values. Changing 'queryname' back to 'fullname' on line 1287 of views.module works (the column gets sorted by the first date), but I'm not sure what that "re-breaks."
Comments
Comment #1
merlinofchaos commentedChanging queryname to fullname is definitely wrong.
I'm not sure you should even be able to sort on multiple fields, since they have an odd relationship to the node, but that's a question for how CCK set it up. Thus I ship this to CCK.
Comment #2
karens commentedYou can't sort on multiple fields if they're grouped.