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

Page 1 of 2
Catalor Price Rules
 
GPutignano
Sr. Member
 
Avatar
Total Posts:  214
Joined:  2007-11-03
Lauria - Italy
 

After upgrading to 1.1.7 I get error in Catalog Price Rules. Don’t you?

 
Magento Community Magento Community
Magento Community
Magento Community
 
laProbeta
Member
 
Total Posts:  35
Joined:  2008-10-21
 

We also suffer this!

Since we upgraded from 1.1.6 to 1.1.7 whenever we try to add new Shopping Cart Price Rules or Catgalog Price Rules we get the same error,

Output format is not specified. Please, specify “format” key in constructor, or set it using setFormat().
#0 /var/www/magento/app/design/adminhtml/default/default/template/widget/form/renderer/fieldset/element.phtml(34): Varien_Data_Form_Element_Date->getElementHtml()
#1 ...

Any workaround or downgrade process?

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

i’ve just noticed my catalog price rules are not in effect.
trying to activate them gives me;

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.

#0 /var/www/alex/meanmachines.biz/html/lib/Zend/Db/Adapter/Pdo/Abstract.php(254): PDO->rollBack()
#1 /var/www/alex/meanmachines.biz/html/lib/Zend/Db/Adapter/Abstract.php(450): Zend_Db_Adapter_Pdo_Abstract->_rollBack()
#2 /var/www/alex/meanmachines.biz/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Abstract->rollBack()
#3 /var/www/alex/meanmachines.biz/html/app/code/core/Mage/CatalogRule/Model/Mysql4/Rule.php(432): Varien_Db_Adapter_Pdo_Mysql->rollback()
#4 /var/www/alex/meanmachines.biz/html/app/code/core/Mage/Adminhtml/controllers/Promo/CatalogController.php(239): Mage_CatalogRule_Model_Mysql4_Rule->applyAllRulesForDateRange()
#5 /var/www/alex/meanmachines.biz/html/app/code/core/Mage/Core/Controller/Varien/Action.php(349): Mage_Adminhtml_Promo_CatalogController->applyRulesAction()
#6 /var/www/alex/meanmachines.biz/html/app/code/core/Mage/Core/Controller/Varien/Router/Admin.php(143): Mage_Core_Controller_Varien_Action->dispatch('applyRules')
#7 /var/www/alex/meanmachines.biz/html/app/code/core/Mage/Core/Controller/Varien/Front.php(174): Mage_Core_Controller_Varien_Router_Admin->match(Object(Mage_Core_Controller_Request_Http))
#8 /var/www/alex/meanmachines.biz/html/app/Mage.php(447): Mage_Core_Controller_Varien_Front->dispatch()
#9 /var/www/alex/meanmachines.biz/html/index.php(46): Mage::run()
#10 {main}

man i am debugging 1.1.7 so much!!

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

Not only this but some of my related products are not clearing their catalog price rules.

1 bug linked to the next;

- i had 10% off sale store-wide, which as i can not apply the catalog price rules now, showed all my prices ‘AS LOW AS...’ after midnight (as happens when you do not have your cron.php running every 5 mins)
- i removed this sale till this bug gets fixed
- some of my related products still show ‘AS LOW AS’…

please take a look;
http://www.meanmachines.biz/store/steering-wheels/deep-dish-steering-wheel-350-mm.html

visiting the product shows no such price.

please resolve this trail of bugs! i have suspended my christmas discounts till this gets resolved, and the ghosted related as low as products really are not helping..

 
Magento Community Magento Community
Magento Community
Magento Community
 
seiya
Sr. Member
 
Total Posts:  85
Joined:  2008-05-25
Vienna
 

Same Problem when i add more then one Catalog Price Rules it cames errors:

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.

#0 /var/www/vhosts/animetown.eu/httpdocs/store/lib/Zend/Db/Adapter/Pdo/Abstract.php(254): PDO->rollBack()
#1 /var/www/vhosts/animetown.eu/httpdocs/store/lib/Zend/Db/Adapter/Abstract.php(450): Zend_Db_Adapter_Pdo_Abstract->_rollBack()
#2 /var/www/vhosts/animetown.eu/httpdocs/store/lib/Varien/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Abstract->rollBack()
#3 /var/www/vhosts/animetown.eu/httpdocs/store/app/code/core/Mage/CatalogRule/Model/Mysql4/Rule.php(432): Varien_Db_Adapter_Pdo_Mysql->rollback()
#4 /var/www/vhosts/animetown.eu/httpdocs/store/app/code/core/Mage/Adminhtml/controllers/Promo/CatalogController.php(239): Mage_CatalogRule_Model_Mysql4_Rule->applyAllRulesForDateRange()
#5 /var/www/vhosts/animetown.eu/httpdocs/store/app/code/core/Mage/Core/Controller/Varien/Action.php(349): Mage_Adminhtml_Promo_CatalogController->applyRulesAction()
#6 /var/www/vhosts/animetown.eu/httpdocs/store/app/code/core/Mage/Core/Controller/Varien/Router/Admin.php(143): Mage_Core_Controller_Varien_Action->dispatch(’applyRules’)
#7 /var/www/vhosts/animetown.eu/httpdocs/store/app/code/core/Mage/Core/Controller/Varien/Front.php(174): Mage_Core_Controller_Varien_Router_Admin->match(Object(Mage_Core_Controller_Request_Http))
#8 /var/www/vhosts/animetown.eu/httpdocs/store/app/Mage.php(447): Mage_Core_Controller_Varien_Front->dispatch()
#9 /var/www/vhosts/animetown.eu/httpdocs/store/index.php(46): Mage::run()
#10 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
hungpvtn2
Member
 
