By Jordan Weinstein on Wednesday, 27 April 2016
Posted in Technical Issues
Replies 3
Likes 0
Views 743
Votes 0
I am getting this error on browsing the ED Toolbar > Forums Link (included in site details)

1054 Unknown column 'Array' in 'where clause' SQL=select SQL_CALC_FOUND_ROWS a.`id` from `#__discuss_category` as a where a.parent_id = Array and a.`published` = '1' and 1 <= (SELECT COUNT(1) FROM `#__discuss_category` as acat WHERE acat.`id` = a.id AND ( ( acat.`private` = 0 ) OR ( (acat.`private` = 1) AND (0 > 0) ) OR ( (acat.`private` = 2) AND ( (select count(1) from `#__discuss_category_acl_map` as cacl WHERE cacl.`category_id` = acat.id AND cacl.`acl_id` = 2 AND cacl.type = 'group' AND cacl.`content_id` in (1)) > 0 ) ) ) ) ORDER BY a.`lft` asc LIMIT 0, 5

I have set this up on a test site so if there are any code changes required please let me know so I can apply to my live site.

Jordan
Hi Jordan Weinstein,

Regarding your issue, I've added a fix on you dev site. Below is the file i've modified.

JOOMLA/administrator/components/com_easydiscuss/models/categories.php

The same fix will be added into next release of EasyDiscuss 4.0 as well

Please verify again.

Hope this help and have a nice day!
Sam
·
Wednesday, 27 April 2016 18:20
·
0 Likes
·
0 Votes
·
0 Comments
·
Great, thanks!
·
Wednesday, 27 April 2016 18:24
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome Jordan
·
Wednesday, 27 April 2016 18:25
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post