Another error 1054 on updating to SS 5.0.3

Thomas Hunziker wrote: "Ressource not found" usually means that there is no file referenced in the sermon. Thus the player can't play anything. Looking at that specific sermon you even wrote it in the notes

LOL - think you can see how ditzy this process has made me that I'm missing the blatantly obvious.

Well, FINALLY (!!) you'll be pleased to know you've sorted me out & can have some peace from the sunny shores of Ulster now for awhile . I just had one other thing that stumped me for the past 3 hrs & have only just figured it out after almost firing you another Help note. But everything's working fine now & so I can finally move on to switching over the 2.5 site to this one without any worries.

Many MANY thanks for your patience

No problem. Just ask if there are questions

Thomas,

What would be your recommended process for fixing a 1054 error after updates have been made? It seems that SS was not updated to the most current version for the Joomla version BEFORE updating Joomla to the current 3.4.1 version and then updating SS to the current 5.0.3 (as recommended earlier in this thread). Do we need to revert back to an earlier version of SS and/or Joomla or can we move forward from here?

The error we are getting is

Error: 1054 Unknown column 'publish_up' in 'where clause' SQL=SELECT YEAR(`sermon_date`) AS `year`,CONCAT_WS('-', YEAR(`sermon_date`), MONTH(`sermon_date`), '15') AS `date`,MONTH(`sermon_date`) AS `month` FROM uuokc_sermon_sermons WHERE `state` = 1 AND (`publish_up` = '0000-00-00 00:00:00' OR `publish_up` <= '2015-06-17 06:15:07') AND (`publish_down` = '0000-00-00 00:00:00' OR `publish_down` >= '2015-06-17 06:15:07') GROUP BY `year`,`month` ORDER BY `sermon_date` DESC

The URL to the affected page is 1uc.org/publications/sermons-podcasts

Thank you in advance!

The current version is 5.4.0, not 5.0.3. You can download it from here and install it manually if it doesn't show up in the Joomla updater. Make sure the updateservers are all enabled. They sometimes disable if the server wasn't found. You can enable them again in the Extension Manager -> Update Sites.

To me it sounds like you have an up-to-date archive module, running together with an outdated component. Updating the component should fix it.

Thank you. It really was that simple as updating the component. Whew. And thank you for the tip on the updateservers. All the SS pieces were enabled but a couple of others were not.