Question - How to add compliance package items (Got Error message)

Forum - Software
,
1

Hi there,

i am getting an error message when i try to add compliance package item:

grafik
grafik1247×301 14.7 KB

The mysql log:

IP(hidden) - - [08/Oct/2026:07:01:00 +0000] “GET /laravel/api/compliance-package-items/index?select%5BCompliancePackage-package_id%5D%5Bdisplay%5D=default&select%5BCompliancePackage-package_id%5D%5Bwrap%5D=truncate&select%5BCompliancePackage-package_id%5D%5Bfrozen%5D=false&select%5BCompliancePackage-name%5D%5Bdisplay%5D=default&select%5BCompliancePackage-name%5D%5Bwrap%5D=truncate&select%5BCompliancePackage-name%5D%5Bfrozen%5D=false&select%5BCompliancePackage-description%5D%5Bdisplay%5D=default&select%5BCompliancePackage-description%5D%5Bwrap%5D=truncate&select%5BCompliancePackage-description%5D%5Bfrozen%5D=false&select%5Bitem_id%5D%5Bdisplay%5D=default&select%5Bitem_id%5D%5Bwrap%5D=truncate&select%5Bitem_id%5D%5Bfrozen%5D=false&select%5Bname%5D%5Bdisplay%5D=default&select%5Bname%5D%5Bwrap%5D=truncate&select%5Bname%5D%5Bfrozen%5D=false&select%5Bdescription%5D%5Bdisplay%5D=default&select%5Bdescription%5D%5Bwrap%5D=truncate&select%5Bdescription%5D%5Bfrozen%5D=false&select%5Baudit_questionaire%5D%5Bdisplay%5D=default&select%5Baudit_questionaire%5D%5Bwrap%5D=truncate&select%5Baudit_questionaire%5D%5Bfrozen%5D=false&filter%5BCompliancePackage-compliance_package_regulator_id%5D%5Boperator%5D=$in&filter%5BCompliancePackage-compliance_package_regulator_id%5D%5Bvalue%5D%5B0%5D=1&filterOperator=and&quickFilter=&page=1 HTTP/1.1” 200 988 “https://localhost:8443/compliance-package-items” "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:157.0) Gecko/20100101 Firefox/157.0

I run eramba via docker and also have fresh installed two times. I always getting these error message.

Any help would be useful, thank you very much in advance.

Best Regards
Bastian

2

Hi Are you running Community or Enterprise, and is this on version 3.31.0?

When the error triggers, could you check inside the container at /var/www/eramba/app/upgrade/logs/error.log to see if any error is recorded there?

3

Hi Adrian,

i am running the community edition 3.31.0.

This is the output from the error log:

