Beefy Boxes and Bandwidth Generously Provided by pair Networks DiBona
Syntactic Confectionery Delight
 
PerlMonks  

Re: DBD driver has not implemented the AutoCommit attribute

by perrin (Chancellor)
on Sep 19, 2007 at 17:51 UTC ( #639948=note: print w/ replies, xml ) Need Help??


in reply to DBD driver has not implemented the AutoCommit attribute

That means you dropped your database connection at some point. Something is set up differently from your old host. I can't tell you what from the information you've provided.


Comment on Re: DBD driver has not implemented the AutoCommit attribute
Re^2: DBD driver has not implemented the AutoCommit attribute
by jerrygarciuh (Curate) on Sep 19, 2007 at 19:42 UTC
    Hi perrin,

    Thanks for taking a look. Could you tell me what information would be diagnostically helpful?


    TIA
    jg
    _____________________________________________________
    "Transport of the mails, transport of the human voice, transport of flickering pictures - in this century, as in others, our highest accomplishments still have the single aim of bringing people together."   Wind, Sand, and Stars
      Antoine-Marie-Roger de Saint-Exupery
      Well, if it works on the other system but not this one, I'd suggest you try to figure out what's different. One thing to check is the version of Ima::DBI you're using.
Re^2: DBD driver has not implemented the AutoCommit attribute
by mpeters (Chaplain) on Nov 16, 2007 at 16:02 UTC

    Actually, I'm facing the same problem here. It looks like a problem in DBD::mysql.

    Are you using local $dbh->{AutoCommit} = 0 anywhere?

    Update:
    I've tracked this down to a problem with DBD::mysql (most recent versions) and DBI > 1.53. DBI 1.54 had some pretty big changes in it's internals and it looks like in some cases this causes problems when the AutoCommit flag is changed in DBD::mysql. I'm still not sure why, but it sporadically causes the above error you're seeing.


    -- More people are killed every year by pigs than by sharks, which shows you how good we are at evaluating risk. -- Bruce Schneier

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://639948]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (11)
As of 2014-04-18 19:09 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (471 votes), past polls