Problema traduccion...
 
Avisos
Vaciar todo

Problema traduccion con base de datos (URGENTE)

5 Respuestas
4 Usuarios
0 Reactions
1,858 Visitas
Respuestas: 13
Active Member
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

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


 
Respondido : 19/10/2012 10:11 am
Pablo Velasco
Respuestas: 20382
Illustrious Member
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

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.


 
Respondido : 19/10/2012 10:49 am
Respuestas: 13
Active Member
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Buenas, adjunto pantallazo de lo que me pides.


 
Respondido : 21/02/2013 3:21 pm
Hicham
Respuestas: 1908
Noble Member
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Hola Joaquín,

No hemos recibido las capturas envíalas de nuevo.

Saludos


 
Respondido : 21/02/2013 5:31 pm
Luis Mendez Alejo
Respuestas: 23269
Illustrious Member
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Hola Joaquín,

JoomFish requiere que tengas la base de datos como mysqli y no como mysql.

Lo modificas desde tu configuración global de Joomla. Entiendo que se trata de Joomal 1.5 ¿correcto?

Nota: No olvides primero hacer una copia de seguridad de la web.

Saludos


 
Respondido : 21/02/2013 8:47 pm