Baka Miroslav
Newbie

Posts: 3
|
 |
« on: October 21, 2008, 07:23:51 PM » |
|
Hello, I had problem when trying to manage offers translations.
DB function failed with error number 1054
Unknown column 'c.showwage' in 'field list' SQL=SELECT c.id, c.title, c.description, c.contact, c.level, c.experience, c.category, c.wage, c.showwage, c.reference, c.location, c.duration, c.created_datetime, c.modified_datetime, c.hits, c.version, c.access, c.ordering, c.nbopenings, c.published, c.type, c.begin_date, 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_neorecruit_offers as c LEFT JOIN jos_jf_content as jfc ON c.id=jfc.reference_id AND jfc.reference_field='title' AND jfc.reference_table='neorecruit_offers' AND jfc.language_id=5 LEFT JOIN jos_languages as jfl ON jfc.language_id=jfl.id ORDER BY c.title LIMIT 0, 50
There is typo in neorecruit_offers.xml on row 17. Wrong: <field type="text" name="showwage" translate="0">showwage</field> Right: <field type="text" name="show_wage" translate="0">show_wage</field>
Cheers
Mira
|