Firstly, take a look at the documentation for DBI Statement Handle Attributes which discusses the types of errors you're seeing.

Next, see these for driver specific details:

• DBD::mysql STATEMENT HANDLES: which shows NAME; has a caveat re TYPE; does not show PRECISION.
• DBD::mysqlPP STATEMENT HANDLES: which doesn't show any of those attributes.

As the statement handle is a hashref (DBI::st=HASH(0x370ee64)), you can write a short piece of code which will list all available attributes for you. It should look something like the following untested code and placed before your current printf statement:

for my $key (keys %$sth) {
    say $key, ' : ', ($sth->{$key} // 'undef');
    # Use this if your Perl version < 5.10
    #print $key, ' : ', (defined $sth->{$key} ? $sth->{$key} : 'undef'
+), "\n";
}
[download]