search

thehcginstitute-com / m1

thehcginstitute.com/store (OpenMage LTS 19.5.2)
https://upwork.com/fl/mage2pro
0 stars 0 forks source link

`Ebizmarts_MailChimp`: «Column 'scope' cannot be null, query was: INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES (?, ?, ?, ?)» #508

Closed dmitrii-fediuk closed 7 months ago

dmitrii-fediuk commented 8 months ago 
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'scope' cannot be null, query was: INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES (?, ?, ?, ?)
[
    Command: /home/thehcg-prod/public_html/store/cron.php -mdefault
    OpenMage: 19.5.2
    PHP: 7.4.33
]

1   df_log
    app/code/local/Df/Qa/lib/log.php:27

2   Ebizmarts_MailChimp_Helper_Data::logError
    app/code/community/Ebizmarts/MailChimp/Helper/Data.php:905

3   Ebizmarts_MailChimp_Model_Api_Batches::sendStoreSubscriberBatch
    app/code/community/Ebizmarts/MailChimp/Model/Api/Batches.php:689

4   Ebizmarts_MailChimp_Model_Api_Batches::_sendSubscriberBatches
    app/code/community/Ebizmarts/MailChimp/Model/Api/Batches.php:610

5   Ebizmarts_MailChimp_Model_Api_Batches::handleSubscriberBatches
    app/code/community/Ebizmarts/MailChimp/Model/Api/Batches.php:257

6   Ebizmarts_MailChimp_Model_Cron::syncSubscriberBatchData
    app/code/community/Ebizmarts/MailChimp/Model/Cron.php:41

7   Aoe_Scheduler_Model_Observer::dispatch
    app/code/community/Aoe/Scheduler/Model/Observer.php:66

8   Mage_Core_Model_App::_callObserverMethod
    app/code/core/Mage/Core/Model/App.php:1399

9   Mage_Core_Model_App::dispatchEvent
    app/code/core/Mage/Core/Model/App.php:1377

10  Mage::dispatchEvent
    app/Mage.php:508
dmitrii-fediuk commented 8 months ago

It can be related to https://github.com/thehcginstitute-com/m1/issues/504 and https://github.com/thehcginstitute-com/m1/issues/495

dmitrii-fediuk commented 7 months ago 
[
    Command: cron.php -mdefault
    OpenMage: 19.5.2
    PHP: 7.4.33
]
EXCEPTION
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'scope' cannot be null, query was: INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES (?, ?, ?, ?)
************************************
1   PDOStatement::execute
    vendor/shardj/zf1-future/library/Zend/Db/Statement/Pdo.php:228

2   Zend_Db_Statement_Pdo::_execute
    lib/Varien/Db/Statement/Pdo/Mysql.php:98

3   Varien_Db_Statement_Pdo_Mysql::_execute
    vendor/shardj/zf1-future/library/Zend/Db/Statement.php:303

4   Zend_Db_Statement::execute
    vendor/shardj/zf1-future/library/Zend/Db/Adapter/Abstract.php:480

5   Zend_Db_Adapter_Abstract::query
    vendor/shardj/zf1-future/library/Zend/Db/Adapter/Pdo/Abstract.php:244

6   Zend_Db_Adapter_Pdo_Abstract::query
    lib/Varien/Db/Adapter/Pdo/Mysql.php:486

7   Varien_Db_Adapter_Pdo_Mysql::query
    vendor/shardj/zf1-future/library/Zend/Db/Adapter/Abstract.php:577

8   Zend_Db_Adapter_Abstract::insert
    app/code/core/Mage/Core/Model/Resource/Config.php:188

9   Mage_Core_Model_Resource_Config::saveConfig
    app/code/core/Mage/Core/Model/Config.php:1657

10  Mage_Core_Model_Config::saveConfig
    app/code/community/Ebizmarts/MailChimp/Helper/Data.php:1608

11  Ebizmarts_MailChimp_Helper_Data::saveMailchimpConfig
    app/code/community/Ebizmarts/MailChimp/Model/Api/Subscribers.php:97

