As pointed out above, it is legal to not specify the columns...but you better be very sure about the exact order and type. At any rate, you could add some simple error checking to see *why* nothing was inserted. Most likely the execute statement will be able to tell you what went wrong:

$rs = $dbh->execute($sql) or die qq!"$sql" failed: $DBI::errstr\n!;
[download]

That should get you started, although I am pretty sure you are sending the wrong types into the tables. When in doubt, specify the columns.