You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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 [email protected] 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 [email protected] 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!
The text was updated successfully, but these errors were encountered:
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 1User [email protected] 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 [email protected] 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!
The text was updated successfully, but these errors were encountered: