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