Can not confirm.

Digging a little bit deeper, in administrator/components/com_categories/Model/CategoryModel.php Line 602 I get the following error: "Field 'description' doesn't have a default value"

With this message I found an older issue: #18993

I am using mariadb 10.1.36. According to https://mariadb.com/kb/en/library/sql-mode/#strict-mode strict mode is enabled per default only from 10.2.4 onwards.

Now I have to find out how to set strict mode for mariadb 10.1. These two commands did not work:
SET sql_mode = 'STRICT_TRANS_TABLES';
SET GLOBAL sql_mode = 'STRICT_TRANS_TABLES';

Can't confirm Issue. Created Category "new" in Article-View is assigned to Article and shown in Categories.

System Information

I think you didn´t read my last message in which I analyzed the origin of the problem.

@waader i read your last Message but i couldn't get your Issue described in opening Comment.

In mariadb strict-mode is set by default from version 10.2.4 onwards (https://mariadb.com/kb/en/library/sql-mode/#strict-mode).
So I tested with a more current version (10.4.8) and now the adhoc creation of a category works.

@richard67: Maybe it should be documented that older mariadb versions could cause problems with J4.

In mariadb strict-mode is set by default from version 10.2.4 onwards (https://mariadb.com/kb/en/library/sql-mode/#strict-mode).
So I tested with a more current version (10.4.8) and now the adhoc creation of a category works.

@richard67: Maybe it should be documented that older mariadb versions could cause problems with J4.

@wilsonge Maybe we should check and if necessary increase minimum version requirement for MariaDB in the DB driver?

If I read this correctly the issue is that we require strict_mode and with 5 year old (but still supported) versions of mariadb it is not enabled by default. If that is correct then either

1. We document that strict mode is required in the system requirements
2. If possible check for strict mode in the installer

@richard67 @wilsonge is this still an issue to resolve?

I don't know.

I am referring to the comments about mariadb

#25903 (comment)
#25903 (comment)

@brianteeman I wish I could help here, but to be honest, I did not really understand these comments. From my experience I would expect problems to appear when strict mode is on and not when it's off, and the error message fits to that, but here it seems to be vice versa, i.e. problems coming with the older version where strict mode was not enabled by default, and that confuses me.

So either I understand this issue completely wrong, or I am at least missing something.

@richard67 that is my reading of the op issue as well.

Joomla 4 was released more than one year ago and we didn't receive any other report, so I assume this was solved elsewhere. Therefore, I'm closing this issue. Feel free to re-open if the issue still valid.