SQL error if date field set to multiple values
hip - January 6, 2008 - 16:33
| Project: | Views Date Range Filter |
| Version: | 5.x-1.5 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Description
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.
