When building a view with Station Playlist Track as the base table, you get this error:
Unknown column 'station_playlist_track.iid' in 'field list' query: SELECT station_playlist_track.iid AS iid, station_playlist_track.title AS station_playlist_track_title FROM station_playlist_track station_playlist_track LIMIT 0, 10

Looking through station_playlist.views.inc, it looks like station_playlist_track is building off of the wrong field. Should be station_playlist_track.nid, not station_playlist_track.iid.

CommentFileSizeAuthor
#1 station-850392.patch833 bytestim.plunkett

Comments

tim.plunkett’s picture

tim.plunkett
he/him
Primary language English
Location Philadelphia
commented
Status: Needs review » Reviewed & tested by the community
StatusFileSize
new station-850392.patch833 bytes

Here's the quick fix as a patch for anyone not working off of HEAD.

tim.plunkett’s picture

tim.plunkett
he/him
Primary language English
Location Philadelphia
commented
Status: Reviewed & tested by the community » Fixed

Committed to HEAD. I hope not waiting for a review isn't bad form... But it was only one character!

drewish’s picture

drewish commented

As long as it works building views from both ends, it seems sane to me.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.