jeanluca's tip will probably help, but you might also consider using the or die and bind features as well.

Some of your inserts may be failing because of meta characters in your field values. Try something more like this:

my $sth = $dbo->prepare("insert into table(field,field,field) values(?
+,?,?)");
my $oth = $dbo->prepare("insert into table set field=?, field=?, field
+=?");
# this second form is unique to mysql, but more readable...

while( $something ) {
    $sth->execute( $value, $value, $value ) or die $sth->errstr;
}
[download]