Hi Max, On Sat, Feb 5, 2011 at 10:01 PM, Max Pinton <m...@designyourowncard.com> wrote: > But the issue I'm asking about today is with DBI (1.612) and Apache::DBI > (1.08). In my old configuration they worked fine, but after the upgrade I > started seeing tons of errors like this: > > DBD::mysql::st execute failed: Commands out of sync; you can't run this > command now
Are you running the worker MPM? Apache::DBI will do the right thing with prefork MPM, but I don't think it will work with threads. > package My::Foo; > use My::DBI; > my $dbh = My::DBI->connect; > sub new { > my $sth = $dbh->... > } > > Thinking that the problem was that $dbh was having some weird scope issue, I > moved all the connect calls into the subs that use them. Yes, good call. The new() sub creates a closure with $dbh there. - Perrin