Avisos
Vaciar todo

error base de datos

12 Respuestas
3 Usuarios
0 Reactions
2,741 Visitas
Juan Manuel Gonzalez Santana
Respuestas: 106
Estimable 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 al intentar añadir un nuevo elemento K2 me sale el siguiente error:

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 '' at line 1 SQL=UPDATE `jbeh3_finder_taxonomy_map` SET `link_id`='4',`node_id`='3' WHERE

A pesar de ello, si que me añade bien el elemento. Pueden ayudarme?
Gracias y saludos
Juan Manuel Gonzalez

URL del sitio: Contenido solo visible a usuarios registrados


 
Respondido : 06/03/2013 10:50 am
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 Juan,

Parece un problema de sintaxis de Mysql por parte de componente.

Revisa el siguiente enlace sobre comillas en Mysql :

http://stackoverflow.com/questions/11093634/you-have-an-error-in-your-sql-syntax-check-the-manual-that-corresponds-to-your

Saludos


 
Respondido : 06/03/2013 11:12 am
Juan Manuel Gonzalez Santana
Respuestas: 106
Estimable 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
 

Gracias por responder Hicham, pero entonces que me recomiendas, que reinstale K2?
Un saludo


 
Respondido : 06/03/2013 11:39 am
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 Juan,

¿Qué versión de K2 estas usando?

Puedes descargar la última versión 2.6.5 desde http://getk2.org/ .

Saludos


 
Respondido : 06/03/2013 12:26 pm
Juan Manuel Gonzalez Santana
Respuestas: 106
Estimable 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
 

Hola Hicham, nada, he instalado de nuevo el K2 y sigue igual. No se le ocurre a nadie alguna solución?
Muchas gracias


 
Respondido : 11/03/2013 9:31 pm
Johnny Heredia Montiel
Respuestas: 20127
Illustrious Member Moderator
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 Juan Manuel,

Puedes enviarnos una captura del error que se te esta presentando para poder evaluarlo correctamente.

Saludos.


 
Respondido : 12/03/2013 3:24 am
Juan Manuel Gonzalez Santana
Respuestas: 106
Estimable 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
 

Muchas gracias por responder, te adjunto el pantallo del error 500 que aparece cuando le doy a grabar a un articulo nuevo, el caso es que da ese error pero el articulo se crea y despues puedo modificarlos sin que vuelva a salir ninguna pantalla de error.
Muchas gracias de antemano por las molestias.
Juan Manuel Gonzalez


 
Respondido : 12/03/2013 10:30 am
Juan Manuel Gonzalez Santana
Respuestas: 106
Estimable 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
 

parece que no sube la imagen pero aparece la pantalla en blanco con este texto:

500 - An error has occurred.

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 '' at line 1 SQL=UPDATE `jbeh3_finder_taxonomy_map` SET `link_id`='25',`node_id`='3' WHERE

Return to Control Panel


 
Respondido : 12/03/2013 10:35 am
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 Juan,

Parece que aquí se ofrece una solución :

http://www.zootemplate.com/blog/how-to-solve-the-k2-database-error-db-function-failed-with-error-number-1064.html

Haz un backup antes de proceder a cambiar los ficheros indicados.


 
Respondido : 12/03/2013 10:53 am
Juan Manuel Gonzalez Santana
Respuestas: 106
Estimable 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
 

Hola Hicham, nada, he compobado que ese trozo de código está bien, debe ser otra cosa.
😛


 
Respondido : 12/03/2013 11:04 am
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 Juan,

En Componentes >> Búsqueda Inteligente >> Eliminar >> Purgar, luego revisa si con esto se soluciona el problema.


 
Respondido : 12/03/2013 11:40 am
Juan Manuel Gonzalez Santana
Respuestas: 106
Estimable 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
 

Muchas gracias!!! era eso
Un saludo
Juan Manuel Gonzalez


 
Respondido : 12/03/2013 12:05 pm