- Thank you received: 0
Support for SermonSpeaker 5.x is in bugfix mode only, the same as it is for Joomla 3.10.
I will not add any new features to this releases.
Please upgrade to SermonSpeaker 6.x and Joomla 4.x, which is better anyway.
I will not add any new features to this releases.
Please upgrade to SermonSpeaker 6.x and Joomla 4.x, which is better anyway.
Problems migrating to Joomla 3.3
- Jon
-
Topic Author
- New Member
-
Less
More
02 Jan 2015 16:28 #5017
by Jon
Problems migrating to Joomla 3.3 was created by Jon
Hello,
I just migrated to Joomla 3.3, and I am having two strange problems with SermonSpeaker. First, the Latest Sermons module on my page shows all kinds of errors, so I had to disable it. Second, I tried to create a new module, but the form doesn't seem to include a save or OK button, so there is no way for me to create a new module. Here is the error being displayed by my module:
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 j25_sermon_sermons AS a LEFT JOIN j25_sermon_speakers AS b ON b.id = a.speaker_id LEFT JOIN j25_sermon_series AS c ON c.id = a.series_id LEFT JOIN j25_categories AS cat ON cat.id = a.catid WHERE a.state = 1 AND (a.catid = 0 OR (cat.access IN (1,1) AND cat.published = 1)) ORDER BY sermon_date DESC, (sermon_number+0) DESC LIMIT 0, 3
I just migrated to Joomla 3.3, and I am having two strange problems with SermonSpeaker. First, the Latest Sermons module on my page shows all kinds of errors, so I had to disable it. Second, I tried to create a new module, but the form doesn't seem to include a save or OK button, so there is no way for me to create a new module. Here is the error being displayed by my module:
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 j25_sermon_sermons AS a LEFT JOIN j25_sermon_speakers AS b ON b.id = a.speaker_id LEFT JOIN j25_sermon_series AS c ON c.id = a.series_id LEFT JOIN j25_categories AS cat ON cat.id = a.catid WHERE a.state = 1 AND (a.catid = 0 OR (cat.access IN (1,1) AND cat.published = 1)) ORDER BY sermon_date DESC, (sermon_number+0) DESC LIMIT 0, 3
Please Log in or Create an account to join the conversation.
- Thomas Hunziker
-
- Offline
- Administrator
-
02 Jan 2015 16:42 #5018
by Thomas Hunziker
Replied by Thomas Hunziker on topic Problems migrating to Joomla 3.3
How did you migrate to Joomla 3.3? Did you upgrade it using the Joomla Updater? Which version of SermonSpeaker do you have installed?
If you already updated SermonSpeaker, make sure to also update the modules. If the Joomla Update view doesn't show you any updates, check on the download page itself: www.sermonspeaker.net/download.html
If you already updated SermonSpeaker, make sure to also update the modules. If the Joomla Update view doesn't show you any updates, check on the download page itself: www.sermonspeaker.net/download.html
Please Log in or Create an account to join the conversation.
- Jon
-
Topic Author
- New Member
-
Less
More
- Thank you received: 0
02 Jan 2015 17:01 #5019
by Jon
Replied by Jon on topic Problems migrating to Joomla 3.3
Thank you for the very quick reply! It does appear that I was running an older version. After I had upgraded Joomla, I really thought that I remembered upgrading SermonSpeaker directly from Joomla. The updates no longer show up in Joomla, so I just downloaded and installed them manually. The only SermonSpeaker pieces that are not a version higher than 5.0 are the Button (4.5) the Package (4.4.3) and the Rotator (4.4.2). All others are higher than 5.0. Is this correct?
Please Log in or Create an account to join the conversation.
- Thomas Hunziker
-
- Offline
- Administrator
-
02 Jan 2015 17:10 #5020
by Thomas Hunziker
Replied by Thomas Hunziker on topic Problems migrating to Joomla 3.3
For the rotator there is no updated version. It likely will not work with the latest versions of SermonSpeaker.
You can ignore the package version, or just install the latest package. That one works a bit strange imho
The button is still 4.5.0. That's correct. Nothing changed there lately
You can ignore the package version, or just install the latest package. That one works a bit strange imho

The button is still 4.5.0. That's correct. Nothing changed there lately

Please Log in or Create an account to join the conversation.
- Jon
-
Topic Author
- New Member
-
Less
More
- Thank you received: 0
02 Jan 2015 17:47 #5021
by Jon
Replied by Jon on topic Problems migrating to Joomla 3.3
I thought that I had installed the latest package in order to get the latest version of the component. Not sure how they got out of sync, but it's all good now. Thanks again!
Please Log in or Create an account to join the conversation.
Time to create page: 0.274 seconds