0
First of all, I love this component but I having trouble with V2's best additions. When I set 'Frontend users can only add albums by artists they created' to yes I get errors.
Add artist error
500 - JDatabaseMySQL::query: 1064 - 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 letter,class_name' at line 1 SQL=SELECT id,artist_name FROM jos_muscol_artists WHERE id != 0 AND user_id = ORDER BY letter,class_name
Add album error
500 - JDatabaseMySQL::query: 1064 - 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 disc_num,num' at line 3 SQL=SELECT id FROM jos_muscol_songs WHERE album_id = ORDER BY disc_num,num
Any help would be greatly appreciated.
Thank you
Add artist error
500 - JDatabaseMySQL::query: 1064 - 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 letter,class_name' at line 1 SQL=SELECT id,artist_name FROM jos_muscol_artists WHERE id != 0 AND user_id = ORDER BY letter,class_name
Add album error
500 - JDatabaseMySQL::query: 1064 - 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 disc_num,num' at line 3 SQL=SELECT id FROM jos_muscol_songs WHERE album_id = ORDER BY disc_num,num
Any help would be greatly appreciated.
Thank you
Your Reply

Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »