-
- Chantal
 -
Total Posts: 68
Joined: 2008-05-11
Netherlands, Hellevoetsluis
|
Gaat bij mij hopeloos fout. Dit heb ik gedaan:
Categorie aangemaakt.
Simple product in categorie aangemaakt.
Artikel wordt getoond op frontend.
Bij promotions een rule aangemaakt met begin datum en einddatum toegewezen aan NOT LOGGED IN en actief.
Condition is “category is 5”.
En een prijsregel.
Ik klik op Save Rule en dan:
There has been an error processing your request.
SELECT `e`.*, `_table_product_id`.`product_id` FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_product` AS `_table_product_id` ON (_table_product_id.category_id=e.entity_id) WHERE (e.entity_type_id = '3') AND (_table_product_id.product_id = '1')
Trace:
#0 /var/www/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/lib/Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array)
#2 /var/www/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(Object(Varien_Db_Select), Array)
#3 /var/www/lib/Zend/Db/Adapter/Abstract.php(617): Zend_Db_Adapter_Pdo_Abstract->query(Object(Varien_Db_Select), Array)
#4 /var/www/lib/Varien/Data/Collection/Db.php(657): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select), Array)
#5 /var/www/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(838): Varien_Data_Collection_Db->_fetchAll(Object(Varien_Db_Select))
#6 /var/www/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(696): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#7 /var/www/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Category/Collection.php(139): Mage_Eav_Model_Entity_Collection_Abstract->load(false, false)
#8 /var/www/app/code/core/Mage/CatalogRule/Model/Rule.php(156): Mage_Catalog_Model_Resource_Eav_Mysql4_Category_Collection->load()
#9 [internal function]: Mage_CatalogRule_Model_Rule->callbackValidateProduct(Array)
#10 /var/www/app/code/core/Mage/Core/Model/Resource/Iterator.php(44): call_user_func(Array, Array)
#11 /var/www/app/code/core/Mage/CatalogRule/Model/Rule.php(147): Mage_Core_Model_Resource_Iterator->walk(Object(Varien_Db_Select), Array, Array)
#12 /var/www/app/code/core/Mage/CatalogRule/Model/Mysql4/Rule.php(52): Mage_CatalogRule_Model_Rule->getMatchingProductIds()
#13 /var/www/app/code/core/Mage/CatalogRule/Model/Rule.php(127): Mage_CatalogRule_Model_Mysql4_Rule->updateRuleProductData(Object(Mage_CatalogRule_Model_Rule))
#14 /var/www/app/code/core/Mage/Core/Model/Abstract.php(236): Mage_CatalogRule_Model_Rule->_afterSave()
#15 /var/www/app/code/core/Mage/Adminhtml/controllers/Promo/CatalogController.php(120): Mage_Core_Model_Abstract->save()
#16 /var/www/app/code/core/Mage/Core/Controller/Varien/Action.php(342): Mage_Adminhtml_Promo_CatalogController->saveAction()
#17 /var/www/app/code/core/Mage/Core/Controller/Varien/Router/Admin.php(148): Mage_Core_Controller_Varien_Action->dispatch('save')
#18 /var/www/app/code/core/Mage/Core/Controller/Varien/Front.php(146): Mage_Core_Controller_Varien_Router_Admin->match(Object(Mage_Core_Controller_Request_Http))
#19 /var/www/app/Mage.php(427): Mage_Core_Controller_Varien_Front->dispatch()
#20 /var/www/index.php(40): Mage::run()
#21 {main}
Magento ver. 1.0.19870.4
|