12  Ebizmarts_MailChimp_Model_Api_Subscribers::createBatchJson
    app/code/community/Ebizmarts/MailChimp/Model/Api/Batches.php:646

13  Ebizmarts_MailChimp_Model_Api_Batches::sendStoreSubscriberBatch
    app/code/community/Ebizmarts/MailChimp/Model/Api/Batches.php:606

14  Ebizmarts_MailChimp_Model_Api_Batches::_sendSubscriberBatches
    app/code/community/Ebizmarts/MailChimp/Model/Api/Batches.php:250

15  Ebizmarts_MailChimp_Model_Api_Batches::handleSubscriberBatches
    app/code/community/Ebizmarts/MailChimp/Model/Cron.php:41

16  Ebizmarts_MailChimp_Model_Cron::syncSubscriberBatchData
    app/code/community/Aoe/Scheduler/Model/Observer.php:66

17  Aoe_Scheduler_Model_Observer::dispatch
    app/code/core/Mage/Core/Model/App.php:1399

18  Mage_Core_Model_App::_callObserverMethod
    app/code/core/Mage/Core/Model/App.php:1377

19  Mage_Core_Model_App::dispatchEvent
    app/Mage.php:508

20  Mage::dispatchEvent
    cron.php:73

1   Zend_Db_Statement_Pdo::_execute
    vendor/shardj/zf1-future/library/Zend/Db/Statement/Pdo.php:235

2   Varien_Db_Statement_Pdo_Mysql::_execute
    lib/Varien/Db/Statement/Pdo/Mysql.php:98

3   Zend_Db_Statement::execute
    vendor/shardj/zf1-future/library/Zend/Db/Statement.php:303

4   Zend_Db_Adapter_Abstract::query
    vendor/shardj/zf1-future/library/Zend/Db/Adapter/Abstract.php:480

5   Zend_Db_Adapter_Pdo_Abstract::query
    vendor/shardj/zf1-future/library/Zend/Db/Adapter/Pdo/Abstract.php:244

6   Varien_Db_Adapter_Pdo_Mysql::query
    lib/Varien/Db/Adapter/Pdo/Mysql.php:486

7   Zend_Db_Adapter_Abstract::insert
    vendor/shardj/zf1-future/library/Zend/Db/Adapter/Abstract.php:577

8   Mage_Core_Model_Resource_Config::saveConfig
    app/code/core/Mage/Core/Model/Resource/Config.php:188

9   Mage_Core_Model_Config::saveConfig
    app/code/core/Mage/Core/Model/Config.php:1657

10  Ebizmarts_MailChimp_Helper_Data::saveMailchimpConfig
    app/code/community/Ebizmarts/MailChimp/Helper/Data.php:1608

11  Ebizmarts_MailChimp_Model_Api_Subscribers::createBatchJson
    app/code/community/Ebizmarts/MailChimp/Model/Api/Subscribers.php:97

12  Ebizmarts_MailChimp_Model_Api_Batches::sendStoreSubscriberBatch
    app/code/community/Ebizmarts/MailChimp/Model/Api/Batches.php:646

13  Ebizmarts_MailChimp_Model_Api_Batches::_sendSubscriberBatches
    app/code/community/Ebizmarts/MailChimp/Model/Api/Batches.php:606

14  Ebizmarts_MailChimp_Model_Api_Batches::handleSubscriberBatches
    app/code/community/Ebizmarts/MailChimp/Model/Api/Batches.php:250

15  Ebizmarts_MailChimp_Model_Cron::syncSubscriberBatchData
    app/code/community/Ebizmarts/MailChimp/Model/Cron.php:41

16  Aoe_Scheduler_Model_Observer::dispatch
    app/code/community/Aoe/Scheduler/Model/Observer.php:66

17  Mage_Core_Model_App::_callObserverMethod
    app/code/core/Mage/Core/Model/App.php:1399

18  Mage_Core_Model_App::dispatchEvent
    app/code/core/Mage/Core/Model/App.php:1377

19  Mage::dispatchEvent
    app/Mage.php:508