Duplicate entry 'NULL' for key 1

info Info at DHP.COM.AU
Mon Sep 22 06:54:39 IST 2003


Hi,

I have SQL logging working with RH7.2 and MailScanner 4.23-11.  Using
the same config on a RH9.0 box I am receiving the following error when
ever MailScanner is restarted:

Cannot insert row: Duplicate entry 'NULL' for key 1

The maillog_mail table in mysql has 1 bogus entry with a NULL msg_id.

Any suggestions has to where the problem is?

Regards,

David Pinkerton


------------------------------------------------------------------
This communication may contain information which is confidential
and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s),
please note that any distribution, copying or use of this
communication or the information in it is strictly prohibited.
If you have received this communication in error, please notify
the sender immediately and then destroy any copies of it.
------------------------------------------------------------------



More information about the MailScanner mailing list