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.