I get 2014 Cannot execute queries while other unbuffered queries are active when doing exec with PDO


I am doing a PDO::exec command on multiple updates:

/>$MyPdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY,true); />$MyPdo->exec("update t1 set f1=1;update t2 set f1=2"); />

I am doing it inside a transaction, and I keep
getting:


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

I'd like to print a simple table in my page with 3 columns,
building name, tags and architecture
style
. If I try to retrieve the list of building
names
and arch. styles there is no problem:

/>SELECT buildings.name, arch_styles.style_name
FROM
buildings
INNER JOIN buildings_arch_styles
ON buildings.id =
buildings_arch_styles.building_id
INNER JOIN arch_styles
ON
arch_styles.id = buildings_arch_styles.arch_style_id
LIMIT 0,
10

My problem starts on retreaving the first 5
tags for every building of the query I've just wrote.


<
Programming Languages

While i am executing second Stored procedure with same connection
statement(Using PDO), getting the below error.

/>

=================================================

/>

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.

/>

=======================================================

/>

This is my code in drupal


$conn->setAttribute(
Databases

I know this has to be a simple fix and I partially understand why I
am getting this error but don't know how to fix it. I've looked over
the docs but can't find a solution other than using buffered queries
option. I have tried that as well but it doesn't work.


The
error is: PDO Cannot execute queries while other unbuffered queries
are active


The error is coming from the line where I am
building the $result array.


foreach($phones as
$phone)
{
$stmt = db::getInstance()->prepare("CALL
phones(:phone)");
$stmt->bindParam(':phone', $phone,
PDO::PARAM_INT, 10);
$stmt->execute();

Programming Languages

I keep getting this issue with PDO, where this error crops up in my
tests.


<?php />require_once('simpletest/unit_tester.php'); />require_once('simpletest/reporter.php'); />require_once('../model.php');
class TestOfCallMapper extends
UnitTestCase {
function testOfReturnsAll() {
}

function setUp() {
R::setup("mysql:host=localhost;dbname=poo",
root, ');
$this->destroySchema();

$this->createSchema();
}
function tearDown() {

$this->destroySchema();
}
private function
createSchema() {
R::exec(file_get_contents('../databa
Programming Languages

I want to be able to get some output from mysql stored procedure
within OUT params but for case when stored procedure also returns
result set via select statement like one below.

/>DELIMITER $$
DROP PROCEDURE IF EXISTS `RD`.`sp`$$ />CREATE DEFINER=`root`@`%` PROCEDURE `sp`(in b int, out a int) />BEGIN
select 664656 into a;
select 5;
END$$ />DELIMITER ;

Runing in console below mentioned
command one by one


call sp(5,@a)
select @a />

we will get result
5 => 5
@a =>
664656


However

Programming Languages

Oh, the joys of a new server. The following code has
always worked, and now I get some error 2014 related to unbuffered
queries. Has anyone experienced this, and if so, how did you resolve
it? Thanks

class="smallfont" style="margin-bottom:2px">PHP Code:
/>

style="white-space:nowrap">
style="text-align:left;">

 $sql=
Programming Languages
I'm sorry for asking this question. I've read alot just like it, but
never found a solution that I successfully could implement. All the
tips and tricks that I've found has been to no use for me.I have a
large associative array with data that I want to insert into a mysql
database using a stored procedure with PDO.$data_arr = {a lot of data
with keys: Name, Nbr, Val} //This is really 41 columns$inputs =
array('Name','Nbr','Val');$query = 'CALL
add_edit_standard(:Name,:Nbr,:Val)';$stmt =
Programming Languages

- Technology - Languages
+ Webmasters
+ Development
+ Development Tools
+ Internet
+ Mobile Programming
+ Linux
+ Unix
+ Apple
+ Ubuntu
+ Mobile & Tablets
+ Databases
+ Android
+ Network & Servers
+ Operating Systems
+ Coding
+ Design Software
+ Web Development
+ Game Development
+ Access
+ Excel
+ Web Design
+ Web Hosting
+ Web Site Reviews
+ Domain Name
+ Information Security
+ Software
+ Computers
+ Electronics
+ Hardware
+ Windows
+ PHP
+ ASP/ASP.Net
+ C/C++/C#
+ VB/VB.Net
+ JAVA
+ Javascript
+ Programming
Privacy Policy - Copyrights Notice - Feedback - Report Violation 2018 © BigHow