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 online
Our support specialists is available now. We will attend to you as soon as we can.
  Support is online

Easy blog causes SQL errors in Jomsocial

Rebel of Oz · ·
9:56 AM Friday, 05 December 2014
None
Since upgrading to Joomla 3.3 five days ago, when I click on 'profile' on my Jomsocial toolbar (http://therebel.website/en/profile) I get the following SQL error message:

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 'IN (221,406,682,990,1067,1123,1127,1255,1285,1306,1730,1799,2109) ) ) OR ( (a.`p' at line 1 SQL=select a.*, b.`title` AS


The Jomsocial engineers have established that that query error message belongs to EasyBlog.

select a.*, b.`title` AS `category`
from `j25_easyblog_post` as a
LEFT JOIN `j25_easyblog_category` AS b
ON a.`category_id` = b.`id`
where a.`created_by` = '2098'
and a.`published` = 1
AND ( (a.`private`= 0 ) OR ( (a.`private` = 20)
AND ('2098' > 0 ) ) OR ( (a.`private` = 30)
AND ( 1 = 2 ) ) OR ( (a.`private` = 40)
AND ( a.=2098) ) )
order by a.`created` DESC
LIMIT 5

Explain
Error
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 '=2098) ) ) order by a.`created` DESC LIMIT 5' at line 1 SQL=EXPLAIN select a.*, b.`title` AS `category` from `j25_easyblog_post` as a LEFT JOIN `j25_easyblog_category` AS b ON a.`category_id` = b.`id` where a.`created_by` = '2098' and a.`published` = 1 AND ( (a.`private`= 0 ) OR ( (a.`private` = 20) AND ('2098' > 0 ) ) OR ( (a.`private` = 30) AND ( 1 = 2 ) ) OR ( (a.`private` = 40) AND ( a.=2098) ) ) order by a.`created` DESC LIMIT 5
The replies under this section are restricted to logged in users or users with an active subscription with us