Hi everyone, I was wondering if I could get some help resolving a problem with the station module. When I click the "Programs" link in the navigation, I get the following error:
"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 'EXISTS (SELECT * FROM station_schedule WHERE station_schedule.p query: SELECT count(node.nid) FROM node node LEFT JOIN station_program station_program ON node.vid = station_program.vid WHERE (node.type IN ('program')) AND (node.status = '1') AND (EXISTS (SELECT * FROM station_schedule WHERE station_schedule.program_nid = node.nid)) in /home/froginab/domains/froginabox.frih.net/public_html/wony/includes/database.mysql.inc on line 172."
I'm running Drupal 5.3, and the GZip of the station module is labeled 5.x-1.2. On the server, I'm running MySQL version 4.0.23 (and phpMyAdmin v2.10.0 if that makes a difference).
Any suggestions on how to fix this would be appreciated, this is my first attempt at using the station module and I really like it so far!

Comments
update views?
make sure you're running the latest version of the views module.
I am
I'm running 5.x-1.6 of Views.
Operations Manager and general tech guy
WONY, 90.9FM Oneonta
Operations Manager and general tech guy
WONY, 90.9FM Oneonta
use the new 1.3
the bug you ran into was #167632. grab the new 1.3 release which has the fix.
-dev?
can you try out the 1.x-dev version of the station module? if that works, post a follow up so i know that it fixes a bug and i'll release a 1.3.
Just installed the 1.3
Just installed the 1.3 version, I get the same error.
Do you still want me to install the -dev version or try something else?
(note - I am getting this while logged in as Admin and while not logged in)
Thanks,
Rick
Operations Manager and general tech guy
WONY, 90.9FM Oneonta
Operations Manager and general tech guy
WONY, 90.9FM Oneonta
dev and 1.3 are the same
dev and 1.3 are the same version at this point. can you try clearing the views cache (admin/build/views/tools)? if that doesn't work can you either post a link to the site or send it to me via private message?
No dice
Cleared the views cache and it gives me a different error.
Message sent, thanks!
Operations Manager and general tech guy
WONY, 90.9FM Oneonta
Operations Manager and general tech guy
WONY, 90.9FM Oneonta
it's a bug
hey, the best place for support issues like this is the station module's issue queue. i'll re-open #167632 and post a patch there.
Thanks
I'll head over to the link and watch for the patch. Thanks!!
Rick
Operations Manager and general tech guy
WONY, 90.9FM Oneonta
Operations Manager and general tech guy
WONY, 90.9FM Oneonta