I am using the new cvs of the date module. I can sort by date fine by clicking on the table header. However, views won't let me have a view that initially sorts by date. It gives an error ... and then though it performs the initial sort, if I click on the table header, I can't re-sort the table asc or desc by date. If I remove the Date field from the initial sort option, things work fine again.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 3' at line 1 query: SELECT node.nid, node.title AS node_title, node.changed AS node_changed, node_data_field_t_composer.field_t_composer_value AS node_data_field_t_composer_field_t_composer_value, node_data_field_t_record_label.field_t_record_label_value AS node_data_field_t_record_label_field_t_record_label_value, node_data_field_date_recorded.field_date_recorded_value AS node_data_field_date_recorded_field_date_recorded_value, node_data_field_date_recorded.field_date_recorded_timezone AS node_data_field_date_recorded_field_date_recorded_timezone FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid LEFT JOIN node_content_recording node_data_field_t_composer ON node.vid = node_data_field_t_composer.vid LEFT JOIN node_content_recording node_data_field_t_record_label ON node.vi in F:\......\includes\database.mysql.inc on line 120

Comments

KarenS’s picture

Project: Views (for Drupal 7) » Date
Version: 6.x-2.x-dev » 7.x-1.x-dev
Status: Active » Fixed

I'm moving this to a date issue since that what it really is. I don't see this problem in latest version. Please re-open if it still seems to be a problem.

Anonymous’s picture

Status: Fixed » Closed (fixed)