• 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 'DISTINCT(node.nid) AS nid, node.language AS node_language, node_data_field_when.' at line 2 query: SELECT COUNT(*) FROM (SELECT node.title AS node_title, DISTINCT(node.nid) AS nid, node.language AS node_language, node_data_field_when.field_when_value AS node_data_field_when_field_when_value FROM node node LEFT JOIN content_type_event node_data_field_when ON node.vid = node_data_field_when.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner'))) AND ( (node.status = 1) AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_when.field_when_value, '%Y-%m-%dT%T'), SEC_TO_TIME(-18000)), '%Y-%m-%d') > '2012-02-06') )) count_alias in /var/www/drupal-6.20/sites/all/modules/views/plugins/views_plugin_pager.inc on line 141.
  • 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 'DISTINCT(node.nid) AS nid, node.language AS node_language, node_data_field_when.' at line 2 query: SELECT node.title AS node_title, DISTINCT(node.nid) AS nid, node.language AS node_language, node_data_field_when.field_when_value AS node_data_field_when_field_when_value FROM node node LEFT JOIN content_type_event node_data_field_when ON node.vid = node_data_field_when.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner'))) AND ( (node.status = 1) AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_when.field_when_value, '%Y-%m-%dT%T'), SEC_TO_TIME(-18000)), '%Y-%m-%d') > '2012-02-06') )ORDER BY node_data_field_when_field_when_value ASC LIMIT 0, 10 in /var/www/drupal-6.20/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1150.
  • 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 'DISTINCT(node.nid) AS nid, node.language AS node_language, node.created AS node_' at line 2 query: SELECT COUNT(*) FROM (SELECT node.title AS node_title, DISTINCT(node.nid) AS nid, node.language AS node_language, node.created AS node_created FROM node node INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner'))) AND ( node.type in ('dreams') )) count_alias in /var/www/drupal-6.20/sites/all/modules/views/plugins/views_plugin_pager.inc on line 141.
  • 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 'DISTINCT(node.nid) AS nid, node.language AS node_language, node.created AS node_' at line 2 query: SELECT node.title AS node_title, DISTINCT(node.nid) AS nid, node.language AS node_language, node.created AS node_created FROM node node INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner'))) AND ( node.type in ('dreams') )ORDER BY node_created DESC LIMIT 0, 10 in /var/www/drupal-6.20/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1150.

Fix the weird durations time tracking thing from constantly adding more items

Posted by robbt on Jul 31, 2009

Something is funky with it. I created an issue on Drupal. Just gotta work on it.

Comments

Post new comment

Path: Home