How to avoid this PDO exception: Cannot execute queries while other unbuffered queries are active


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.


<

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

Programming Languages

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'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