Buenos días tengo el siguiente problema al traducir al ingles con joomfish en menu.
No valid database connection: DB function failed with error number 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 ' c.type, c.checked_out as check_out, c.checked_out, c.checked_out_time, jfc.id a' at line 1 SQL=SELECT c.id, c.name as title, c.name, c.alias, c.params, c., c.type, 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.title as language, jfc.reference_id as jfc_refid 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.lang_id WHERE c.published>=-1 ORDER BY c.name LIMIT 0, 20
En languages tengo el siguiente:
No valid database connection: DB function failed with error number 1054
Unknown column 'c.id' in 'field list' SQL=SELECT c.id, c.name as title, c.name, jfc.id as jfc_id, jfc.value as titleTranslation, jfc.modified as lastchanged, jfc.published as published, jfc.language_id, jfl.title as language, jfc.reference_id as jfc_refid FROM jos_languages as c LEFT JOIN jos_jf_content as jfc ON c.id=jfc.reference_id AND jfc.reference_field='name' AND jfc.reference_table='languages' AND jfc.language_id=4 LEFT JOIN jos_languages as jfl ON jfc.language_id=jfl.lang_id ORDER BY c.name LIMIT 0, 20
URL del sitio: Contenido solo visible a usuarios registrados
Hola,
Es posible que no hayas instalado correctamente el componente Joomfish o que se haya modificado algo en la base de datos de Joomla.
El error que te sale en lenguajes no cuadra porque está llamando a tablas propias de Joomla. Tendrías que entrar en la base de datos usando el phpmyadmin que encontrarás en el panel de control de tu hosting. Luego, vete a la paba jos_languages y comprueba si tiene un campo con nombre id.
Buenas, adjunto pantallazo de lo que me pides.
Hola Joaquín,
No hemos recibido las capturas envíalas de nuevo.
Saludos