Keyword

Error 1064 en User Page (Blog)

  • Eduard
  • Eduard's Avatar Topic Author
  • Offline
  • New Member
More
5 years 3 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.


Powered by Kunena Forum