The following error on my current project at work really gave me lots of headaches today:<\/p>\n
SQLSTATE[HY000]: General error: 2014 Cannot execute queries
\n while other unbuffered queries are active. Consider using
\n PDOStatement::fetchAll().
\n Alternatively, if your code is only ever going to run against
\n mysql, you may enable query buffering by setting the
\n PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.<\/p>\n
So, yes, I already have After struggling a lot I found the cause: I missed to close a statement which was reused in a loop!<\/p>\n So take care that you always call $stmt = $con->prepare(“SELECT * FROM doodle WHERE id = ?”);<\/p>\n foreach (range(1,10) as $id) The following error on my current project at work really gave me lots of headaches today: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute. So, … Continue reading Fixing MySQL \/ PDO error 2014<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,11],"tags":[],"class_list":["post-423","post","type-post","status-publish","format-standard","hentry","category-coding","category-work"],"_links":{"self":[{"href":"https:\/\/www.thomaskeller.biz\/blog\/wp-json\/wp\/v2\/posts\/423","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.thomaskeller.biz\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.thomaskeller.biz\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.thomaskeller.biz\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.thomaskeller.biz\/blog\/wp-json\/wp\/v2\/comments?post=423"}],"version-history":[{"count":6,"href":"https:\/\/www.thomaskeller.biz\/blog\/wp-json\/wp\/v2\/posts\/423\/revisions"}],"predecessor-version":[{"id":478,"href":"https:\/\/www.thomaskeller.biz\/blog\/wp-json\/wp\/v2\/posts\/423\/revisions\/478"}],"wp:attachment":[{"href":"https:\/\/www.thomaskeller.biz\/blog\/wp-json\/wp\/v2\/media?parent=423"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.thomaskeller.biz\/blog\/wp-json\/wp\/v2\/categories?post=423"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.thomaskeller.biz\/blog\/wp-json\/wp\/v2\/tags?post=423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}PDO::MYSQL_ATTR_USE_BUFFERED_QUERY<\/code> set to TRUE<\/code>, so why is PDO still complaining? And especially why it is complaining now, because the same code which triggered the error today ran without problems for the past 9 months?<\/p>\nPDOStatement->closeCursor()<\/code> in use cases like this:<\/p>\n
\n {
\n $stmt->execute(array($id));
\n $row = $stmt->fetch();
\n $stmt->closeCursor();
\n }<\/p>\n","protected":false},"excerpt":{"rendered":"