"Peder O. Klingenberg" wrote:
>
> Malcolm Box <ma...@br...> writes:
>
> > $dbh, which is the database handle in question, is a package
> > variable and therefore I think it should be scoped until the package
> > is removed, ie when the END block deletes things properly.
>
> I would tend to agree with you, FWIW. I don't use mysql myself, so I
> can't experiment, but have you tried
Hmm, I wonder if similar things show up with pgsql and if not, what the
code differences are.
> * Setting $dbh->trace(n) with n>0 right after you connect?
>
> * Explicitly qualifying $dbh with the package, ie
> s/$dbh/$LXR::Index::Mysql::dbh/ ?
>
> * A different version of perl?
I'm running 5.6.0 which is one down from the latest stable so I may try
the update. I'll try the other things you suggest and see what turns
up. This one is really baffling me at the moment!
> Not that I would know what was wrong given results of those tests, but
> maybe they can help shed light on the problem?
Hell, I'll try anything at the moment - shotgun debugging it is!
Malcolm
|