Hi,

When I try to use Station 1.5 on Drupal 5.12 with postgresql database, I have many errors like that :

# warning: pg_query() [function.pg-query]: Query failed: ERREUR: la relation « station_playlist » n'existe pas in /var/www/drupal-5.12/includes/database.pgsql.inc on line 126.
# user warning: query: SELECT count(node.nid) FROM node node LEFT JOIN station_playlist station_playlist ON node.nid = station_playlist.nid WHERE (node.type IN ('station_playlist')) AND (node.status = '1') AND (station_playlist.timestamp <= 1225988538 + 0) in /var/www/drupal-5.12/includes/database.pgsql.inc on line 145.

All tested features (Catalog, Playlists, Schedule and Programs) have this error : missing relationship. (but not always "station_playlist")

Does it comes from me ? or this module version doesn't work on PostgreSQL database ?

Thanks for your work !

Comments

drewish’s picture

drewish commented

I've not used pgsql so any support was contributed by others. it looks like the station_playlist module is missing pgsql schema creation code. if you'd be willing to translate it for pgsql i'd be happy to commit it.

drewish’s picture

drewish commented
Title: Missing database relations. » Missing Postgresql support
Status: Active » Closed (won't fix)

i'm going to won't fix this due to lack of feedback. in the d6 version the schema should work for pgsql.