Home

Drupal date handling has critical issues with page arguments

Wed, 2011-05-25 20:28 — dgtlmoon

So there seems to be some serious issues handling dates from your content types with views+cck+date module.

http://drupal.org/node/580178

if you have a page argument like "year/%" for example -> "year/2010" then you should really consider if date module has resolved these issues.

however, if you store the year as an integer, there is no problem, and it's only when dealing with the date module

What's more annoying is that the views preview button does not reflect any errors in the query, a nice little time waster till you figure out theres something low level going on.

a:4:{s:6:"%error";s:12:"user warning";s:8:"%message";s:724:"Unknown column 'node_data_field_year.field_year_value' in 'where clause'
query: SELECT node.nid AS nid,
   node.type AS node_type,
   node.vid AS node_vid,
   node.title AS node_title,
   DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 36000 SECOND), '%Y%m%d') AS node_created_day
FROM node node
WHERE ((node.status <> 0) AND (node.type in ('tshirt')))
    AND ((DATE_FORMAT(STR_TO_DATE(node_data_field_year.field_year_value, '%Y-%m-%dT%T'), '%Y') <= '2009' AND DATE_FORMAT(STR_TO_DATE(node_data_field_year.field_year_value, '%Y-%m-%dT%T'), '%Y') >= '2009'))
   ORDER BY node_created_day DESC
LIMIT 0, 32";s:5:"%file";s:63:"/var/www/tshirtslayer/sites/all/modules/views/includes/view.inc";s:5:"%line";i:771;}

0
Your rating: None