in reply to Re: DBI with MySQL InnoDB tables troubles
in thread DBI with MySQL InnoDB tables troubles

Sometimes when working with InnoDB, I need to quote strings and NOT quote integers when preparing an INSERT. And also you might try
prepare() or die();
on your prepare statement. Also, are those backticks in your prepare statement? Try simple quotes.