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

SQL error on install
 
Redman
Jr. Member
 
Total Posts:  6
Joined:  2007-10-06
 

Hello all.

I am using WAMP server on Windows. I have enable the extra modules required as per other posts (Or have I) but I seem to be getting this.

PDOException Object
(
    
[message:protected] => SQLSTATE[HY000]General error2014 Cannot execute queries while other unbuffered queries are active.  Consider using PDOStatement::fetchAll().  Alternatively, if your code is only ever going to run against mysqlyou may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
    
[string:private] => 
    
[code:protected] => HY000
    [file
:protected] => I:\wamp\www\magento\lib\Varien\Db\Adapter\Pdo\Mysql.php
    [line
:protected] => 82
    [trace
:private] => Array
        (
            
[0] => Array
                (
                    
[file] => I:\wamp\www\magento\lib\Varien\Db\Adapter\Pdo\Mysql.php
                    [line] 
=> 82
                    [function] 
=> query
                    [class] 
=> PDO
                    [type] 
=> ->
                    
[args] => Array
                        (
                            
[0] => replace into core_resource (codeversionvalues ('core_setup''0.6.0')
                        )

And it continues....

exception 'Mage_Core_Exception' with message 'Error in file: "I:\wamp\www\magento\app\code\core\Mage\Core\sql\core_setup\mysql4-install-0.6.0.sql" - 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 I:\wamp\www\magento\app\Mage.php:290
Stack trace
:
#0 I:\wamp\www\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(242): Mage::exception('Mage_Core', 'Error in file: ...')
#1 I:\wamp\www\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(121): Mage_Core_Model_Resource_Setup->_modifyResourceDb('install', '', '0.6.0')
#2 I:\wamp\www\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(108): Mage_Core_Model_Resource_Setup->_installResourceDb('0.6.0')
#3 I:\wamp\www\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(82): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 I:\wamp\www\magento\app\code\core\Mage\Core\Model\Config.php(151): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 I:\wamp\www\magento\app\Mage.php(328): Mage_Core_Model_Config->init(NULL)
#6 I:\wamp\www\magento\app\Mage.php(349): Mage::init(NULL)
#7 I:\wamp\www\magento\index.php(27): Mage::run('base')
#8 {main}

Its a really nice Shop solution and very modern, also a little new to me. I hope someone has an answer as I am a little lost.
Regards

Red

 
Magento Community Magento Community
Magento Community
Magento Community
 
Redman
Jr. Member
 
Total Posts:  6
Joined:  2007-10-06
 

NM Found the solution here…

http://www.magentocommerce.com/boards/viewthread/784/

Thank you smile

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