gulmue wrote:teitbite wrote:Hi
Problem is fixed and will be available within newest module update. If You wan to use it right away than replace the file mod_news_pro_gk5/admin/class.portalmodes.js with one attached:
great thanks for the help!!
I replace the file, but I know get the following error: 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 'DESC LIMIT 0,1' AT LINE 21 SQL=SELECT CONTENT.ID AS ID FROM JOS_K2_ITEMS AS CONTENT WHERE CONTENT.PUBLISHED = 1 AND CONTENT.TRASH = 0 AND CONTENT.ACCESS IN (1,1,2,3,6) AND ( CONTENT.PUBLISH_UP = '0000-00-00 00:00:00' OR CONTENT.PUBLISH_UP <= '2015-02-25 22:22:11' ) AND ( CONTENT.PUBLISH_DOWN = '0000-00-00 00:00:00' OR CONTENT.PUBLISH_DOWN >= '2015-02-25 22:22:11' ) AND ( CONTENT.CATID = 4 ) ORDER BY CONTENT. DESC LIMIT 0,1;
This is created by the module id 114, if I unpublished the problem is fix. I try to create a new module, but did't work, specially when I use the K2 categories.
any clue whats going on?