SermonSpeaker 7 Update

Known issues when updating to SermonSpeaker 7:

* Don't update all SermonSpeaker extensions at once. Start with the component and do the modules and plugins afterwards one after eachother. Joomla for some reason gets a hickup if you do all in one go.
* If the update of a player plugin fails, try disabling the plugin prior to running the update. That should fix it. Don't forget to enable it afterwards again.

Thanks so much @Thomas Hunziker

I went ahead & updated the sermonspeaker component to v.7 (leaving the plugins on v.6) before upgrading Joomla to v.6 & then upgrading sermonspeaker plugins to v.7.
Everything seems to have gone well, except when I visit Maintenance -> Database, one problem gets listed for the sermonspeaker database. The database version is listed as 6.2.0 whereas the Manifest version is listed as 7.0.1. When I float over the "one problem", it shows this: "Table 'obloq_sermon_sermons' has the wrong type or attributes for column 'audiofile' with type TEXT. (From file 4.1.sql.)"

Is there any good way to fix this database problem?

Thanks!

The difference between database version and manifest is fine. There was no change to the database with SermonSpeaker 7.0, so it is still 6.2.0 where the last change was.
The problem is likely unrelated to SermonSpeaker 7.0 and was already present before.

You can try the database fix button, often enough this one will fix the issue automatically.
If not, you will have to use a database program like phpMyAdmin and check the 'audiofile' column.
It should be "TEXT NULL". Probably the NULL part is missing.
The respective SQL command is in the 6.0.9.sql file :

Thanks so much again @Thomas Hunziker

OK, I ran the following query:
Strangely, this had 0 results, so I tried the following query:
This successfully entered NULL in all the audiofile rows which had no content.

But that said, Joomla still persists with the error "Table 'obloq_sermon_sermons' has the wrong type or attributes for column 'audiofile' with type TEXT. (From file 4.1.sql.)"

I also tried the autofix, but that failed.

Is there anything else I can do to solve this error?

Thanks!

Ah I see where this is coming from. The 4.1 file has a conflicting SQL statement with later SQL files.
You can delete all old update files without issues (maybe keep the newest one). That should do the trick.
With SermonSpeaker 6, the update script should have deleted all those old files, but that seems to have failed in your case.

Perfect! Thank you again so much!
Found them under public_html/administrator/components/com_sermonspeaker/sql/updates/mysql & deleted the old ones. Everything seems to be functional now
Thx!