I opened http://www.mysite.com/drupal/audio, Selected the "Edit" tab, removed "Node: Created Time" from the Sort Criteria, and added "Audio: Tag year", "Audio: Tag album" and "Audio: Tag track" to the Sort Criteria. When I tried to view http://www.mysite.com/drupal/audio again, I got this error message:

user warning: Unknown table 'audio_metadata_year' in field list query: SELECT node.nid, audio_metadata_year.value + 0 AS audio_metadata_year_value, audio_metadata_album.value AS audio_metadata_album_value, audio_metadata_track.value + 0 AS audio_metadata_track_value, node.title AS node_title, node.changed AS node_changed FROM DRUPAL_node node LEFT JOIN DRUPAL_audio audio ON node.vid = audio.vid LEFT JOIN DRUPAL_audio_metadata audio_metadata_album ON audio.vid = audio_metadata_album.vid AND audio_metadata_album.tag = 'album' WHERE (node.type IN ('audio')) AND (node.status = '1') ORDER BY audio_metadata_year_value DESC, audio_metadata_album_value ASC, audio_metadata_track_value ASC LIMIT 0, 25 in /home/ejworshp/public_html/main/includes/database.mysql.inc on line 172.

Comments

kansas-1’s picture

kansas-1 commented

The dbquery should look like this (note the two extra INNER JOINS for audio_metadata_year and audio_metadata_track):

SELECT node.nid,
audio_metadata_year.value + 0 AS audio_metadata_year_value,
audio_metadata_album.value AS audio_metadata_album_value,
audio_metadata_track.value + 0 AS audio_metadata_track_value,
node.title AS node_title,
node.changed AS node_changed
FROM DRUPAL_node node
LEFT JOIN DRUPAL_audio audio ON node.vid = audio.vid
LEFT JOIN DRUPAL_audio_metadata audio_metadata_year ON audio.vid = audio_metadata_year.vid AND audio_metadata_year.tag = 'year'
LEFT JOIN DRUPAL_audio_metadata audio_metadata_album ON audio.vid = audio_metadata_album.vid AND audio_metadata_album.tag = 'album'
LEFT JOIN DRUPAL_audio_metadata audio_metadata_track ON audio.vid = audio_metadata_track.vid AND audio_metadata_track.tag = 'track'
WHERE (node.type IN ('audio'))
AND (node.status = '1')
ORDER BY audio_metadata_year_value DESC,
audio_metadata_album_value ASC,
audio_metadata_track_value ASC
LIMIT 0, 25

sgriffin’s picture

sgriffin commented

How did you solve this?

anthonym’s picture

anthonym commented
Priority: Normal » Critical
Status: Active » Postponed (maintainer needs more info)

Same issue here. I'm using Audio module version 5.x-2.x-dev and get the same error when I try to add a "Audio: Tag year" sort to a view. Can someone fix this?