I'm getting the following error on a new install. I have ACL and Forum Access installed which may be interfering. I have no programs entered as of yet. http://test.wsum.net/station/programs

  • 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 '' at line 1 query: SELECT count( DISTINCT(node.nid)) FROM node node LEFT JOIN station_program station_program ON node.vid = station_program.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 = 1 AND na.realm = 'forum_access'))) AND ( (node.type IN ('program')) AND (node.status = '1') AND (EXISTS (SELECT * FROM station_schedule 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 = 1 AND na.realm = 'forum_access'))) AND ( station_schedule.program_nid = node.nid)) ) in /mnt/outside/vol/sepia/wsum/drupal5/includes/database.mysql.inc on line 172.
  • 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 'ORDER BY node_title ASC LIMIT 0, 50' at line 1 query: SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed, station_program.genre AS station_program_genre FROM node node LEFT JOIN station_program station_program ON node.vid = station_program.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 = 1 AND na.realm = 'forum_access'))) AND ( (node.type IN ('program')) AND (node.status = '1') AND (EXISTS (SELECT * FROM station_schedule 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 = 1 AND na.realm = 'forum_access'))) AND ( station_schedule.program_nid = node.nid)) ) ORDER BY node_title ASC LIMIT 0, 50 in /mnt/outside/vol/sepia/wsum/drupal5/includes/database.mysql.inc on line 172.

Comments

drewish’s picture

Status: Active » Closed (duplicate)

i think this is the same as: http://drupal.org/node/167632