news show pro error 1064

News Show Pro GK5 - flexible, responsive and easily extendable free Joomla module support forum.
Rate this topic: Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.
GK User
Fri Mar 20, 2015 4:56 pm
Hi
in my website news show pro cause 1064 error
link: http://aramehetemadi.com/index.php?lang=fa&Itemid=1110

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 ') AND C.EXTENSION = 'COM_CONTENT' AND C.PUBLISHED = 1' AT LINE 12 SQL=SELECT C.ID AS CID FROM YUX7W_CATEGORIES AS C LEFT JOIN YUX7W_CONTENT AS CONTENT ON C.ID = CONTENT.CATID WHERE 1=1 AND ( CONTENT.ID = ) AND C.EXTENSION = 'COM_CONTENT' AND C.PUBLISHED = 1



and this problem just appear in persian view and everything is ok in english view.
english view link: http://aramehetemadi.com/index.php/en/

Also there is some problem with news show pro module in admin area! all the tabs is open and i think it's about JS!

Thanks
User avatar
Junior Boarder

GK User
Sat Mar 21, 2015 6:30 am
Hello,

As it was described many times in this forum:

1) Install the newest version (v.1.8.2)
2) Clear completely your browser cache
3) Resave module settings (please make sure that you have configured properly data source i.e. if you specified article IDs if option with article IDs is selected)
User avatar
Administrator

GK User
Tue Mar 24, 2015 11:19 am
I have the same problém after upgrade to Joomla 3.4.1 , K2 2.6.9 and module 1.82

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,6' at line 21 SQL=SELECT content.id AS id FROM f6ck9_k2_items AS content WHERE content.published = 1 AND content.trash = 0 AND content.access IN (1,1) AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2015-03-24 11:19:01' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-03-24 11:19:01' ) AND ( content.catid = 34 ) ORDER BY content. DESC LIMIT 0,6;

try to save module, only what helps me is to swithc them off
User avatar
Fresh Boarder

GK User
Tue Mar 24, 2015 1:07 pm
@vlada1983 - please try to use a different browser, because it must be a issue with your browser cache.
User avatar
Administrator


cron