Error we get when we try to “Update non-conflicting” metaTemplate that contains conflicts

[jacobkarapatakis]

When we edit a metaTemplate configuration/definition and go to the page https://cerebrate.fqdn/metaTemplates/view/203# to view it, the system shows us three options:
i) Delete conflicting fields,
ii) Create new template
iii) Update non-conflicting

when we select “Update non-conflicting”, the system throws an error:
`
2023-03-01 00:00:00 error: [PDOException] SQLSTATE[HY000]: General error: 1364 Field 'meta_template_directory_id' doesn't have a default value in /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php on line 39
Stack Trace:

• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php:39
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Connection.php:360
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Core/Retry/CommandRetry.php:70
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Connection.php:363
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Query.php:254
• /var/www/cerebrate/vendor/cakephp/cakephp/src/ORM/Table.php:2091
• /var/www/cerebrate/vendor/cakephp/cakephp/src/ORM/Table.php:1984
• /var/www/cerebrate/vendor/cakephp/cakephp/src/ORM/Table.php:1883
• /var/www/cerebrate/vendor/cakephp/cakephp/src/ORM/Table.php:1570
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Database/Connection.php:709
• /var/www/cerebrate/vendor/cakephp/cakephp/src/ORM/Table.php:1571
• /var/www/cerebrate/vendor/cakephp/cakephp/src/ORM/Table.php:1884
• /var/www/cerebrate/src/Model/Table/MetaTemplatesTable.php:794
• /var/www/cerebrate/src/Model/Table/MetaTemplatesTable.php:930
• /var/www/cerebrate/src/Model/Table/MetaTemplatesTable.php:867
• /var/www/cerebrate/src/Model/Table/MetaTemplatesTable.php:191
• /var/www/cerebrate/src/Model/Table/MetaTemplatesTable.php:158
• /var/www/cerebrate/src/Controller/MetaTemplatesController.php:74
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Controller/Controller.php:547
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Controller/ControllerFactory.php:139
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Controller/ControllerFactory.php:114
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/BaseApplication.php:320
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:86
• /var/www/cerebrate/vendor/cakephp/authentication/src/Middleware/AuthenticationMiddleware.php:124
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:82
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Middleware/BodyParserMiddleware.php:162
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:82
• /var/www/cerebrate/vendor/admad/cakephp-social-auth/src/Middleware/SocialAuthMiddleware.php:221
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:82
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:86
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Middleware/CsrfProtectionMiddleware.php:174
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:82
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:67
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Routing/Middleware/RoutingMiddleware.php:192
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:82
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Routing/Middleware/AssetMiddleware.php:68
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:82
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Error/Middleware/ErrorHandlerMiddleware.php:131
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:82
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Runner.php:67
• /var/www/cerebrate/vendor/cakephp/cakephp/src/Http/Server.php:90
• /var/www/cerebrate/webroot/index.php:40

Request URL: /metaTemplates/update/203
Referer URL: https://cerebrate.melicertes.eu/metaTemplates/view/203
Client IP: 192.168.0.252
`

[mokaddem]

Tried to replicate the issue on develop but didn't manage to.
Could you provide the following information to help me debug this issue?

1. Commit ID of the instance
2. The dump of the template you are trying to update /metaTemplates/view/[template_id].json
3. The dump of the new template you are trying to update to (located on the disk)
4. The dump of all the known template /metaTemplateNameDirectory/index.json
5. The log entry indicating the reason of the fail save (starts with Could not save meta_template_directory. Reasons:)

Thanks in advance!