George
George
Offline
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
Responses (1)
  • Accepted Answer

    Monday, March 01 2010, 04:33 PM - #Permalink
    0
    hmm... looks like you're trying to add albums or artists without being logged in... :S

    only logged in users can add content

    (if you look at the mysql errors, look at the "AND user_id =", the user id is missing, or in other words: you are not logged in)
    The reply is currently minimized Show
Your Reply