I have been using Mailfix for several months with no serious problems. Today I set up BIND on my VPS and moved my domains so they are managed locally. I have got everything working except I am now getting a warning whenever I save a user that has an email address on my domain, or a forward, or BCC.

* user warning: Duplicate entry '447' for key 'PRIMARY' query: INSERT INTO mailfix_users (uid, domain_id, quota, forward, incoming_bcc, outgoing_bcc) VALUES (447, 1, 104857600, 'rbecker@dcappeals.com,hbecker@by-words.com', '', '') in /var/www/html/drupal/sites/all/modules/mailfix/mailfix.module on line 491.
* user warning: Duplicate entry '447' for key 'PRIMARY' query: INSERT INTO mailfix_users (uid, domain_id, quota, forward, incoming_bcc, outgoing_bcc) VALUES (447, 1, 104857600, 'rbecker@dcappeals.com,hbecker@by-words.com', '', '') in /var/www/html/drupal/sites/all/modules/mailfix/mailfix.module on line 491.

It appartently happens twice because there are two bccs on the incoming mail. I get the following in the Watchdog log.

Type backtrace
Date Monday, February 7, 2011 - 5:15pm
User admin
Location http://www.e-kehila.org/user/447/edit?destination=admin%2Fuser%2Fuser
Referrer http://www.e-kehila.org/user/447/edit?destination=admin%2Fuser%2Fuser
Message Type: php
Duplicate entry '447' for key 'PRIMARY' query: INSERT INTO mailfix_users (uid, domain_id, quota, forward, incoming_bcc, outgoing_bcc) VALUES (447, 1, 104857600, 'rbecker@dcappeals.com,hbecker@by-words.com', '', '') in /var/www/html/drupal/sites/all/modules/mailfix/mailfix.module on line 491.
Backtrace:
trigger_error(a:2:{i:0;s:264:"Duplicate entry '447' for key 'PRIMARY' query: INSERT INTO mailfix_users (uid, domain_id, quota, forward, incoming_bcc, outgoing_bcc) VALUES (447, 1, 104857600, 'rbecker@dcappeals.com,hbecker@by-words.com', '', '')";i:1;i:512;})[database.mysqli.inc:135];
._db_query(a:1:{i:0;s:167:"INSERT INTO mailfix_users (uid, domain_id, quota, forward, incoming_bcc, outgoing_bcc) VALUES (447, 1, 104857600, 'rbecker@dcappeals.com,hbecker@by-words.com', '', '')";})[database.mysql-common.inc:42];
..db_query(a:2:{i:0;s:126:"INSERT INTO {mailfix_users} (uid, domain_id, quota, forward, incoming_bcc, outgoing_bcc) VALUES (%d, %d, %d, '%s', '%s', '%s')";i:1;a:6:{i:0;s:3:"447";i:1;s:1:"1";i:2;s:9:"104857600";i:3;s:42:"rbecker@dcappeals.com,hbecker@by-words.com";i:4;s:0:"";i:5;s:0:"";}})[mailfix.module:491];
..._mailfix_set_user(array)[mailfix_admin.module:362];
....mailfix_admin_update_user(array)[mailfix_admin.module:334];
.....mailfix_admin_user(array)[user.module:22];
......user_module_invoke(array)[user.module:216];
.......user_save(array)[user.pages.inc:292];
........user_profile_form_submit(array)[form.inc:782];
.........form_execute_handlers(array)[form.inc:422];
..........drupal_process_form(array)[form.inc:121];
...........drupal_get_form(array)[user.pages.inc:239];
............user_edit(array)[?:?];
.............call_user_func_array(array)[menu.inc:348];
..............menu_execute_active_handler(a:0:{})[index.php:18];
...............index.php
Severity notice
Hostname 108.18.211.72
Operations

Comments

alxsvdr’s picture

Nigel,

Any comments? rsbecker seems to be using the trunk version.

Regards,

A. Saaveddra

nigelcunningham’s picture

Sorry for the delay in answering.

I haven't been using bcc. I'll look into it.

nigelcunningham’s picture

Status: Active » Fixed

Fixed in 3a55f638154106057b8bb7f4cf972360d8c5c30f.

Simply suppressed the warning, as per http://drupal.org/node/805858.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.