in reply to DBI query failing to execute

Try changing the execute to 
  $sth->execute($username, $score) or print $q->p("Could not INSERT in
+to $dbtable,$username,$score:" . $sth->errstr);

[download]
To get a clue about what the specific complaint is. For security reasons, you should probably only display this with specific authentication protections.

     Have you been high today? I see the nuns are gay! My brother yelled to me...I love you inside Ed - Benny Lava, by Buffalax

Replies are listed 'Best First'.
Re^2: DBI query failing to execute
by Lawliet (Curate) on Aug 15, 2008 at 06:45 UTC

    Oh, I think it may be a problem with the way I set up the database. sth->errstr printed Duplicate entry '0' for key 1

    And I am only printing these errors while I test the program. I will change it to just die with the error so it goes to error.log rather than printing out when I am done testing.

    I'm so adjective, I verb nouns!

    chomp; # nom nom nom
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom