I'm not sure whether I should report this to Date module or Views module project. Please feel free to correct me if I reported in the wrong place.

What I'm trying to do is to filter out the nodes to display only Today's nodes and I got this error:

user warning: Unknown column 'now' in 'where clause' query: SELECT node.nid, node.title AS node_title, node.changed AS node_changed, node_data_field_date.field_date_value AS node_data_field_date_field_date_value, node_data_field_date.field_date_value2 AS node_data_field_date_field_date_value2 FROM node node LEFT JOIN content_type_page node_data_field_date ON node.vid = node_data_field_date.vid WHERE (node.type IN ('page')) AND (EXTRACT(MONTH FROM(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'))) = now) AND (EXTRACT(DAY FROM(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'))) = now) AND (EXTRACT(YEAR FROM(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'))) = now) LIMIT 0, 5 in C:\xampp\htdocs\test\includes\database.mysql.inc on line 174.

Please refer to the attachment to see the screen shot.

Thanks in advance.

P.S. I've tried Date-5.x-1 with Views-5.x-1 together and it is working fine.

CommentFileSizeAuthor
date2_view1.gif43.28 KBseakayjay

Comments

esmerel’s picture

Status: Active » Closed (fixed)

given the age of this issue, I'm going to presume it's either figured out or no longer relevant.