Error 1054 after upgrade

I upgraded SermonSpeaker to 5.01 in my Joomla 3.1.1 site. The site is now down and I got the following page.

Any idea what I did wrong?

www.compassionchurch.org/

Error: 1054 - Unknown column 'a.sermon_title' in 'field list' SQL=SELECT a.sermon_title, a.id, a.sermon_date, a.audiofile, a.videofile, a.sermon_time, a.picture, a.notes, a.hits,b.name, b.pic, b.state AS speaker_state, c.series_title, c.state AS series_state,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 fkgdx_sermon_sermons AS a LEFT JOIN fkgdx_sermon_speakers AS b ON b.id = a.speaker_id LEFT JOIN fkgdx_sermon_series AS c ON c.id = a.series_id LEFT JOIN fkgdx_categories AS cat ON cat.id = a.catid WHERE a.state = 1 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 0, 10

Which vies are you using? Or did you miss to update all modules as well? Which ones are you using?

I don't know what "vies" are.

Also, I didn't know that I needed to update the modules. I'm using Latest Sermons, so I'll update that and see if it fixes the issue.

Thanks!

Yes, that fixed it. Thanks again.

Usually it doesn't matter much, but in this case there were changes in the database which are not compatible with older modules.

Unfortunately Joomla doesn't have a way yet to mark dependancies between extensions and their Versions. It will be added to Joomla 3.5 if we get lucky

The "vies" should have been "views". Typing on a mobile phone can be tricky
Views are the Joomla term for the various outputs of a component.

I have the same problem at the frontend after updating all modules.... it works fine now.
But at the backend when I delete a sermon I see this error !