warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type double precision: "Jun" in /usr/local/www/www.lunatech-research.com/htdocs/includes/database.pgsql.inc on line 139.
user warning:
query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
TO_CHAR((node.created::ABSTIME + INTERVAL '3600 SECONDS'), 'YYYYMMDDHH24') AS node_created_hour
FROM (SELECT DISTINCT ON (nid) * 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'))) AND ( (node.type in ('story')) AND (node.status <> 0) AND (EXTRACT(YEAR FROM((node.created::ABSTIME + INTERVAL '3600 SECONDS'))) = '2005') AND (EXTRACT(MONTH FROM((node.created::ABSTIME + INTERVAL '3600 SECONDS'))) = 'Jun')
)ORDER BY node_created_hour DESC
) count_alias in /usr/local/www/www.lunatech-research.com/htdocs/sites/default/modules/views/includes/view.inc on line 729.
warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type double precision: "Jun" in /usr/local/www/www.lunatech-research.com/htdocs/includes/database.pgsql.inc on line 139.
user warning:
query: SELECT DISTINCT(node.nid) AS nid,
TO_CHAR((node.created::ABSTIME + INTERVAL '3600 SECONDS'), 'YYYYMMDDHH24') AS node_created_hour
FROM (SELECT DISTINCT ON (nid) * 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'))) AND ( (node.type in ('story')) AND (node.status <> 0) AND (EXTRACT(YEAR FROM((node.created::ABSTIME + INTERVAL '3600 SECONDS'))) = '2005') AND (EXTRACT(MONTH FROM((node.created::ABSTIME + INTERVAL '3600 SECONDS'))) = 'Jun')
)ORDER BY node_created_hour DESC
LIMIT 10 OFFSET 0 in /usr/local/www/www.lunatech-research.com/htdocs/sites/default/modules/views/includes/view.inc on line 755.
