SQL syntax error with "programs" link

Events happening in the community are now at Drupal community events on www.drupal.org.
refreshingapathy-gdo's picture

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?

drewish's picture

make sure you're running the latest version of the views module.

I am

refreshingapathy-gdo's picture

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

drewish's picture

the bug you ran into was #167632. grab the new 1.3 release which has the fix.

-dev?

drewish's picture

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

refreshingapathy-gdo's picture

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

drewish's picture

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

refreshingapathy-gdo's picture

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

drewish's picture

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

refreshingapathy-gdo's picture

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

Radio

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: