Migration from 3.4.3

Apology is accepted

Thank you Thomal.

Now, while I enjoy this fat plate of "Crow Under Glass" (not bad when you pray over it first and add a pinch of lemon pepper and sugar glaze with sea salt).

I followed the instruction to the letter and I still get a following two 500 errors:

This one is from clicking the Speakers Tab:

500 - An error has occurred.
Unknown column 'speakers.home' in 'field list' ...


This one come from clicking the Series Tab:

500 - An error has occurred.

Unknown column 'series.home' in 'field list' ...

My sermon list shows up just fine as does the catagories list. I just can't get the Speakers and Series to show up or give the screen to build them from scratch. Can you please tell me what I have done wrong?

Anybody want a crow's foot for their soup later?

I take it you used SermonSpeaker 4.3 for the upgrade instead of SermonSpeaker 4.0?

See here for the solution of your problem:
www.sermonspeaker.net/forum/SermonSpeake...tml?limit=6&start=34

Hi Guys - I have followed all the instructions given for migrating to Sermon Speaker 4 but nothing works - this is the error message I get:

500 - An error has occurred.

Unknown column 'speakers.language' in 'field list' SQL=SELECT speakers.id, speakers.name, speakers.catid, speakers.created_by, speakers.language, speakers.hits, speakers.home, speakers.pic, speakers.website, speakers.alias, speakers.state, speakers.ordering, speakers.checked_out, speakers.checked_out_time,l.title AS language_title,uc.name AS editor,c.title AS category_title FROM `jos_sermon_speakers` AS speakers LEFT JOIN `jos_languages` AS l ON l.lang_code = speakers.language LEFT JOIN jos_users AS uc ON uc.id = speakers.checked_out LEFT JOIN jos_categories AS c ON c.id = speakers.catid WHERE (speakers.state IN (0, 1)) ORDER BY speakers.name asc Unknown column 'speakers.language' in 'field list' SQL=SELECT speakers.id, speakers.name, speakers.catid, speakers.created_by, speakers.language, speakers.hits, speakers.home, speakers.pic, speakers.website, speakers.alias, speakers.state, speakers.ordering, speakers.checked_out, speakers.checked_out_time,l.title AS language_title,uc.name AS editor,c.title AS category_title FROM `jos_sermon_speakers` AS speakers LEFT JOIN `jos_languages` AS l ON l.lang_code = speakers.language LEFT JOIN jos_users AS uc ON uc.id = speakers.checked_out LEFT JOIN jos_categories AS c ON c.id = speakers.catid WHERE (speakers.state IN (0, 1)) ORDER BY speakers.name asc LIMIT 0, 20 Unknown column 'speakers.language' in 'field list' SQL=SELECT speakers.id, speakers.name, speakers.catid, speakers.created_by, speakers.language, speakers.hits, speakers.home, speakers.pic, speakers.website, speakers.alias, speakers.state, speakers.ordering, speakers.checked_out, speakers.checked_out_time,l.title AS language_title,uc.name AS editor,c.title AS category_title FROM `jos_sermon_speakers` AS speakers LEFT JOIN `jos_languages` AS l ON l.lang_code = speakers.language LEFT JOIN jos_users AS uc ON uc.id = speakers.checked_out LEFT JOIN jos_categories AS c ON c.id = speakers.catid WHERE (speakers.state IN (0, 1)) ORDER BY speakers.name asc

Any help would be much appreciated
Every Blessing
Mike

Just noticed I'm on a version later than 4.0 I hope that's the problem.

Mike Gay wrote: Just noticed I'm on a version later than 4.0 I hope that's the problem.

That could well be the problem. The migration is tested only with SermonSpeaker 4.0. Later releases should work but it's not tested and thus may fail due to a bug.
If you try again make sure to uninstall SermonSpeaker and start from the beginning again.