Magento

This came after I set the database and server.

I both the default store and secure store to http and port 80.

Not sure if that’s the problem.

It is showing me alot of things about the PDOException Object with alot of this in it showing what it’s trying to do.

I really need help with this.

Which version of DB are you using ? What kind of errors do you get ?

I am using mysql 5.0.

The error message is as follows:

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] => H:\Program Files\Apache Group\Apache2\htdocs\magento\lib\Varien\Db\Adapter\Pdo\Mysql.php
[line:protected] => 82
[trace:private] => Array
(
[0] => Array
(
[file] => H:\Program Files\Apache Group\Apache2\htdocs\magento\lib\Varien\Db\Adapter\Pdo\Mysql.php
[line] => 82
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
[0] =>
-- --------------------------------------------------------

--
-- Table structure for table `core_resource`
--

DROP TABLE IF EXISTS `core_resource`;
CREATE TABLE `core_resource` (
`code` varchar(50) NOT NULL default ‘’,
`version` varchar(50) NOT NULL default ‘’,
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Resource version registry’;

)

)

[1] => Array
(
[file] => H:\Program Files\Apache Group\Apache2\htdocs\magento\lib\Varien\Db\Adapter\Pdo\Mysql.php
[line] => 113
[function] => raw_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
-- --------------------------------------------------------

--
-- Table structure for table `core_resource`
--

DROP TABLE IF EXISTS `core_resource`;
CREATE TABLE `core_resource` (
`code` varchar(50) NOT NULL default ‘’,
`version` varchar(50) NOT NULL default ‘’,
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Resource version registry’;

)

)

[2] => Array
(
[file] => H:\Program Files\Apache Group\Apache2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php
[line] => 408
[function] => multi_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
-- --------------------------------------------------------

--
-- Table structure for table `core_resource`
--

DROP TABLE IF EXISTS `core_resource`;
CREATE TABLE `core_resource` (
`code` varchar(50) NOT NULL default ‘’,
`version` varchar(50) NOT NULL default ‘’,
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Resource version registry’;

)

)

[3] => Array
(
[file] => H:\Program Files\Apache Group\Apache2\htdocs\magento\app\code\core\Mage\Core\sql\core_setup\mysql4-install-0.6.0.php
[line] => 39
[function] => run
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] =>
-- --------------------------------------------------------

--
-- Table structure for table `core_resource`
--

DROP TABLE IF EXISTS `core_resource`;
CREATE TABLE `core_resource` (
`code` varchar(50) NOT NULL default ‘’,
`version` varchar(50) NOT NULL default ‘’,
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Resource version registry’;

)

)

[4] => Array
(
[file] => H:\Program Files\Apache Group\Apache2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php
[line] => 223
[args] => Array
(
[0] => H:\Program Files\Apache Group\Apache2\htdocs\magento\app\code\core\Mage\Core\sql\core_setup\mysql4-install-0.6.0.php
)

[function] => include
)

[5] => Array
(
[file] => H:\Program Files\Apache Group\Apache2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php
[line] => 121
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => install
[1] =>
[2] => 0.6.5
)

)

[6] => Array
(
[file] => H:\Program Files\Apache Group\Apache2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php
[line] => 108
[function] => _installResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 0.6.5
)

)

[7] => Array
(
[file] => H:\Program Files\Apache Group\Apache2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php
[line] => 82
[function] => applyUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
)

)

[8] => Array
(
[file] => H:\Program Files\Apache Group\Apache2\htdocs\magento\app\code\core\Mage\Core\Model\Config.php
[line] => 151
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)

)

[9] => Array
(
[file] => H:\Program Files\Apache Group\Apache2\htdocs\magento\app\Mage.php
[line] => 326
[function] => init
[class] => Mage_Core_Model_Config
[type] => ->
[args] => Array
(
[0] =>
)

)

[10] => Array
(
[file] => H:\Program Files\Apache Group\Apache2\htdocs\magento\app\Mage.php
[line] => 345
[function] => init
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
)

)

