0
I have do a search in admin module and I have this SQL error. The issue is due to an " ' " in the album name !
"
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 'iq %') ORDER BY al.added DESC' at line 1 SQL=SELECT al.*,ar.artist_name,f.format_name, u.name as username FROM jweb_muscol_albums as al LEFT JOIN jweb_muscol_artists as ar ON ar.id = al.artist_id LEFT JOIN jweb_muscol_format as f ON f.id = al.format_id LEFT JOIN jweb_users as u ON u.id = al.user_id WHERE (al.keywords LIKE '% Shaqa'iq %') ORDER BY al.added DESC
"
But now how can I resolve this issue ? I can't import new album :-/
Thanks for rapid response
"
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 'iq %') ORDER BY al.added DESC' at line 1 SQL=SELECT al.*,ar.artist_name,f.format_name, u.name as username FROM jweb_muscol_albums as al LEFT JOIN jweb_muscol_artists as ar ON ar.id = al.artist_id LEFT JOIN jweb_muscol_format as f ON f.id = al.format_id LEFT JOIN jweb_users as u ON u.id = al.user_id WHERE (al.keywords LIKE '% Shaqa'iq %') ORDER BY al.added DESC
"
But now how can I resolve this issue ? I can't import new album :-/
Thanks for rapid response
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 »