SermonSpeaker Module Latest Sermons

Recently upgraded to the latest version of Joomla and SermonSpeaker. The 'Latest Sermons' module worked on previous versions but now displays the following error. Therefore, I disabled the plug-in. Did I miss a step during the upgrade process?

I am using the protostar template and position-7. I've tried to move the module to different positions without any success.

"1054 Unknown column 'a.publish_up' in 'where clause' SQL=SELECT a.title, a.id, a.sermon_date, a.audiofile, a.videofile, a.sermon_time, a.picture, a.notes, a.hits, a.catid, a.language,b.title as speaker_title, b.pic, b.state AS speaker_state, b.catid AS speaker_catid, b.language AS speaker_language,c.title AS series_title, c.avatar, c.state AS series_state, c.catid AS series_catid, c.language AS series_language,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(':', b.id, b.alias) ELSE b.id END as speaker_slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as series_slug,cat.title AS category_title,CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.id, cat.alias) ELSE cat.id END as catslug FROM #__sermon_sermons AS a LEFT JOIN #__sermon_speakers AS b ON b.id = a.speaker_id LEFT JOIN #__sermon_series AS c ON c.id = a.series_id LEFT JOIN #__categories AS cat ON cat.id = a.catid WHERE a.state = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-11-01 15:27:39') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-11-01 15:27:39') AND (a.catid = 0 OR (cat.access IN (1,1,5) AND cat.published = 1)) ORDER BY sermon_date DESC, (sermon_number+0) DESC LIMIT 3"

Thanks for any help,
T/

That column "publish_up" is available in SermonSpeaker since version 5.4.0. Can you please check your installed version? The most recent one would be 5.5.4 ( www.sermonspeaker.net/download/sermonspe...component-5-5-4.html ) on Joomla 3.6.4 ( downloads.joomla.org/ )

If you have version 5.5.4 installed, you seem to miss some SQL changes, however that should generate issues not only in the latest sermons module.

My bad... I should have checked there first... everything is working as expected once again. Thanks.

Great that it works now