Migration problem so close

I used SP Upgrade to upgrade my Joomla 1.5 site to Joomla 2.5. After manually importing the tables into my new DB and then reinstalling SermonSpeaker 4.5.6 all my sermons, speakers and series are there and I changed the category from uncategorized to Weekly Messages as it should be. Created menu item for Semons List but getting Sorry No Sermons message.

When I try to add a Latest Sermons module to our homepage like we have on the old site, I see these error messages in the module

Unknown column 'title' in 'field list' SQL=SELECT `id`, `title` FROM jos_sermon_speakers ORDER BY title ASC
Unknown column 'title' in 'field list' SQL=SELECT `id`, `title` FROM jos_sermon_series ORDER BY title ASC

Wondering if there is a problem in the DB that might be causing my problems. My site ssfbclive.com (old Joomla 1.5) and ssfbclive.com/j25 new upgraded site

Any ideas or help would be greatly appeciated. Thanks.

Hi Cindy

The message "Sorry, No Sermons found" usually indicates that somethign with the categories is not right. Check that you have assigned a category to each sermon, series and speaker.

The "unknown column 'title'" indicates that you have the newest latest sermons module (5.0), which is meant to be compatible with SermonSpeaker 5.0.
Since you are using SermonSpeaker 4.5.6, you need an older version. Try with this one instead: www.sermonspeaker.net/download/module-la...t-sermons-4-5-0.html

Thank you SO MUCH. I had to open speakers, series and every sermon and just click save for it to re-attach to the category but once I did this...it's back. Happy Day. Thanks again.

The batch processing would probably have worked as well

I'm glad it was an easy fix