@yvesh @laoneo any ideas on this?

It should be about this line: https://github.com/joomla/joomla-cms/blob/staging/installation/sql/mysql/joomla.sql#L1474 as there is no value for content in that module and the strict mode of mysql fires here. I would expect that we need to set a default value for the content field on the save method.

I got similar errors when discovering extensions in Joomla. Should the default value not being defined in the table schema?

Can't confirm:

System information (as much as possible)

Joomla! 4.0.0-dev
macOS Sierra, 10.12.3
Firefox 52.0 (64-bit)
PHP 7.0.15

MAMP 4.1.1

• PHP 7.0.15
• MySQLi 5.6.35

Could not re-procedure the issue. The error message indicate that the content field of #__modules doesn't have default value. However, looking at this https://github.com/joomla/joomla-cms/blob/4.0-dev/installation/sql/mysql/joomla.sql#L1472 , I see that the content field has default value already, so this issue should not happen

Interesting... In my db the content field has no default value.

I've certainly not tampered with the db after the initial installation.

The footer module has been removed in J4 in favour of using a custom module instead. I've tested this on some other modules and cannot replicate it anymore.

If anyone else is still able to replicate, can they share which module they tested it with, else this can be closed.

I can confirm this.

Only on modules discovered. Same modules save fine if installed via installer.

In mysql "BLOB/TEXT" column can't have a default value, except NULL:).

https://stackoverflow.com/questions/3466872/why-cant-a-text-column-have-a-default-value-in-mysql

Default value does not work.
The solution is to add empty string in php code or allow column to be NULL.

This doesn't appear to be an issue anymore. Saving a new module or discovering one both work.

@franz-wohlkoenig

Set to "closed" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/14401

closed as stated above.

I'm still getting this issue with discovered modules

Set to "open" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/14401

reopened as stated above.

I cannot replicate this on new or discovered modules

@ciar4n It seems to be only you. Maybe it is an issue with the module. I am going to close this for now but if you still have an issue can you please re-open it and share the module

Does this pr help #19836 ?

J4 alpha 3 I solved this in a simple way

ALTER TABLE #__modules CHANGE content content TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';