Cannot install SermonSpeaker 2.5.4 to new J 2.5

I think I know now what happens.

When SermonSpeaker collects the sermons to show, it makes a join over the category table to see if a category is assigned to the sermon and if yes it checks if

• the category is published
• the user is allowed to see the category

Now we have a special case where there are categories assigned to the sermons (from the old Joomla) but the categories are not found in the new database. This means that the categories appear as unpublished and the access check will fail, thus the sermons are not shown.

If you create the categories and reassign the sermons to it, it should work.
Depending on how many sermons you have, the easiest way is probably to create the categories and then use " DB Replacer " or a smilar tool to directly change the old (non existant) catid to the id of the new category created in Joomla 2.5.
If you know which sermons belongs to which category, you can also use the new batch functionality to quickly assign the categories to multiple sermons at once.

You need to do this probably for speakers and series as well, as the same checks are done there.

I had indeed forgotten to set category for speakers, but I had set it for a handful of sermons. Speakers now have categories, and the sermons listed in the latest sermons module do play correctly, but the sermon list is still empty. I'll keep fiddling with it in the area of categories and let you know what I discover.

Okay - series need categories, too! Everything seems to be working - now that categories have been set for sermons, speakers, and series.

Thanks for your help!

Basically every item needs a valid category, or no category at all ("Root" or catid = 0). Then it works.

I'm glad it's working now

If you have further questions, just ask.

Dear Thomas,

Have you tried to integrate with jUpgrade for migration from Joomla 1.5?
I remember I have done a while back for Contact Enhanced and it wasn't hard to accomplish.

jUpgrade < redcomponent.com/jupgrade > migrates Joomla Categories, so you won't have to worry about it.

Best regards,

I had a look once at their documentation and didn't understand it. Maybe now when there are more examples I can have a look again.
Basically it would just have to install the new package and apply some SQL statements.