Hello,
When I try to create a new user with the script I get the following error:
ERROR 1366 (22007) at line 1: Incorrect integer value: 'true' for column vmail.accounts.enabled at row 1
User test@example.com has been added!
I can set aliases, add domains and change quotas with no issues, yet can't add users.
I have then run this mysql query:
ALTER TABLE accounts MODIFY enabled BIT default 1 NOT NULL;
And now when I try to create a user get the following error:
ERROR 1406 (22001): Data too long for column 'enabled' at row 1
User test@example.com has been added!
Then I've read that atually Bit is not boolean, so I returned to boolean and getting the original message again.
Any ideas how to solve it? Not very experienced with MySQL and a bit afraid of breaking the whole db. I am using Debian 10 and MariaDB 10.3.17
Thanks a lot!
Hello,
When I try to create a new user with the script I get the following error:
ERROR 1366 (22007) at line 1: Incorrect integer value: 'true' for column
vmail.accounts.enabledat row 1User test@example.com has been added!
I can set aliases, add domains and change quotas with no issues, yet can't add users.
I have then run this mysql query:
ALTER TABLE accounts MODIFY enabled BIT default 1 NOT NULL;
And now when I try to create a user get the following error:
ERROR 1406 (22001): Data too long for column 'enabled' at row 1
User test@example.com has been added!
Then I've read that atually Bit is not boolean, so I returned to boolean and getting the original message again.
Any ideas how to solve it? Not very experienced with MySQL and a bit afraid of breaking the whole db. I am using Debian 10 and MariaDB 10.3.17
Thanks a lot!