The problem lies in changing fields that are involved in key constraints.
ALTER TABLE dbmail_acl MODIFY COLUMN user_id BIGINT(20) UNSIGNED DEFAULT
0 NOT NULL;
doesn't work because in your system dbmail_users.user_id is defined as a
BIGINT(21) the definition on both ends of a foreign key need to
Thank you, I am working on it.
Dirce
>
> The problem lies in changing fields that are involved in key constraints.
>
>
> ALTER TABLE dbmail_acl MODIFY COLUMN user_id BIGINT(20) UNSIGNED DEFAULT
> 0 NOT NULL;
>
> doesn't work because in your system dbmail_users.user_id is defined as a
> BIGINT(21
I think Paul explained that sometimes the size of the integers were
different because they were not explicitly specified in the creation of
tables in dbmail 2.2, so perhaps different platforms or versions of Linux
used different sizes of integers.
Thanks,
Dirce
> the workaround is in the link yo
