By Chris Egle on Thursday, 06 November 2014
Posted in Technical Issues
Replies 3
Likes 0
Views 737
Votes 0
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!
Hello Chris,

Please replace the attached file in: ../modules/mod_recentdiscussions/helper.php. If this doesn't work, you can provide us your backend and FTP so we can fix it for you.
·
Thursday, 06 November 2014 10:48
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you for the quick reply. I wasn't able to try the fix until today. It worked great - all is well!
·
Wednesday, 12 November 2014 07:32
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Chris,

You are welcome.
·
Wednesday, 12 November 2014 10:39
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post