Errors after migrating to Jooma 4

Hi,

1. I have successfully migrated Sermon Speaker to Joomla 4 (6.1.6). But it was necessary to install 2 times one by one. After that, all is working. After 1st upgrade, there was error "Can't DROP COLUMN `custom2`; check that it exists" and "Error installing component". Maybe it will be good to put to installer some message to install component 2 times.
2. Latest sermons' module has probably some issues. Now some sermons are possible to display and some not ("The requested page can't be found. An error has occurred while processing your request."). Below are error messages

Thank you.
Radovan

Error messages from debug:

• The requested page can't be found.
• () - JROOT/components/com_sermonspeaker/models/sermon.php:127
• SermonspeakerModelSermon->getItem() - JROOT/libraries/src/MVC/View/AbstractView.php:152
• Joomla\CMS\MVC\View\AbstractView->get() - JROOT/components/com_sermonspeaker/views/sermon/view.html.php:100
• SermonspeakerViewSermon->display() - JROOT/libraries/src/MVC/Controller/BaseController.php:660
• Joomla\CMS\MVC\Controller\BaseController->display() - JROOT/components/com_sermonspeaker/controller.php:138
• SermonspeakerController->display() - JROOT/libraries/src/MVC/Controller/BaseController.php:693
• Joomla\CMS\MVC\Controller\BaseController->execute() - JROOT/components/com_sermonspeaker/sermonspeaker.php:39
• require_once() - JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
• Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() - JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73

There should be no need to install it twice.

Apparently, your installation missed out when SermonSpeaker added the custom columns in an older version. And now when it tried to delete them (because Joomla has Tags now), it failed.
With the second installation it worked because Joomla is funny sometimes

As for the latest sermons module error. The module seems to link to a sermon which isn't available. This may be because the category of that sermon or its speaker or series category aren't set up correctly.
If that is not the case, I would have to see the site myself.

Hi Thomas,

1. this 2-step installation of Sermon Speaker 6 is since beginning of Joomla 4 (upgrade from Joomla 3). Same with PHP 7.4 and 8.1. All Joomla 4 versions. And same with localhost and live server.
2. there is over 340 sermons - is this reason?
3. not working sermons are published and categories are set correctly
4. here is my testing server - j4.radiologos.sk/ It is in Slovak language, and debug is on.
5. j4.radiologos.sk/zvukovy-archiv.html is Sermon Speaker component
6. in attachment is picture with menu of Sermon Speaker (in administration) - there is bug in admin menu after 1st upgrade of S. Speaker (after upgrade to Joomla 4)
7. Do you need to login as superuser? If yes, let me now email where to send login information

Thank you
Radovan

Looks like the sermons from J.Piper are working but from another speaker not. Likely the category of that speaker is not correctly set.
Now it might look right if you look in the manager, but it still may be the wrong one. If you go into the speaker edit form and save it, it likely will reassign the correct one.

A bit on the technical side: With SermonSpeaker 6, I've changed the categories so you have independant categories for sermons, speakers and series. During the update, it will copy the existing ones and reassign them.
But since you got trouble with database things during the first update, it may have broken some things there as well.
Also your backend menu looks like it is missing the new submenus.

I can have a look at your backend, and especially the database tables and fix this manually.
You can send me the credentials to bakual@bakual.ch or use the contact form.

Hi Thomas,

yes, there was the wrong category for speaker. See attached image. After fixing speaker category, sermons works as should.

Thanks for help.
Radovan