in reply to DBI: insert fails without error
Very odd.
How sure are you that you're accessing the same database from the mysql prompt and from Perl? I'd try to do a dump of the table from within Perl.
Then I'd try to upgrade/reinstall DBI.