# Question - How to add compliance package items (Got Error message)
**URL:** https://discussions.eramba.org/t/question-how-to-add-compliance-package-items-got-error-message/9112
**Category:** Forum - Software
**Tags:** bug, question
**Created:** [October 8, 2026, 7:06am UTC](https://discussions.eramba.org/t/question-how-to-add-compliance-package-items-got-error-message/9112 "2026-10-08T07:06:36Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Bastian](https://discussions.eramba.org/u/Bastian)
#### Post date: [October 8, 2026, 7:06am UTC](https://discussions.eramba.org/t/question-how-to-add-compliance-package-items-got-error-message/9112/1 "2026-10-08T07:06:36Z")
Hi there,
i am getting an error message when i try to add compliance package item:
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](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
---
### Author:  [@Adrian](https://discussions.eramba.org/u/Adrian)
#### Post date: [October 8, 2026, 8:24am UTC](https://discussions.eramba.org/t/question-how-to-add-compliance-package-items-got-error-message/9112/2 "2026-10-08T08:24:15Z")
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?
---
### Author:  [@Bastian](https://discussions.eramba.org/u/Bastian)
#### Post date: [October 8, 2026, 9:06am UTC](https://discussions.eramba.org/t/question-how-to-add-compliance-package-items-got-error-message/9112/3 "2026-10-08T09:06:36Z")
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](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.
---
### Author:  [@Bastian](https://discussions.eramba.org/u/Bastian)
#### Post date: [October 9, 2026, 4:51am UTC](https://discussions.eramba.org/t/question-how-to-add-compliance-package-items-got-error-message/9112/4 "2026-10-09T04:51:34Z")
Update: I have tried using a .csv import instead. The same error occurs.
---
### Author:  [@sam](https://discussions.eramba.org/u/sam)
#### Post date: [October 13, 2026, 11:47am UTC](https://discussions.eramba.org/t/question-how-to-add-compliance-package-items-got-error-message/9112/5 "2026-10-13T11:47:32Z")
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.
---
### Author:  [@Bastian](https://discussions.eramba.org/u/Bastian)
#### Post date: [October 13, 2026, 12:04pm UTC](https://discussions.eramba.org/t/question-how-to-add-compliance-package-items-got-error-message/9112/6 "2026-10-13T12:04:49Z")
Hi Sam,
thank you! Changing the file permission to write-protected solved the problem as described.
😀
Best Regards
Bastian