in reply to Perl DBI adding some, not all, records to MySQL database

Hello

Turn PrintError on, that might show what goes wrong
$db = DBI->connect(...... { PrintError => 1} ) ;
Furthermore you could try to insert that record manually, it will probably tell you what goes wrong!

LuCa