Magento

eCommerce Software for Online Growth

Magento Forum

From setting up your store to managing your products, pages and promotions to generating detailed reports, the Magento User Guide empowers the user to utilize the platform for all of its vast capacity.
Available in eBook and Print formats – Download Now!!!
   
Order Rss feed not working
 
portalzine
Jr. Member
 
Avatar
Total Posts:  8
Joined:  2008-05-15
Germany
 

Hi,
/index.php/rss/order/new/ is sending an 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.

I have no problems with any other feed on the shop.

Running Magento 1.0.19870.2

Cheers
Alexander

 Signature 

portalZINE(R) New Media Network
http://www.portalzine.de
http://www.portalzine.tv

 
Magento Community Magento Community
Magento Community
Magento Community
 
raymond41
Jr. Member
 
Total Posts:  3
Joined:  2008-07-26
 

I am having the same problem. Not sure what the issue is. Hope there is a fix for this.

 
Magento Community Magento Community
Magento Community
Magento Community
 
SimpleHelix.com
Guru
 
Avatar
Total Posts:  472
Joined:  2007-08-31
Huntsville, AL
 

When New Order RSS menu gives you error:

“General error: 2014 Cannot execute queries while other unbuffered queries are active.”

This means that you need to uncomment the following:

On line 137 of “lib/Varien/Db/Adapter/Pdo/Mysql.php”, find:

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

and then uncomment it out, so it should be

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

 Signature 

SimpleHELIX, LLC
A World-Class Magento Web Hosting company - Providing scalable, reliable, and secure enterprise hosting solutions
The creators of super-fast performance hosting. Find out more @ http://www.simpleHELIX.com

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
 
© Copyright 2010 Varien. Magento, eCommerce software, is a trademark of Irubin Consulting Inc. DBA Varien
Privacy Policy|Terms of Service
Magento Community Count
177733 users|988 users currently online|277180 forum posts