Quota = -1, but gets error: "maildir over quota"

[Thomas Jensen]

One of my mailaccounts gets this error:

temporary failure. Command output: maildrop: maildir over
quota.

I've set the quota to "-1", but it doesn't seems to help

A sidestep:
I've often observed that when some limits (client limits) is set to -1, they are reset automatically to 0.

[Thomas Jensen]

I've discovered that all older domains are added with another sys_perm_group in mail_domain than the new one.

domain_id sys_userid sys_groupid sys_perm_user sys_perm_group sys_perm_other server_id domain active
1 1 3 riud ruid 1 old_domain.dk y
2 1 2 riud ru 1 newer_domain.dk y
so, ruid is now ru?

in the mail_user table, the quota field for the specific mailbox is -1048576.

[till]

I've discovered that all older domains are added with another sys_perm_group in mail_domain than the new one.

The permissions depend on the fact which user has created the domains. If they are created by the admin, the group permissions are ru to prevent users from deleting domains that they had not created. But this is not realted to quota, as postfix and courier dont care about the ispconfig permission fields.

in the mail_user table, the quota field for the specific mailbox is -1048576.

This explains your problem as -1048576 is no valid value for this field. Valid values are only positive values or -1.

[Thomas Jensen]

Okay, then i'll change it in PHPmyadmin, but, all the rows have that problem, and that's even after i set Quota = -1 in the control panel.

Update:
I did: UPDATE `mail_user` SET `quota` = -1 WHERE `quota` < -1, which worked fine.
But now, in the CP, the quota is shown as -9.53674316406E-7.

[till]

I have no idea how this can happen most likely there is a problem with your mysql databse, e.g with the charsets or connection from mysql to php. as ispconfig is not converting numbers in any way, they were directly output from the DB. You should try to find out waht you changed in your configuration right before the problem started.

[Thomas Jensen]

I haven't changed anything i know of...

The charset of all tables is: utf8_general_ci

What can i do?

[till]

I have no idea. I can not even think of a logical reason how this can happen.

The number -9.53674316406E-7 is equal to -1 kilobyte, but how shall this come together in this case??

What is the type of the column "quota" in the mail_user table?

[Thomas Jensen]

The type is: int(11), but it has no Collation.

[till]

Thats OK. I was able to reproduce this now on one of my systems. I will make a patch for it.

[till]

I think I've found the problem.

Please replace the file /usr/local/ispconfig/interface/web/mail/mail_user_edit.php with the file in the attached .zip file and check if this solves the problem.