Strona główna forum
Zaloguj
Zarejestruj
Szukaj
Użytkownicy
Mam dośc dziwny problem z Cron-em
Wywołując Cron-a automatycznie czyli tak jak jest ustalone dla
"catalogrule_apply_all" o 1 w nocy dostaje błąd, a gdy wywołam Cron-a ręcznie to jest wszystko ok.
Błąd
Kod: Zaznacz cały
exception 'PDOException' with message 'SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 4' in /var/www/vhosts/strona-www/httpdocs/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /var/www/vhosts/strona-www/httpdocs/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /var/www/vhosts/strona-www/httpdocs/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#2 /var/www/vhosts/strona-www/httpdocs/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /var/www/vhosts/strona-www/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('replace into ca...', Array)
#4 /var/www/vhosts/strona-www/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(337): Zend_Db_Adapter_Pdo_Abstract->query('replace into ca...', Array)
#5 /var/www/vhosts/strona-www/httpdocs/app/code/core/Mage/CatalogRule/Model/Mysql4/Rule.php(600): Varien_Db_Adapter_Pdo_Mysql->query('replace into ca...')
#6 /var/www/vhosts/strona-www/httpdocs/app/code/core/Mage/CatalogRule/Model/Mysql4/Rule.php(506): Mage_CatalogRule_Model_Mysql4_Rule->_saveRuleProductPrices(Array)
#7 /var/www/vhosts/strona-www/httpdocs/app/code/core/Mage/CatalogRule/Model/Observer.php(195): Mage_CatalogRule_Model_Mysql4_Rule->applyAllRulesForDateRange()
#8 [internal function]: Mage_CatalogRule_Model_Observer->dailyCatalogUpdate(Object(Aoe_Scheduler_Model_Schedule))
#9 /var/www/vhosts/strona-www/httpdocs/app/code/local/Aoe/Scheduler/Model/Observer.php(73): call_user_func_array(Array, Array)
#10 /var/www/vhosts/strona-www/httpdocs/app/code/core/Mage/Core/Model/App.php(1272): Aoe_Scheduler_Model_Observer->dispatch(Object(Varien_Event_Observer))
#11 /var/www/vhosts/strona-www/httpdocs/app/code/core/Mage/Core/Model/App.php(1253): Mage_Core_Model_App->_callObserverMethod(Object(Aoe_Scheduler_Model_Observer), 'dispatch', Object(Varien_Event_Observer))
#12 /var/www/vhosts/strona-www/httpdocs/app/Mage.php(416): Mage_Core_Model_App->dispatchEvent('default', Array)
#13 /var/www/vhosts/strona-www/httpdocs/cron.php(44): Mage::dispatchEvent('default')
#14 {main}
Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 4' in /var/www/vhosts/strona-www/httpdocs/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /var/www/vhosts/strona-www/httpdocs/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/vhosts/strona-www/httpdocs/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/strona-www/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('replace into ca...', Array)
#3 /var/www/vhosts/strona-www/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(337): Zend_Db_Adapter_Pdo_Abstract->query('replace into ca...', Array)
#4 /var/www/vhosts/strona-www/httpdocs/app/code/core/Mage/CatalogRule/Model/Mysql4/Rule.php(600): Varien_Db_Adapter_Pdo_Mysql->query('replace into ca...')
#5 /var/www/vhosts/strona-www/httpdocs/app/code/core/Mage/CatalogRule/Model/Mysql4/Rule.php(506): Mage_CatalogRule_Model_Mysql4_Rule->_saveRuleProductPrices(Array)
#6 /var/www/vhosts/strona-www/httpdocs/app/code/core/Mage/CatalogRule/Model/Observer.php(195): Mage_CatalogRule_Model_Mysql4_Rule->applyAllRulesForDateRange()
#7 [internal function]: Mage_CatalogRule_Model_Observer->dailyCatalogUpdate(Object(Aoe_Scheduler_Model_Schedule))
#8 /var/www/vhosts/strona-www/httpdocs/app/code/local/Aoe/Scheduler/Model/Observer.php(73): call_user_func_array(Array, Array)
#9 /var/www/vhosts/strona-www/httpdocs/app/code/core/Mage/Core/Model/App.php(1272): Aoe_Scheduler_Model_Observer->dispatch(Object(Varien_Event_Observer))
#10 /var/www/vhosts/strona-www/httpdocs/app/code/core/Mage/Core/Model/App.php(1253): Mage_Core_Model_App->_callObserverMethod(Object(Aoe_Scheduler_Model_Observer), 'dispatch', Object(Varien_Event_Observer))
#11 /var/www/vhosts/strona-www/httpdocs/app/Mage.php(416): Mage_Core_Model_App->dispatchEvent('default', Array)
#12 /var/www/vhosts/strona-www/httpdocs/cron.php(44): Mage::dispatchEvent('default')
#13 {main}oraz wynik z ręcznego wywołania success
Kod: Zaznacz cały
Ran "catalogrule_apply_all" (Duration: 0 sec)
"catalogrule_apply_all" messages:
Mage_CatalogRule_Model_Observer
Teraz jest 8 cze 2025, o 18:01
News
Site map
SitemapIndex
RSS Feed