Avatar
Total Posts:  52
Joined:  2008-09-07
Melbourne
 

I’am experiencing the same issue as laProbeta; Plus
the grid is not clickable in Firefox but IE. This means I can not open those current rules.

I remember I had the clickable issue with some other grid as well but can not remember exactly what grds were there. Sometime they work in IE but firefox; and some time it is the other way.

Awaiting for help!

Thank you.

 
Magento Community Magento Community
Magento Community
Magento Community
 
rwaldock
Jr. Member
 
Total Posts:  15
Joined:  2007-12-23
 

We also had this error. Shopping cart rules were not editable and were not correctly applied.

We received the “Output format is not specified. Please, specify “format” key in constructor, or set it using setFormat(). “ when attempting to create or edit a rule and found the that the rules grid was not clickable in Firefox.

I’m hoping the Magento team will patch these issues, because we love the new functionality in 1.1.7! It’s a shame we can’t role it out without loosing the use of our cart rules… :(

 
Magento Community Magento Community
Magento Community
Magento Community
 
hungpvtn2
Member
 
Avatar
Total Posts:  52
Joined:  2008-09-07
Melbourne
 

Guys, try this
http://www.magentocommerce.com/boards/viewthread/24079/

to see if it helps you.

Cheers

 
Magento Community Magento Community
Magento Community
Magento Community
 
seiya
Sr. Member
 
Total Posts:  85
Joined:  2008-05-25
Vienna
 

Mageto Team closed this bug becaus are unable to reproduce :/

 
Magento Community Magento Community
Magento Community
Magento Community
 
seiya
Sr. Member
 
Total Posts:  85
Joined:  2008-05-25
Vienna
 

i have delete all rules now, and put new rules into, not it works! dont know why was this problem!

but when i edit after on of the rule it gives problems again!

 
Magento Community Magento Community
Magento Community
Magento Community
 
seiya
Sr. Member
 
Total Posts:  85
Joined:  2008-05-25
Vienna
 

ok this problem cames only when you have more than one rle and edit a rule, so you must delete all rules you have edited!

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

well i have deleted all rules and upon creating a new rule and applying it, i get;

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.

#0 /var/www/alex/meanmachines.biz/html/lib/Zend/Db/Adapter/Pdo/Abstract.php(254): PDO->rollBack()
#1 /var/www/alex/meanmachines.biz/html/lib/Zend/Db/Adapter/Abstract.php(450): Zend_Db_Adapter_Pdo_Abstract->_rollBack()
#2 /var/www/alex/meanmachines.biz/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Abstract->rollBack()
#3 /var/www/alex/meanmachines.biz/html/app/code/core/Mage/CatalogRule/Model/Mysql4/Rule.php(432): Varien_Db_Adapter_Pdo_Mysql->rollback()
#4 /var/www/alex/meanmachines.biz/html/app/code/core/Mage/Adminhtml/controllers/Promo/CatalogController.php(239): Mage_CatalogRule_Model_Mysql4_Rule->applyAllRulesForDateRange()
#5 /var/www/alex/meanmachines.biz/html/app/code/core/Mage/Core/Controller/Varien/Action.php(349): Mage_Adminhtml_Promo_CatalogController->applyRulesAction()
#6 /var/www/alex/meanmachines.biz/html/app/code/core/Mage/Core/Controller/Varien/Router/Admin.php(143): Mage_Core_Controller_Varien_Action->dispatch('applyRules')
#7 /var/www/alex/meanmachines.biz/html/app/code/core/Mage/Core/Controller/Varien/Front.php(174): Mage_Core_Controller_Varien_Router_Admin->match(Object(Mage_Core_Controller_Request_Http))
#8 /var/www/alex/meanmachines.biz/html/app/Mage.php(447): Mage_Core_Controller_Varien_Front->dispatch()
#9 /var/www/alex/meanmachines.biz/html/index.php(46): Mage::run()
#10 {main}

my rules worked great in 1.1.6

 
Magento Community Magento Community
Magento Community
Magento Community
 
seiya
Sr. Member
 
Total Posts:  85
Joined:  2008-05-25
Vienna
 

any workaround from others? problem exists anymore..... magento team says they cant reproduce failure it must be a server config error....

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

whats the status of this problem?

can someone get catalog price rules working again with 1.1.8?

 
Magento Community Magento Community
Magento Community
Magento Community
 
seiya
Sr. Member
 
Total Posts:  85
Joined:  2008-05-25
Vienna
 

same problem in 1.1.8, magento team means the error is in the server config

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

great, so what config needs to be updated and where? mysql i presume..
bug wasn’t there in 1.1.6, so the server config requirements have changed due to code changes.
please advise.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 1 of 2