[11] => Array
(
[file] => H:\Program Files\Apache Group\Apache2\htdocs\magento\index.php
[line] => 27
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
[0] => base
)

)

)

[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: “H:\Program Files\Apache Group\Apache2\htdocs\magento\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 H:\Program Files\Apache Group\Apache2\htdocs\magento\app\Mage.php:288
Stack trace:
#0 H:\Program Files\Apache Group\Apache2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(242): Mage::exception(’Mage_Core’, ‘Error in file: ...’)
#1 H:\Program Files\Apache Group\Apache2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(121): Mage_Core_Model_Resource_Setup->_modifyResourceDb(’install’, ‘’, ‘0.6.5’)
#2 H:\Program Files\Apache Group\Apache2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(108): Mage_Core_Model_Resource_Setup->_installResourceDb(’0.6.5’)
#3 H:\Program Files\Apache Group\Apache2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(82): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 H:\Program Files\Apache Group\Apache2\htdocs\magento\app\code\core\Mage\Core\Model\Config.php(151): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 H:\Program Files\Apache Group\Apache2\htdocs\magento\app\Mage.php(326): Mage_Core_Mo

That’s all of the message.

This error message have posted 3x times in the forum so far

I believe that the initial version 0.6 CAN NOT be installed due errors in code

maybe enabling PDO::MYSQL_ATTR_USE_BUFFERED_QUERY could temporarily solve this problem

Try to add

$this->_connection->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY,true);

in

lib/Zend/Db/Adapter/Pdo/Abstract.php

after line 124

I get the same error. Running WAMP 1.7.1 (PHP 5.2.2 and MySQL 5.0.37).

Tried changing that line. Got the following error instead:

