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.

unable to save speaker

More
14 Mar 2013 19:29 #3211 by Richard Papworth
When I attempt to modify information for a speaker, I get this error message:
"Save failed with the following error: SermonspeakerTableSpeaker: :store failed"
What might be the problem?

Please Log in or Create an account to join the conversation.

More
14 Mar 2013 22:26 #3213 by Thomas Hunziker
Which version of SermonSpeaker, Joomla and PHP are you using?

The exact SermonSpeaker version can be seen in the Extension Manager. The PHP version is shown in the Joomla System Information.

Also you can try to enable the error reporting in the Joomla configuration. Often this shows you more details.

Does this happen with any speaker or a specific one?

Please Log in or Create an account to join the conversation.

More
14 Mar 2013 23:48 #3217 by Richard Papworth
SermonSpeaker 4.4.11
Joomla 2.5.9 (we just upgraded the site from 1.5)
PHP 5.3.15

It happens whenever I attempt to save any of the speaker records. Here is an example of the error message:

Save failed with the following error: SermonspeakerTableSpeaker: :store failed
Unknown column 'modified' in 'field list' SQL=UPDATE `y8eij_sermon_speakers` SET `name`='Arden Kirchem',`website`='',`intro`='',`bio`='

\r\n

',`pic`='',`state`='1',`ordering`='27',`hits`='499',`created_by`='62',`created`='2013-03-14 22:46:38',`catid`='57',`alias`='arden-kirchem',`metakey`='',`metadesc`='',`home`='0',`checked_out`='288',`checked_out_time`='2013-03-14 22:46:27',`language`='*',`modified`='2013-03-14 22:46:38',`modified_by`='288' WHERE `id`='10013'

Richard

Please Log in or Create an account to join the conversation.

More
14 Mar 2013 23:54 #3218 by Richard Papworth
Thomas, the error occurs when I try to save an existing speaker. I am able to create and save a new speaker. But when I try to save this speaker record again, the error occurs.

Richard

Please Log in or Create an account to join the conversation.

More
15 Mar 2013 07:02 #3221 by Thomas Hunziker
That makes sense, yes. You updated directly to 4.4.11 ignoring the advice from the FAQ to update to 4.0 first. Now you got some missing database changes. Another user had the same problem two weeks ago: www.sermonspeaker.net/forum/SermonSpeake...e-and-migration.html .
So either start over or manually add the missing changes

Please Log in or Create an account to join the conversation.

More
15 Mar 2013 17:14 #3233 by Richard Papworth
Thomas, you are right. A consultant we hired neglected to install 4.0 before installing 4.4.11. What is the easiest option for fixing this problem? We have over 500 sermon files in our DB.

Please Log in or Create an account to join the conversation.

Time to create page: 0.180 seconds
Powered by Kunena Forum