The following bug has been SUBMITTED. ====================================================================== http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0000250 ====================================================================== Reported By: ezaton Assigned To: ====================================================================== Project: DBMail Bug ID: 250 Category: IMAP daemon Reproducibility: always Severity: minor Priority: normal Status: new ====================================================================== Date Submitted: 18-Aug-05 01:08 CEST Last Modified: 18-Aug-05 01:08 CEST ====================================================================== Summary: DB failure when trying to subscribe to an imap folder Description: Reproducable with both SquirrelMail and Mozilla-Thunderbird, both using the same mailbox. The DB was migrated from 1.x, long time ago. When trying to subscribe, the following error message is shown on the server:
Aug 18 01:56:11 rafael dbmail/imap4d[32142]: _ic_login(): user (id:1, name ezaton) tries login Aug 18 01:56:11 rafael dbmail/imap4d[32142]: _ic_login(): user (id 1, name ezaton) login accepted @ 2005-08-18 01:56:11 Aug 18 01:56:11 rafael dbmail/imap4d[32142]: dbmysql.c,db_query: query [INSERT INTO dbmail_subscription (user_id, mailbox_id) VALUES ('1', '41')] failed Aug 18 01:56:11 rafael dbmail/imap4d[32142]: dbmysql.c,db_query: mysql_real_query failed: Cannot add or update a child row: a foreign key constraint fails Aug 18 01:56:11 rafael dbmail/imap4d[32142]: db.c,db_subscribe: could not insert subscription Aug 18 01:56:11 rafael dbmail/imap4d[32142]: imap4.c,IMAPClientHandler: command return with error [subscribe] Aug 18 01:56:11 rafael dbmail/imap4d[32142]: IMAPClientHandler(): Closing connection for client from IP [127.0.0.1] Trace Level 2 on dbmail-imapd The client disconnects and reports imap error. This problem (although I've never tried to submit a bug here before) is reproducable on all dbmail 2.0.x ====================================================================== Bug History Date Modified Username Field Change ====================================================================== 18-Aug-05 01:08ezaton New Bug ======================================================================