Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

[message:protected] => SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. 
 
Ze F
Jr. Member
 
Total Posts:  5
Joined:  2007-08-31
Portugal
 

I get this immediatly after filling in the database access details (name, user, et al.). Running xampp w/ php 5.2.1 and mysql 5.0.37 ohh

PDOException Object
(
[message:protected] => 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.
[string:private] =>
[code:protected] => HY000
[file:protected] => C:\xampp\htdocs\softspot2\lib\Varien\Db\Adapter\Pdo\Mysql.php
[line:protected] => 82
[trace:private] => Array
(
[0] => Array
(
[file] => C:\xampp\htdocs\softspot2\lib\Varien\Db\Adapter\Pdo\Mysql.php
[line] => 82
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
[0] =>

… bunch of table structs ...

[errorInfo] => Array
(
[0] => HY000
[1] => 2014
[2] => 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.
)

)

exception ‘Mage_Core_Exception’ with message ‘Error in file: “C:\xampp\htdocs\softspot2\app\code\core\Mage\Core\sql\core_setup\mysql4-install-0.6.0.php” - 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.’ in C:\xampp\htdocs\softspot2\app\Mage.php:288
Stack trace:
#0 C:\xampp\htdocs\softspot2\app\code\core\Mage\Core\Model\Resource\Setup.php(242): Mage::exception(’Mage_Core’, ‘Error in file: ...’)
#1 C:\xampp\htdocs\softspot2\app\code\core\Mage\Core\Model\Resource\Setup.php(121): Mage_Core_Model_Resource_Setup->_modifyResourceDb(’install’, ‘’, ‘0.6.5’)
#2 C:\xampp\htdocs\softspot2\app\code\core\Mage\Core\Model\Resource\Setup.php(108): Mage_Core_Model_Resource_Setup->_installResourceDb(’0.6.5’)
#3 C:\xampp\htdocs\softspot2\app\code\core\Mage\Core\Model\Resource\Setup.php(82): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 C:\xampp\htdocs\softspot2\app\code\core\Mage\Core\Model\Config.php(151): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 C:\xampp\htdocs\softspot2\app\Mage.php(326): Mage_Core_Model_Config->init(NULL)
#6 C:\xampp\htdocs\softspot2\app\Mage.php(345): Mage::init(NULL)
#7 C:\xampp\htdocs\softspot2\index.php(27): Mage::run(’base’)
#8 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
Techi
Jr. Member
 
Avatar
Total Posts:  5
Joined:  2007-08-31
Prague
 

I just upgraded do last version of PHP5 and MySQL5 and has same error either

->

it is clearly problem in magento -> which does not care about unbuffered queries in pdo -> you can try set PDO::MYSQL_ATTR_USE_BUFFERED_QUERY but i dont know where smile

I dont understand, why Magento DOES NOT use Zend_Db traditional access for databases ->.So it could be compatible with more databases. It only supports MySQL

 
Magento Community Magento Community
Magento Community
Magento Community
 
Preudomme
Jr. Member
 
Total Posts:  11
Joined:  2007-08-31
 

same error here, so what to do next?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Moshe
Magento Team
 
Avatar
Total Posts:  1770
Joined:  2007-08-07
Los Angeles
 

Magento was built to allow not only multiple engines and connection libraries, but also different resource logic models, such as db procedures.

please refer to http://www.magentocommerce.com/boards/viewthread/51/ for joined efforts smile

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top