- 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 '(node.title, 1, 1) AS title_truncated, COUNT(node.nid) AS nu query: SELECT SUBSTR(node.title, 1, 1) AS title_truncated, COUNT(node.nid) AS num_records FROM dr_node node INNER JOIN dr_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'))) GROUP BY title_truncated ORDER BY title_truncated ASC LIMIT 0, 36 in /web/htdocs/www.agescimestre.it/home/sites/all/modules/views/includes/view.inc on line 765.
- 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 '(node.title, 1, 1) = 'a' )ORDER BY node_title ASC LIMIT 0, query: SELECT node.nid AS nid, node.title AS node_title, users.name AS users_name, users.uid AS users_uid, node.changed AS node_changed FROM dr_node node INNER JOIN dr_users users ON node.uid = users.uid INNER JOIN dr_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 ( SUBSTR(node.title, 1, 1) = 'a' )ORDER BY node_title ASC LIMIT 0, 36 in /web/htdocs/www.agescimestre.it/home/sites/all/modules/views/includes/view.inc on line 765.
