Вот возник вопрос. Может я что не так сделал? Помогите исправить...
Было при переводе контента и меню:
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 \'= 0\nORDER BY c.title\' at line 5 SQL=SELECT c.id, c.title, c.title_alias, c.introtext, c.fulltext, c.images, c.metakey, c.metadesc, c.created, c.modified as modified_date, c.modified, c.checked_out as check_out, c.checked_out, c.checked_out_time, jfc.id as jfc_id, jfc.value as titleTranslation, jfc.modified as lastchanged, jfc.published as published, jfc.language_id, jfl.name as language\nFROM primaria_content as c\nLEFT JOIN primaria_jf_content as jfc ON c.id=jfc.reference_id AND jfc.reference_field=\'title\' AND jfc.reference_table=\'content\'\nLEFT JOIN primaria_languages as jfl ON jfc.language_id=jfl.id\nWHERE = 0\nORDER BY c.titleDB function failed with error number 1064
Сделал, как здесь советовали:
следует удалить файл ./includes/domit/xml_domit_lite_parser.php и переименовать ./includes/domit/xml_domit_lite_parser.php_original в ./includes/domit/xml_domit_lite_parser.php.
После чего, контент стал нормально, а при выборе для перевода меню, - пишет:
Unknown column \'c.state\' in \'where clause\' SQL=SELECT c.id, c.name as title, c.name, c.checked_out as check_out, c.checked_out, c.checked_out_time, jfc.id as jfc_id, jfc.value as titleTranslation, jfc.modified as lastchanged, jfc.published as published, jfc.language_id, jfl.name as language\nFROM jos_menu as c\nLEFT JOIN jos_jf_content as jfc ON c.id=jfc.reference_id AND jfc.reference_field=\'name\' AND jfc.reference_table=\'menu\' AND jfc.language_id=4\nLEFT JOIN jos_languages as jfl ON jfc.language_id=jfl.id\nWHERE c.state >=0\nORDER BY c.nameDB function failed with error number 1054
Unknown column 'c.state' in 'where clause' SQL=SELECT c.id, c.name as title, c.name, c.checked_out as check_out, c.checked_out, c.checked_out_time, jfc.id as jfc_id, jfc.value as titleTranslation, jfc.modified as lastchanged, jfc.published as published, jfc.language_id, jfl.name as language FROM jos_menu as c LEFT JOIN jos_jf_content as jfc ON c.id=jfc.reference_id AND jfc.reference_field='name' AND jfc.reference_table='menu' AND jfc.language_id=4 LEFT JOIN jos_languages as jfl ON jfc.language_id=jfl.id WHERE c.state >=0 ORDER BY c.name LIMIT 0, 30
Что я сделал не так?