SQL Redux

Chris-Bellsouth ctrudeau at BELLSOUTH.NET
Thu Jul 31 21:41:36 IST 2003


I was able to get the batched SQL inserts to work finally.

only problem is that now the maillog_recipient table is having duplicate
entries processed per message.  has anyone seen this before?


mysql> select * from maillog_recipient;

+----+------------+---------+-------------+
| id | msg_id     | to_user | to_domain   |
+----+------------+---------+-------------+
|  1 | 420DD1C00E | chris   | trudeau.org |
|  2 | 420DD1C00E | chris   | trudeau.org |
|  3 | D4D6C1C00E | chris   | trudeau.org |
|  4 | D4D6C1C00E | chris   | trudeau.org |
|  5 | 671581C00D | chris   | trudeau.org |
|  6 | 671581C00D | chris   | trudeau.org |
+----+------------+---------+-------------+

Not sure why this could be happening...any pointers is helpful

CT



More information about the MailScanner mailing list