2026-10-08 08:57:09 error: [Cake\Database\Exception\QueryException] SQLSTATE[HY000]: General error: 1364 Field ‘description’ doesn’t have a default value
Query: INSERT INTO compliance_managements (compliance_package_item_id, efficacy, created, modified) VALUES (3, 0, ‘2026-10-08 08:57:09’, ‘2026-10-08 08:57:09’) in /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Database/Driver.php on line 382
Stack Trace:

  • CORE/src/Database/Driver.php:329
  • CORE/src/Database/Driver/Mysql.php:183
  • CORE/src/Database/Connection.php:280
  • CORE/src/Core/Retry/CommandRetry.php:71
  • CORE/src/Database/Connection.php:280
  • CORE/src/Database/Query.php:223
  • CORE/src/ORM/Table.php:2163
  • CORE/src/ORM/Table.php:2056
  • CORE/src/ORM/Table.php:1951
  • CORE/src/ORM/Table.php:1582
  • CORE/src/Database/Connection.php:649
  • CORE/src/ORM/Table.php:1582
  • CORE/src/ORM/Table.php:1950
  • CORE/src/ORM/Association/HasOne.php:136
  • CORE/src/ORM/AssociationCollection.php:321
  • CORE/src/ORM/AssociationCollection.php:291
  • CORE/src/ORM/AssociationCollection.php:251
  • CORE/src/ORM/Table.php:2085
  • CORE/src/ORM/Table.php:2062
  • CORE/src/ORM/Table.php:1951
  • CORE/src/ORM/Table.php:1582
  • CORE/src/Database/Connection.php:649
  • CORE/src/ORM/Table.php:1582
  • CORE/src/ORM/Table.php:1950
  • APP/Action/AddAction.php:115
  • ROOT/vendor/friendsofcake/crud/src/Action/BaseAction.php:70
  • ROOT/vendor/friendsofcake/crud/src/Controller/Component/CrudComponent.php:246
  • APP/Controller/CompliancePackageItemsController.php:144
  • CORE/src/Controller/Controller.php:505
  • ROOT/vendor/friendsofcake/crud/src/Controller/ControllerTrait.php:73
  • CORE/src/Controller/ControllerFactory.php:166
  • CORE/src/Controller/ControllerFactory.php:141
  • CORE/src/Http/BaseApplication.php:362
  • CORE/src/Http/Runner.php:86
  • CORE/src/Http/Middleware/CsrfProtectionMiddleware.php:169
  • CORE/src/Http/Runner.php:82
  • ROOT/vendor/cakephp/authorization/src/Middleware/AuthorizationMiddleware.php:116
  • CORE/src/Http/Runner.php:82
  • ROOT/vendor/cakephp/authentication/src/Middleware/AuthenticationMiddleware.php:87
  • CORE/src/Http/Runner.php:82
  • CORE/src/Http/Middleware/BodyParserMiddleware.php:162
  • CORE/src/Http/Runner.php:82
  • APP/Routing/Middleware/RequestIdentifierMiddleware.php:35
  • CORE/src/Http/Runner.php:82
  • CORE/src/Routing/Middleware/RoutingMiddleware.php:118
  • CORE/src/Http/Runner.php:82
  • APP/Routing/Middleware/CorsMiddleware.php:41
  • CORE/src/Http/Runner.php:82
  • CORE/src/Routing/Middleware/AssetMiddleware.php:69
  • CORE/src/Http/Runner.php:82
  • CORE/src/Error/Middleware/ErrorHandlerMiddleware.php:115
  • CORE/src/Http/Runner.php:82
  • APP/Application.php:475
  • CORE/src/Http/Middleware/ClosureDecoratorMiddleware.php:67
  • CORE/src/Http/Runner.php:82
  • APP/Application.php:541
  • CORE/src/Http/Middleware/ClosureDecoratorMiddleware.php:67
  • CORE/src/Http/Runner.php:82
  • CORE/src/Http/Middleware/SecurityHeadersMiddleware.php:274
  • CORE/src/Http/Runner.php:82
  • ROOT/plugins/Translations/src/Middleware/ActiveLanguageMiddleware.php:36
  • CORE/src/Http/Runner.php:82
  • APP/Application.php:519
  • CORE/src/Http/Middleware/ClosureDecoratorMiddleware.php:67
  • CORE/src/Http/Runner.php:82
  • APP/Middleware/MaintenanceMiddleware.php:29
  • CORE/src/Http/Runner.php:82
  • CORE/src/Http/Runner.php:60
  • CORE/src/Http/Server.php:104
  • ROOT/webroot/index.php:55
  • [main]:

