Blogs

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.

My blog is somewhat private

Posted by robbt on Aug 5, 2009

The entries nonetheless are more random than anything else but I'm experimenting with having a only somewhat open site, where I keep the personal details to myself. If you know me and want to read this then please sign up for an account on here, but otherwise don't worry about it, and just read what you can.