Can't create a sermon

www.the-rock.org.uk/

Since migratating to Joomla 4 (and updateing all components and modules)  Ican't seem to upload sermons.

The error I get when I create one and hit 'save', is:

"Field 'modified_by' doesn't have a default value"

Any ideas anyone?

The error relates to the database field "modified_by" likely in the sermons table.
This field should have a default value "0" configured.

If you know how to work with phpMyAdmin or a similar tool, you can simply add that default value there.
If not, I can write a customised SermonSpeaker version which will adjust the database for you during the update.

Thanks Thomas,

I dabbled with MyPHP admin years and years ago, and I mean 'dabbled'! But I went in through my host's Control Panel and found teh likely tabelyou suggested, saw an 'insert' tab at the top and scroll down to find a 'miodified by' field taht was empty, so stuck a '0' in there, and... Bingo!!

All seems to eb working again now.

Thought I'd explain what I did in case anyone else has teh proble when migrating Joomla /updating the component.

Having said that, its not workin gagain! And the database field has reverted to being blank

Try installing this customised version of SermonSpeaker. It should set the default value during the update.
Hope this helps.
 

Thanks Thomas!