Download & Extend

SQL error if date field set to multiple values

Project:Views Date Range Filter
Version:5.x-1.5
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active

Issue Summary

Hi.

I'm filtering a view making use of the daterange.module. The filter is defined as:
Custom date range: between 'today' and 'today+100'

I've tried to change the filtered date field to have multiple values, but then I get the following error instead of having the right view:

  • user warning: 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 'inside 'a:2:yth_s:5:\"date1\";s:5:\"today\";s:5:\"date2\";s:9:\"today+100\";')' at line 1
    query: SELECT count(node.nid) FROM yth_node node LEFT JOIN yth_term_node term_node ON node.nid = term_node.nid LEFT JOIN yth_term_data term_data ON term_node.tid = term_data.tid LEFT JOIN yth_content_field_fecha node_data_field_fecha ON node.vid = node_data_field_fecha.vid LEFT JOIN yth_content_type_eventos node_data_field_lugar ON node.vid = node_data_field_lugar.vid WHERE (node.type IN ('eventos')) AND (.field_fecha inside 'a:2:yth_s:5:\"date1\";s:5:\"today\";s:5:\"date2\";s:9:\"today+100\";') in E:\webroot\yth3\includes\database.mysql.inc on line 172.
  • user warning: 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 'inside 'a:2:yth_s:5:\"date1\";s:5:\"today\";s:5:\"date2\";s:9:\"today+100\";') ' at line 1
    query: SELECT node.nid, term_data.weight AS term_data_weight, term_data.name AS term_data_name, node_data_field_fecha.field_fecha_value AS node_data_field_fecha_field_fecha_value, node.title AS node_title, node.changed AS node_changed, node_data_field_lugar.field_lugar_nid AS node_data_field_lugar_field_lugar_nid FROM yth_node node LEFT JOIN yth_term_node term_node ON node.nid = term_node.nid LEFT JOIN yth_term_data term_data ON term_node.tid = term_data.tid LEFT JOIN yth_content_field_fecha node_data_field_fecha ON node.vid = node_data_field_fecha.vid LEFT JOIN yth_content_type_eventos node_data_field_lugar ON node.vid = node_data_field_lugar.vid WHERE (node.type IN ('eventos')) AND (.field_fecha inside 'a:2:yth_s:5:\"date1\";s:5:\"today\";s:5:\"date2\";s:9:\"today+100\";') ORDER BY term_data_weight ASC, term_data_name ASC, node_data_field_fecha_field_fecha_value ASC LIMIT 0, 100 in E:\webroot\yth3\includes\database.mysql.inc on line 172.