By HealthInsight on Saturday, 08 August 2015
Posted in Technical Issues
Replies 2
Likes 0
Views 328
Votes 0
It worked before the update and the update install completed without error, but now I get this error on the homepage which used a News Show Pro GK5 module to display blog posts:


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,4' at line 21 SQL=SELECT content.id AS id FROM hi_easyblog_post AS content WHERE content.published = 1 AND content.private = 0 AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2015-08-07 09:48:38' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-08-07 09:48:38' ) AND ( content.category_id = 1 ) ORDER BY content. DESC LIMIT 0,4;


I'm unable to provide a link to the site since it's our internal dev server.
Updating News Show Pro to latest version resolved this error.
·
Saturday, 08 August 2015 00:34
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey there,

I am really sorry for the delay of this reply as it is a weekend for us here. Thanks for updating us on this, glad that your issues are resolved now
·
Saturday, 08 August 2015 03:32
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post