mod_latestblogs generates an SQL Syntax error

By Print and Web Designer on Thursday, 09 October 2014

Replies 7

Likes 0

Votes 0

Folks,

After updating the site, the homepage displayed an error. After digging deeper, the error source was found to be an SQL query originating from within the mod_latestblogs module. I verified that EasyBlog, mod_latestblogs, etc. were all at the latest version.

Joomla: 3.3.6
EasyBlog: 3.9.18613
mod_latestblogs: 3.9.2

Error message thrown to console:
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 a.`issitewide` = '1' AND a.`category_id` IN('6','2','3','5','') ORDER BY ' at line 1 SQL=SELECT a.`id` AS key1, a.*, b.`id` as key2, b.`title` as `category` FROM `ewmn_easyblog_post` AS a LEFT JOIN `ewmn_easyblog_category` AS b ON a.category_id = b.id WHERE a.`published` = 1 AND a.`ispending` = '0' AND a.`private` = '0' AND a.`category_id` IN (6,2,3,5,) AND a.`issitewide` = '1' AND a.`category_id` IN('6','2','3','5','') ORDER BY a.`created` desc LIMIT 2

Disabling mod_latestblogs returns site to a functional state. Re-enabling mod_latestblogs reliably causes the SQL error.

Site is also running Rocket Theme Paradigm Template v1.2 and Gantry v4.1.25.

I appreciate any help that you can offer.

Regards,
chrissy

--- helper.php.orig 2014-10-13 16:16:47.212803840 -0400 +++ helper.php 2014-10-13 16:14:57.447513194 -0400 @@ -118,7 +118,7 @@ } } - $catIds = array_unique( $catIds ); + //$catIds = array_unique( $catIds ); } $cid = $catIds;