Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error adding new users #5

Open
Archehandoro opened this issue Sep 16, 2019 · 0 comments
Open

Error adding new users #5

Archehandoro opened this issue Sep 16, 2019 · 0 comments

Comments

@Archehandoro
Copy link

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!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant