[GH-ISSUE #543] Internal Server Error/Duplicate entry: when try to update an mailbox #519

New issue

Closed

opened 2026-02-27 11:12:11 +03:00 by kerem · 4 comments

kerem commented

2026-02-27 11:12:11 +03:00

Owner

Originally created by @ghost on GitHub (Apr 3, 2014).
Original GitHub issue: https://github.com/modoboa/modoboa/issues/543

Hi,

From the super admin panel, when I try to update an mailbox (change the quota or anything) and the domain contains more than one account, I get the following error:

http://pastie.org/private/pynb5box1agvpgsykdla

On the other hand, when I try to update an mailbox that have only one account per domain, then everything is updated fine.

My setup is the same as posted here (actually, it's the same server): https://github.com/tonioo/modoboa/issues/185#issuecomment-39299680

Thanks in advance for any help you are able to provide.

Originally created by @ghost on GitHub (Apr 3, 2014). Original GitHub issue: https://github.com/modoboa/modoboa/issues/543 Hi, From the super admin panel, when I try to update an mailbox (change the quota or anything) and the domain contains more than one account, I get the following error: http://pastie.org/private/pynb5box1agvpgsykdla On the other hand, when I try to update an mailbox that have only one account per domain, then everything is updated fine. My setup is the same as posted here (actually, it's the same server): https://github.com/tonioo/modoboa/issues/185#issuecomment-39299680 Thanks in advance for any help you are able to provide.

kerem

2026-02-27 11:12:11 +03:00

closed this issue
added the
bug
label

kerem commented

2026-02-27 11:12:11 +03:00

Author

Owner

@tonioo commented on GitHub (Apr 3, 2014):

Hi,

can you take a look at the admin_quota table? (You should see records with empty 'mailbox_id' fields, which is not expected)

@tonioo commented on GitHub (Apr 3, 2014): Hi, can you take a look at the admin_quota table? (You should see records with empty 'mailbox_id' fields, which is not expected)

kerem commented

2026-02-27 11:12:11 +03:00

Author

Owner

@ghost commented on GitHub (Apr 3, 2014):

Yes, some mbox_id is NULL.

@ghost commented on GitHub (Apr 3, 2014): Yes, some mbox_id is NULL.

kerem commented

2026-02-27 11:12:11 +03:00

Author

Owner

@tonioo commented on GitHub (Apr 3, 2014):

Ok, so it means dovecot created those records before modoboa, which is embarassing. This error only occurs when MySQL in in use... you can fix it by filling empty mbox_id fields with the appropriate values (the ID of the corresponding mailbox).

In the future, I'll have to find a way to avoid this issue.

@tonioo commented on GitHub (Apr 3, 2014): Ok, so it means dovecot created those records before modoboa, which is embarassing. This error only occurs when MySQL in in use... you can fix it by filling empty mbox_id fields with the appropriate values (the ID of the corresponding mailbox). In the future, I'll have to find a way to avoid this issue.

kerem commented

2026-02-27 11:12:11 +03:00

Author

Owner

@ghost commented on GitHub (Apr 3, 2014):

I changed manually one of mbox_id with the same id from admin_mailbox table. It worked! =D

Thank you, everything is fine now!

@ghost commented on GitHub (Apr 3, 2014): I changed manually one of mbox_id with the same id from admin_mailbox table. It worked! =D Thank you, everything is fine now!