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:
The Jomsocial engineers have established that that query error message belongs to EasyBlog.
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