I update audio module from 5x 1.0 to 5.x 2.x version , add active the "Audio Playlist " module.
when I click "Add to playlist" from the audio node I get the error messenger that

Add audio file to a playlist
__________________________________________________________________________________
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 'ORDER BY n.sticky DESC, n.title ASC' at line 1 query: SELECT DISTINCT(n.nid), n.title FROM node n WHERE n.status=1 AND ORDER BY n.sticky DESC, n.title ASC in /home/ton/domains/zone.vn/public_html/includes/database.mysql.inc on line 172.
__________________________________________________________________________________

Can you tell me where the error from!
thanks!

CommentFileSizeAuthor
#7 addplaylist error2.JPG128.55 KBzeke-1
#2 addplaylist error.JPG69.81 KBzeke-1

Comments

zirafa’s picture

zirafa commented

Can you provide some more information? What else did it show on the page? (a screenshot would be very helpful)

zeke-1’s picture

zeke-1 commented
StatusFileSize
new addplaylist error.JPG69.81 KB

here my screenshot follow when I click the "add to playlist"
screenshot

zeke-1’s picture

zeke-1 commented

And the URL of the screen is: http://www.domain.com/audio_playlist/1679?destination=audio

zirafa’s picture

zirafa commented

Ah, looks like you don't haven't created any playlist nodes yet, so it's spitting out this error. A playlist = a node with audio_attach and audio_playlist enabled. Can you check if that's the problem?

If that's the problem, I need to put a fix so that the error doesn't happen.

zeke-1’s picture

zeke-1 commented

You say: A playlist = a node with audio_attach and audio_playlist enabled
How do I enable audio_playlist ?
Do you means "audio_playlist module", I really enable it.

zirafa’s picture

zirafa commented

After you turn on both audio_attach and audio_playlist modules, go to admin/content/types to specify which content type should accept audio attachments. This node type, which has audio attachments enabled, can now be used by the audio_playlist.module as a "playlist". The audio_playlist module then allows you to browse the site and quickly add an audio file to an existing playlist.

Does that make sense? Maybe first just try to get audio_attach working by itself. Then when you turn on audio_playlist it should make sense.

zeke-1’s picture

zeke-1 commented
Title: "Add to playlist" error » Error display
StatusFileSize
new addplaylist error2.JPG128.55 KB

Thank you very much for your support , it very clear... and I can do it now.

But I got other error display,
I create a new node type, it's name play-list, and enable the "audio attachments" , when I create the new play-list node ,the error display appear (you can see the screenshot in the attack file) but when I submit that still work right.

zirafa’s picture

zirafa commented
Title: Error display » "Add to playlist" error

Watch out about changing the issue title.

Hm that error sounds like it's from an older version of the module...but I'll take a look see.

zeke-1’s picture

zeke-1 commented
Title: "Add to playlist" error » "Add to playlist" Update problem !

Thanks, zirafa
I am looking for you answer.
Should I re move the audio mudule and install the new one!

zirafa’s picture

zirafa commented
Status: Active » Fixed

I committed a change to fix the original problem. The changes should get rolled into the 5.x-2.x branch shortly. If you encounter a new error unrelated to the original post, please file a new bug report. Thanks.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)