Keyword

Error 1064 en User Page (Blog)

  • Eduard
  • Eduard's Avatar Topic Author
  • Offline
  • New Member
More
4 years 5 months ago #140753 by Eduard
Eduard created the topic: Error 1064 en User Page (Blog)
Hola,

he migrado el contenido de la web, versión de Joomla 2.5.22 a una nueva con Joomla 3.3.6 con ek componente SP Transfer, pero no parece funcionar K2.
Siempre parece el mensage:
#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 ') ORDER BY i.id DESC LIMIT 0, 10' at line 1 SQL=SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams FROM xxxx_k2_items as i RIGHT JOIN xxxx_k2_categories AS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1,1,5) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1,5) AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2015-02-11 15:11:26' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2015-02-11 15:11:26' ) AND i.created_by=0 AND i.created_by_alias='' AND c.id IN() ORDER BY i.id DESC LIMIT 0, 10

He probado a reinstalar K2, a modificar algun fichero tal y como se describe en la web de Additional Categories for K2, a usar una plantilla standard de Joomla (Beez3), pero sin resultados.
¿Alguien sabe como solucionarlo?
Gracias
Gracias

Please Log in or Create an account to join the conversation.

Moderators: william whiteEmanuel Rodríguez

Powered by Kunena Forum