UPDATES EasyBlog 6.0.14 Released! Joomla 5.x and PHP 8.x compatible now!

Helpdesk

Your Time
Our Time
Response Time
24 — 48 hours
We strive to provide the fastest ever response possible. However, we are not super beings.

Allow at least 24 — 48 hours
  Support is offline
It is currently off working hours and most of us aren't around

Rest assured that we will get back to you as soon as the day starts tomorrow!
  Support is offline

mod_latestblogs generates an SQL Syntax error

Print and Web Designer · ·
2:32 AM Thursday, 09 October 2014
None
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
The replies under this section are restricted to logged in users or users with an active subscription with us