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
Comment #1
alxsvdr commentedNigel,
Any comments? rsbecker seems to be using the trunk version.
Regards,
A. Saaveddra
Comment #2
nigelcunningham commentedSorry for the delay in answering.
I haven't been using bcc. I'll look into it.
Comment #3
nigelcunningham commentedFixed in 3a55f638154106057b8bb7f4cf972360d8c5c30f.
Simply suppressed the warning, as per http://drupal.org/node/805858.