SQL error when trying to look at the schedule>programs [#167632]

For some reason, only the Admin account can view the station>program listing. From any other account (even when given admin permissions for the station module) I get the following:

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 = 2 AND na.realm = 'workflow_access') OR (na.gid = 5 AND na.realm = 'workflow_access') OR (na.gid = 7 AND na.realm = 'workflow_access') OR (na.gid = 4 AND na.realm = 'workflow_access_owner'))) AND ( (node.type IN ('station_program')) AND (node.status = '1') AND (EXISTS (SELECT * FROM station_schedule_item 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 = 2 AND na.realm = 'workflow_access') OR (na.gid = 5 AND na.realm = 'workflow in /var/www/html/cpbn/includes/database.mysql.inc on line 172.

I can see that it is referencing workflow in here, so it is possible the problem isn't with the station modules, but this is the only one I've noticed it for.

Comment	File	Size	Author
#8	station_schedule_167632.patch	1.06 KB	drewish
#6	station_167632_0.patch	1.57 KB	drewish
#5	station_167632.patch	1.61 KB	drewish

Comments

Comment #1

drewish commented 15 August 2007 at 21:15

what's the URL that this is coming up on? i think you might be right that it's a problem with workflow...

Comment #2

whyameye commented 30 August 2007 at 01:25

We are having a MYSQL error on schedule -> programs as well. The error only shows up for Anonymous users and looks like this:

* 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 = 0 AND na.realm = 'og_public'))) 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 = 0 AND na.realm = 'og_public'))) AND ( station_schedule.program_nid = node.nid)) ) in /var/www/html/wsuir-drupal5.2/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 = 0 AND na.realm = 'og_public'))) 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 = 0 AND na.realm = 'og_public'))) AND ( station_schedule.program_nid = node.nid)) ) ORDER BY node_title ASC LIMIT 0, 50 in /var/www/html/wsuir-drupal5.2/includes/database.mysql.inc on line 172.

our site is:
http://cratel.wichita.edu/wsuir-drupal5.2/?q=station/programs

underneath it says there are no scheduled programs. I am wondering if kpsu.org is experiencing an error in schedule -> programs as well as their site also says they have no scheduled programs:
http://kpsu.org/station/programs

and I saw a mysql error for KGSM as well:
http://blackbird.kgsm.gac.edu/beta/station/programs