Warning: PDO::setAttribute() expects exactly 2 parameters, 3 given in C:\wamp\www\magento\lib\Zend\Db\Adapter\Pdo\Abstract.php on line 124
[0] in PDO->setAttribute(3, 2, 1000) in C:\wamp\www\magento\lib\Zend\Db\Adapter\Pdo\Abstract.php on line 124
[1] in Zend_Db_Adapter_Pdo_Abstract->_connect() in C:\wamp\www\magento\lib\Varien\Db\Adapter\Pdo\Mysql.php on line 67
[2] in Varien_Db_Adapter_Pdo_Mysql->_connect() in C:\wamp\www\magento\lib\Zend\Db\Adapter\Abstract.php on line 367
[3] in Zend_Db_Adapter_Abstract->query("SET NAMES utf8”, Array[0]) in C:\wamp\www\magento\lib\Zend\Db\Adapter\Pdo\Abstract.php on line 206
[4] in Zend_Db_Adapter_Pdo_Abstract->query("SET NAMES utf8") in C:\wamp\www\magento\app\code\core\Mage\Core\Model\Resource\Type\Db\Pdo\Mysql.php on line 32
[5] in Mage_Core_Model_Resource_Type_Db_Pdo_Mysql->getConnection(Mage_Core_Model_Config_Element) in C:\wamp\www\magento\app\code\core\Mage\Core\Model\Resource.php on line 71
[6] in Mage_Core_Model_Resource->getConnection("core_read") in C:\wamp\www\magento\app\code\core\Mage\Core\Model\Mysql4\Abstract.php on line 238
[7] in Mage_Core_Model_Mysql4_Abstract->getConnection("read") in C:\wamp\www\magento\app\code\core\Mage\Core\Model\Mysql4\Config.php on line 47
[8] in Mage_Core_Model_Mysql4_Config->getChecksum("config_data,website,store,reso") in C:\wamp\www\magento\app\code\core\Mage\Core\Model\Config.php on line 122
[9] in Mage_Core_Model_Config->init(NULL) in C:\wamp\www\magento\app\Mage.php on line 326
[10] in Mage::init(NULL) in C:\wamp\www\magento\app\Mage.php on line 345
[11] in Mage::run("base") in C:\wamp\www\magento\index.php on line 27

Warning: PDO::setAttribute() expects exactly 2 parameters, 3 given in C:\wamp\www\magento\lib\Zend\Db\Adapter\Pdo\Abstract.php on line 124
[0] in PDO->setAttribute(3, 2, 1000) in C:\wamp\www\magento\lib\Zend\Db\Adapter\Pdo\Abstract.php on line 124
[1] in Zend_Db_Adapter_Pdo_Abstract->_connect() in C:\wamp\www\magento\lib\Varien\Db\Adapter\Pdo\Mysql.php on line 67
[2] in Varien_Db_Adapter_Pdo_Mysql->_connect() in C:\wamp\www\magento\lib\Zend\Db\Adapter\Abstract.php on line 367
[3] in Zend_Db_Adapter_Abstract->query("SET NAMES utf8”, Array[0]) in C:\wamp\www\magento\lib\Zend\Db\Adapter\Pdo\Abstract.php on line 206
[4] in Zend_Db_Adapter_Pdo_Abstract->query("SET NAMES utf8") in C:\wamp\www\magento\app\code\core\Mage\Core\Model\Resource\Type\Db\Pdo\Mysql.php on line 32
[5] in Mage_Core_Model_Resource_Type_Db_Pdo_Mysql->getConnection(Mage_Core_Model_Config_Element) in C:\wamp\www\magento\app\code\core\Mage\Core\Model\Resource.php on line 71
[6] in Mage_Core_Model_Resource->getConnection("core_setup") in C:\wamp\www\magento\app\code\core\Mage\Core\Model\Resource\Setup.php on line 45
[7] in Mage_Core_Model_Resource_Setup->__construct("core_setup") in C:\wamp\www\magento\app\code\core\Mage\Core\Model\Resource\Setup.php on line 81
[8] in Mage_Core_Model_Resource_Setup::applyAllUpdates() in C:\wamp\www\magento\app\code\core\Mage\Core\Model\Config.php on line 151
[9] in Mage_Core_Model_Config->init(NULL) in C:\wamp\www\magento\app\Mage.php on line 326
[10] in Mage::init(NULL) in C:\wamp\www\magento\app\Mage.php on line 345
[11] in Mage::run("base") in C:\wamp\www\magento\index.php on line 27

Notice: Undefined index:  default in C:\wamp\www\magento\app\code\core\Mage\Core\Model\Mysql4\Config.php on line 115
[0] in Mage_Core_Model_Mysql4_Config->loadToXml(Mage_Core_Model_Config) in C:\wamp\www\magento\app\code\core\Mage\Core\Model\Config.php on line 155
[1] in Mage_Core_Model_Config->init(NULL) in C:\wamp\www\magento\app\Mage.php on line 326
[2] in Mage::init(NULL) in C:\wamp\www\magento\app\Mage.php on line 345
[3] in Mage::run("base") in C:\wamp\www\magento\index.php on line 27

Warning: Invalid argument supplied for foreach() in C:\wamp\www\magento\app\code\core\Mage\Core\Model\Mysql4\Config.php on line 115
[0] in Mage_Core_Model_Mysql4_Config->loadToXml(Mage_Core_Model_Config) in C:\wamp\www\magento\app\code\core\Mage\Core\Model\Config.php on line 155
[1] in Mage_Core_Model_Config->init(NULL) in C:\wamp\www\magento\app\Mage.php on line 326
[2] in Mage::init(NULL) in C:\wamp\www\magento\app\Mage.php on line 345
[3] in Mage::run("base") in C:\wamp\www\magento\index.php on line 27

Error message continued:

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\wamp\www\magento\app\code\core\Mage\Core\functions.php:100) in C:\wamp\www\magento\app\code\core\Mage\Core\Model\Session\Abstract\Varien.php on line 49
[0] in session_start() in C:\wamp\www\magento\app\code\core\Mage\Core\Model\Session\Abstract\Varien.php on line 49
[1] in Mage_Core_Model_Session_Abstract_Varien->start() in C:\wamp\www\magento\app\code\core\Mage\Core\Model\Session.php on line 32
[2] in Mage_Core_Model_Session->__construct(Array[0]) in C:\wamp\www\magento\app\code\core\Mage\Core\Model\Config.php on line 550
[3] in Mage_Core_Model_Config->getModelInstance("core/session", Array[0]) in C:\wamp\www\magento\app\Mage.php on line 240
[4] in Mage::getModel("core/session", Array[0]) in C:\wamp\www\magento\app\Mage.php on line 247
[5] in Mage::getSingleton("core/session") in C:\wamp\www\magento\app\code\core\Mage\Core\Controller\Varien\Action.php on line 71
[6] in Mage_Core_Controller_Varien_Action->__construct(Zend_Controller_Request_Http, Zend_Controller_Response_Http) in C:\wamp\www\magento\app\code\core\Mage\Core\Controller\Varien\Router\Standard.php on line 124
[7] in Mage_Core_Controller_Varien_Router_Standard->match(Zend_Controller_Request_Http) in C:\wamp\www\magento\app\code\core\Mage\Core\Controller\Varien\Front.php on line 139
[8] in Mage_Core_Controller_Varien_Front->dispatch() in C:\wamp\www\magento\app\Mage.php on line 349
[9] in Mage::run("base") in C:\wamp\www\magento\index.php on line 27

Error message continued:

exception ‘Mage_Eav_Exception’ with message ‘Invalid entity supplied’ in C:\wamp\www\magento\app\Mage.php:288
Stack trace:
#0 C:\wamp\www\magento\app\code\core\Mage\Eav\Model\Entity\Attribute\Abstract.php(81): Mage::exception(’Mage_Eav’, ‘Invalid entity ...’)
#1 C:\wamp\www\magento\app\code\core\Mage\Eav\Model\Entity\Abstract.php(434): Mage_Eav_Model_Entity_Attribute_Abstract->loadByCode(Object(Mage_Eav_Model_Entity_Type), ‘entity_type_id’)
#2 C:\wamp\www\magento\app\code\core\Mage\Eav\Model\Entity\Abstract.php(1176): Mage_Eav_Model_Entity_Abstract->getAttribute(’entity_type_id’)
#3 C:\wamp\www\magento\app\code\core\Mage\Eav\Model\Entity\Abstract.php(195): Mage_Eav_Model_Entity_Abstract->_afterSetConfig()
#4 C:\wamp\www\magento\app\code\core\Mage\Customer\Model\Entity\Customer.php(32): Mage_Eav_Model_Entity_Abstract->setType(’customer’)
#5 C:\wamp\www\magento\app\code\core\Mage\Core\Model\Config.php(550): Mage_Customer_Model_Entity_Customer->__construct(Array)
#6 C:\wamp\www\magento\app\code\core\Mage\Core\Model\Config.php(577): Mage_Core_Model_Config->getModelInstance(’customer_entity...’, Array)
#7 C:\wamp\www\magento\app\Mage.php(261): Mage_Core_Model_Config->getResourceModelInstance(’customer/custom...’, Array)
#8 C:\wamp\www\magento\app\Mage.php(268): Mage::getResourceModel(’customer/custom...’, Array)
#9 C:\wamp\www\magento\app\code\core\Mage\Customer\Model\Customer.php(55): Mage::getResourceSingleton(’customer/custom...’)
#10 C:\wamp\www\magento\app\code\core\Mage\Customer\Model\Customer.php(45): Mage_Customer_Model_Customer->getResource()
#11 C:\wamp\www\magento\app\code\core\Mage\Core\Model\Config.php(550): Mage_Customer_Model_Customer->__construct(Array)
#12 C:\wamp\www\magento\app\Mage.php(240): Mage_Core_Model_Config->getModelInstance(’customer/custom...’, Array)
#13 C:\wamp\www\magento\app\code\core\Mage\Customer\Model\Session.php(62): Mage::getModel(’customer/custom...’)
#14 C:\wamp\www\magento\app\code\core\Mage\Customer\Model\Session.php(87): Mage_Customer_Model_Session->getCustomer()
#15 C:\wamp\www\magento\app\code\core\Mage\Log\Model\Visitor.php(159): Mage_Customer_Model_Session->isLoggedIn()
#16 [internal function]: Mage_Log_Model_Visitor->bindCustomer(Object(Varien_Event_Observer))
#17 C:\wamp\www\magento\lib\Varien\Event\Observer.php(58): call_user_func(Array, Object(Varien_Event_Observer))
#18 C:\wamp\www\magento\lib\Varien\Event\Observer\Collection.php(100): Varien_Event_Observer->dispatch(Object(Varien_Event))
#19 C:\wamp\www\magento\lib\Varien\Event.php(91): Varien_Event_Observer_Collection->dispatch(Object(Varien_Event))
#20 C:\wamp\www\magento\lib\Varien\Event\Collection.php(136): Varien_Event->dispatch()
#21 C:\wamp\www\magento\app\Mage.php(227): Varien_Event_Collection->dispatch(’initCustomerSes...’, Array)
#22 C:\wamp\www\magento\app\code\core\Mage\Customer\Model\Session.php(34): Mage::dispatchEvent(’initCustomerSes...’, Array)
#23 C:\wamp\www\magento\app\code\core\Mage\Core\Model\Config.php(550): Mage_Customer_Model_Session->__construct(Array)
#24 C:\wamp\www\magento\app\Mage.php(240): Mage_Core_Model_Config->getModelInstance(’customer/sessio...’, Array)
#25 C:\wamp\www\magento\app\Mage.php(247): Mage::getModel(’customer/sessio...’, Array)
#26 C:\wamp\www\magento\app\code\core\Mage\Customer\Model\Observer.php(32): Mage::getSingleton(’customer/sessio...’)
#27 [internal function]: Mage_Customer_Model_Observer->beforeGenerateLayoutBlocks(Object(Varien_Event_Observer))
#28 C:\wamp\www\magento\lib\Varien\Event\Observer.php(58): call_user_func(Array, Object(Varien_Event_Observer))
#29 C:\wamp\www\magento\lib\Varien\Event\Observer\Collection.php(100): Varien_Event_Observer->dispatch(Object(Varien_Event))
#30 C:\wamp\www\magento\lib\Varien\Event.php(91): Varien_Event_Observer_Collection->dispatch(Object(Varien_Event))
#31 C:\wamp\www\magento\lib\Varien\Event\Collection.php(136): Varien_Event->dispatch()
#32 C:\wamp\www\magento\app\Mage.php(227): Varien_Event_Collection->dispatch(’beforeGenerateL...’, Array)
#33 C:\wamp\www\magento\app\code\core\Mage\Core\Controller\Varien\Action.php(174): Mage::dispatchEvent(’beforeGenerateL...’, Array)
#34 C:\wamp\www\magento\app\code\core\Mage\Install\controllers\WizardController.php(32): Mage_Core_Controller_Varien_Action->loadLayout(’install_wizard’)
#35 C:\wamp\www\magento\app\code\core\Mage\Install\controllers\WizardController.php(174): Mage_Install_WizardController->_prepareLayout()
#36 C:\wamp\www\magento\app\code\core\Mage\Core\Controller\Varien\Action.php(225): Mage_Install_WizardController->administratorAction()
#37 C:\wamp\www\magento\app\code\core\Mage\Core\Controller\Varien\Router\Standard.php(138): Mage_Core_Controller_Varien_Action->dispatch(’administrator’)
#38 C:\wamp\www\magento\app\code\core\Mage\Core\Controller\Varien\Front.php(139): Mage_Core_Controller_Varien_Router_Standard->match(Object(Zend_Controller_Request_Http))
#39 C:\wamp\www\magento\app\Mage.php(349): Mage_Core_Controller_Varien_Front->dispatch()
#40 C:\wamp\www\magento\index.php(27): Mage::run(’base’)
#41 {main}

@Jonathan

Sorry for error. This should be $this->_connection->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY,true);

I see many people are having this problem (as I did myself). To fix it I replaced my php_pdo_mysql.dll with this one: php_pdo_mysql.dll

netcart: It doesn’t seem to solve the problem. I’m back att error no 1 again

Do you have both of these in your php.ini?

extension=php_pdo.dll
extension=php_pdo_mysql.dll