Support for SermonSpeaker 4.x is canceled as it is for Joomla 2.5. I will gladly assist you with minor issues but I will not fix any bugs anymore in this releases.
The fix is to upgrade to SermonSpeaker 5.x and Joomla 3.x, which is better anyway.
The fix is to upgrade to SermonSpeaker 5.x and Joomla 3.x, which is better anyway.
Migration from 3.4.3
- Thomas Hunziker
-
- Offline
- Administrator
-
Less
More
23 Mar 2012 19:29 #1682
by Thomas Hunziker
Replied by Thomas Hunziker on topic Re: Migration from 3.4.3
Apology is accepted
![:-) :-)](/media/kunena/emoticons/9.png)
Please Log in or Create an account to join the conversation.
- Eric Davis
-
- Offline
- New Member
-
Less
More
- Posts: 10
- Thank you received: 0
23 Mar 2012 23:12 - 24 Mar 2012 00:50 #1685
by Eric Davis
Replied by Eric Davis on topic Re: Migration from 3.4.3
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?
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?
Last edit: 24 Mar 2012 00:50 by Thomas Hunziker. Reason: Admin: Removed sensible informations
Please Log in or Create an account to join the conversation.
- Thomas Hunziker
-
- Offline
- Administrator
-
24 Mar 2012 00:48 #1687
by Thomas Hunziker
Replied by Thomas Hunziker on topic Re: Migration from 3.4.3
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
See here for the solution of your problem:
www.sermonspeaker.net/forum/SermonSpeake...tml?limit=6&start=34
Please Log in or Create an account to join the conversation.
- Mike Gay
-
- Visitor
-
20 Oct 2012 22:47 #2670
by Mike Gay
Replied by Mike Gay on topic Migration from 3.4.3
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
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
Please Log in or Create an account to join the conversation.
- Mike Gay
-
- Visitor
-
20 Oct 2012 22:55 #2671
by Mike Gay
Replied by Mike Gay on topic Re: Migration from 3.4.3
Just noticed I'm on a version later than 4.0 I hope that's the problem.
Please Log in or Create an account to join the conversation.
- Thomas Hunziker
-
- Offline
- Administrator
-
20 Oct 2012 23:08 #2672
by Thomas Hunziker
If you try again make sure to uninstall SermonSpeaker and start from the beginning again.
Replied by Thomas Hunziker on topic Re: Migration from 3.4.3
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.Mike Gay wrote: Just noticed I'm on a version later than 4.0 I hope that's the problem.
If you try again make sure to uninstall SermonSpeaker and start from the beginning again.
Please Log in or Create an account to join the conversation.
Time to create page: 0.202 seconds