Error on Joomfish

jorge
jorge
Offline
0
Hi. Want to let you know guys there is a bug in Joomfish Artists (Music Collection) language elements. When you choose the option "Artists (Music Collection)" from the content elements drop down in Joomfish, there comes an error saying:

No valid database connection: DB function failed with error number 1054
Unknown column 'c.subartist' in 'field list' SQL=SELECT c.id, c.artist_name as title, c.artist_name, c.class_name, c.subartist, c.review, c.city, c.country, c.url, c.years_active, c.metakeywords, c.metadescription, jfc.id as jfc_id, jfc.value as titleTranslation, jfc.modified as lastchanged, jfc.published as published, jfc.language_id, jfl.name as language, jfc.reference_id as jfc_refid FROM jos_muscol_artists as c LEFT JOIN jos_jf_content as jfc ON c.id=jfc.reference_id AND jfc.reference_field='artist_name' AND jfc.reference_table='muscol_artists' AND jfc.language_id=2 LEFT JOIN jos_languages as jfl ON jfc.language_id=jfl.id WHERE LOWER(c.artist_name ) LIKE '%anuncio%' ORDER BY c.artist_name LIMIT 0, 20
Responses (3)
  • Accepted Answer

    Tuesday, January 04 2011, 05:19 PM - #Permalink
    0
    you are right.
    sorry for that. the issue has been solved.
    please download the extension for joomfish again, we updated it to avoid the problem

    Germi
    The reply is currently minimized Show
  • Accepted Answer

    jorge
    jorge
    Offline
    Tuesday, January 04 2011, 05:57 PM - #Permalink
    0
    Thanks so much. The new file solved the problem.
    The reply is currently minimized Show
  • Accepted Answer

    jorge
    jorge
    Offline
    Thursday, January 27 2011, 04:04 AM - #Permalink
    0
    Related to this I noticed that the artist name do not get translated when one changes from languages, even I wrote the translated artist name on the Artists (Music Collection) joomfish element.
    The reply is currently minimized Show
Your Reply