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.

Datbase Error: Unknown column 'introtext'

More
21 Feb 2012 20:10 - 21 Feb 2012 20:23 #1522 by Derek Wingfield
Datbase Error: Unknown column 'introtext' was created by Derek Wingfield
Hello,

I just installed SermonSpeaker 4.3 and am running into some errors when trying to save new speakers, series, sermons, etc. I'm running Joomla 2.5.

When creating a new speaker, I get the following message when trying to save:
Code:
Save failed with the following error: SermonspeakerTableSpeaker: :store failed Unknown column 'introtext' in 'field list' SQL=INSERT INTO `jom_sermon_speakers` (`id`,`name`,`alias`,`website`,`intro`,`bio`,`pic`,`state`,`ordering`,`hits`,`created`,`created_by`,`catid`,`metakey`,`metadesc`,`introtext`,`fulltext`) VALUES ('0','Todd West','todd-west','','','','','1','2','','2012-02-21 18:56:39','43','','','','','')

Likewise, the following error's returned when trying to save a new sermon:
Code:
Save failed with the following error: SermonspeakerTableSermon: :store failed Unknown column 'introtext' in 'field list' SQL=INSERT INTO `jom_sermon_sermons` (`id`,`speaker_id`,`series_id`,`audiofile`,`videofile`,`picture`,`sermon_title`,`alias`,`sermon_number`,`sermon_scripture`,`sermon_date`,`sermon_time`,`notes`,`state`,`ordering`,`hits`,`created_by`,`created`,`podcast`,`addfile`,`addfileDesc`,`catid`,`metakey`,`metadesc`,`introtext`,`fulltext`) VALUES ('0','1','1','','','','Forward Progress: The Hand of God','forward-progress-the-hand-of-god','','','2012-02-21 19:06:15','00:00:00','','1','0','','43','2012-02-21 19:06:15','1','','','','','','','')

It appears it's something to do with my database, but I'm a SQL dummy, so any help will need to be spelled out like I'm a second-grader, please. =)

Thanks in advance for any light this community can shed!

Derek
Last edit: 21 Feb 2012 20:23 by Derek Wingfield.

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

More
21 Feb 2012 21:51 #1524 by Thomas Hunziker
Replied by Thomas Hunziker on topic Re: Datbase Error: Unknown column 'introtext'
Did you do a fresh install or was it an upgrade from a previous version?

I'm asking because to my knowledge there isn't a column named "introtext" in SermonSpeaker, especially not in the sermons table. So I'm wondering where this error may come from myself.

One idea would be that you have some plugin installed which does something during saving. The "introtext" and "fulltext" columns sound like something from the content (article) component. So if a plugin acts wierd and adds those to a save, that would be an explanation.
You could try disabling 3rd party plugins to see if one is the source.

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

More
21 Feb 2012 22:11 #1526 by Derek Wingfield
Replied by Derek Wingfield on topic Re: Datbase Error: Unknown column 'introtext'
That was it exactly. A content plugin called ECrawler turned out to be the culprit - I disabled it and SermonSpeaker began working as expected immediately.

Thanks for the assist!

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

Time to create page: 0.262 seconds
Powered by Kunena Forum