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

Error 1054 with EasyDiscuss Recent Discussions module

Chris Egle · ·
7:47 AM Thursday, 06 November 2014
None
Hi,

I'd like to use this module to list the latest posts with a specific tag. When I choose the Selected Tag option, I get the following error:
1054 - Unknown column 'b.published' in 'where clause' SQL=SELECT a.*, (SELECT COUNT(1) FROM `#_discuss_posts` WHERE `parent_id` = a.`id` AND `published`="1") AS `num_replies` FROM `#_discuss_posts` AS a LEFT JOIN `#_discuss_posts_tags` AS c ON a.`id`= c.`post_id` WHERE a.`published`='1' AND a.`parent_id`='0' AND b.`published`='1' AND c.`tag_id`='8'ORDER BY a.`created` DESC LIMIT 0,5

(I cleaned out my database prefix and replaced it with '#'.)

I have several of these modules working with the Selected Category option without any issues. Any ideas?

Software:

  • Joomla 3.3.6
  • EasyDiscuss 3.2.9534
  • Recent Discussions Module 3.2.1


Thanks!
The replies under this section are restricted to logged in users or users with an active subscription with us