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
Responses (2)
  • Accepted Answer

    Wednesday, June 25 2014, 10:45 AM - #Permalink
    0
    Ok thanks. It's working now :)
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, June 25 2014, 09:47 AM - #Permalink
    0
    hi, please re-download and reinstlal music collection, that particular search issue should be solved.
    The reply is currently minimized Show
Your Reply