Missing Postgresql support
neomilium - November 6, 2008 - 16:30
| Project: | Station |
| Version: | 5.x-1.5 |
| Component: | Playlists |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | won't fix |
Jump to:
Description
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 !
#1
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.
#2
i'm going to won't fix this due to lack of feedback. in the d6 version the schema should work for pgsql.