Caused by: [PDOException] SQLSTATE[HY000]: General error: 1364 Field ‘description’ doesn’t have a default value in /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Database/Statement/Statement.php on line 146
Stack Trace:

  • CORE/src/Database/Statement/Statement.php:146
  • CORE/src/Database/Driver.php:327
  • CORE/src/Database/Driver/Mysql.php:183
  • CORE/src/Database/Connection.php:280
  • CORE/src/Core/Retry/CommandRetry.php:71
  • CORE/src/Database/Connection.php:280
  • CORE/src/Database/Query.php:223
  • CORE/src/ORM/Table.php:2163
  • CORE/src/ORM/Table.php:2056
  • CORE/src/ORM/Table.php:1951
  • CORE/src/ORM/Table.php:1582
  • CORE/src/Database/Connection.php:649
  • CORE/src/ORM/Table.php:1582
  • CORE/src/ORM/Table.php:1950
  • CORE/src/ORM/Association/HasOne.php:136
  • CORE/src/ORM/AssociationCollection.php:321
  • CORE/src/ORM/AssociationCollection.php:291
  • CORE/src/ORM/AssociationCollection.php:251
  • CORE/src/ORM/Table.php:2085
  • CORE/src/ORM/Table.php:2062
  • CORE/src/ORM/Table.php:1951
  • CORE/src/ORM/Table.php:1582
  • CORE/src/Database/Connection.php:649
  • CORE/src/ORM/Table.php:1582
  • CORE/src/ORM/Table.php:1950
  • APP/Action/AddAction.php:115
  • ROOT/vendor/friendsofcake/crud/src/Action/BaseAction.php:70
  • ROOT/vendor/friendsofcake/crud/src/Controller/Component/CrudComponent.php:246
  • APP/Controller/CompliancePackageItemsController.php:144
  • CORE/src/Controller/Controller.php:505
  • ROOT/vendor/friendsofcake/crud/src/Controller/ControllerTrait.php:73
  • CORE/src/Controller/ControllerFactory.php:166
  • CORE/src/Controller/ControllerFactory.php:141
  • CORE/src/Http/BaseApplication.php:362
  • CORE/src/Http/Runner.php:86
  • CORE/src/Http/Middleware/CsrfProtectionMiddleware.php:169
  • CORE/src/Http/Runner.php:82
  • ROOT/vendor/cakephp/authorization/src/Middleware/AuthorizationMiddleware.php:116
  • CORE/src/Http/Runner.php:82
  • ROOT/vendor/cakephp/authentication/src/Middleware/AuthenticationMiddleware.php:87
  • CORE/src/Http/Runner.php:82
  • CORE/src/Http/Middleware/BodyParserMiddleware.php:162
  • CORE/src/Http/Runner.php:82
  • APP/Routing/Middleware/RequestIdentifierMiddleware.php:35
  • CORE/src/Http/Runner.php:82
  • CORE/src/Routing/Middleware/RoutingMiddleware.php:118
  • CORE/src/Http/Runner.php:82
  • APP/Routing/Middleware/CorsMiddleware.php:41
  • CORE/src/Http/Runner.php:82
  • CORE/src/Routing/Middleware/AssetMiddleware.php:69
  • CORE/src/Http/Runner.php:82
  • CORE/src/Error/Middleware/ErrorHandlerMiddleware.php:115
  • CORE/src/Http/Runner.php:82
  • APP/Application.php:475
  • CORE/src/Http/Middleware/ClosureDecoratorMiddleware.php:67
  • CORE/src/Http/Runner.php:82
  • APP/Application.php:541
  • CORE/src/Http/Middleware/ClosureDecoratorMiddleware.php:67
  • CORE/src/Http/Runner.php:82
  • CORE/src/Http/Middleware/SecurityHeadersMiddleware.php:274
  • CORE/src/Http/Runner.php:82
  • ROOT/plugins/Translations/src/Middleware/ActiveLanguageMiddleware.php:36
  • CORE/src/Http/Runner.php:82
  • APP/Application.php:519
  • CORE/src/Http/Middleware/ClosureDecoratorMiddleware.php:67
  • CORE/src/Http/Runner.php:82
  • APP/Middleware/MaintenanceMiddleware.php:29
  • CORE/src/Http/Runner.php:82
  • CORE/src/Http/Runner.php:60
  • CORE/src/Http/Server.php:104
  • ROOT/webroot/index.php:55
  • [main]:

Request URL: /compliance-package-items/add?modalId=1&_=1791442383040
Referer URL: https://localhost:8443/compliance-package-items
Client IP: x

I have used any given field in the tabs “General” and “Compliance Package Item” and filled in test-data. The error remain.

4

Update: I have tried using a .csv import instead. The same error occurs.

5

Hello Bastian,

This error appears when MySQL runs in strict mode. Our Docker setup sets sql_mode=NO_ENGINE_SUBSTITUTION in mysql/conf.d/custom.cnf, so it looks like MySQL isn’t loading that file. You can check with:
docker exec -it mysql mysql -u root -p -e "SELECT @@GLOBAL.sql_mode"

If it shows STRICT_TRANS_TABLES, check “docker logs mysql” for a warning about custom.cnf. MySQL ignores config files it can’t read or that everyone can write to, which is common on Windows hosts. Fix the file permissions and restart the containers.

6

Hi Sam,

thank you! Changing the file permission to write-protected solved the problem as described.

:grinning_face:

Best Regards
Bastian