Greetings,
I have a problem and I don't understand why, maybe someone can help me.
It happens randomly but often in the customer or sales grid.
First we had a problem like this:
{
"0": "Warning: Cannot use a scalar value as an array in \/path\/public_html\/vendor\/magento\/framework\/Session\/SessionManager.php on line 496",
"1": "<pre>#1 Magento\\Framework\\Session\\SessionManager->_addHost() called at [vendor\/magento\/framework\/Session\/SessionManager.php:220]\n#2 Magento\\Framework\\Session\\SessionManager->start() called at [generated\/code\/Magento\/Backend\/Model\/Auth\/Session\/Interceptor.php:167]\n#3 Magento\\Backend\\Model\\Auth\\Session\\Interceptor->start() called at [vendor\/magento\/framework\/Session\/SessionManager.php:140]\n#4 Magento\\Framework\\Session\\SessionManager->__construct(&Magento\\Framework\\App\\Request\\Http#0000000037bfc7ab00000000339ff389#, &Magento\\Framework\\Session\\SidResolver\\Proxy#0000000037bfc7e700000000339ff389#, &Magento\\Backend\\Model\\Session\\AdminConfig#0000000037bfc67800000000339ff389#, &Magento\\Framework\\Session\\SaveHandler#0000000037bfc69000000000339ff389#, &Magento\\Framework\\Session\\Validator#0000000037bfc69b00000000339ff389#, &Magento\\Framework\\Session\\Storage#0000000037bfc69500000000339ff389#, &Magento\\Framework\\Stdlib\\Cookie\\PhpCookieManager#0000000037bfc7d000000000339ff389#, &Magento\\Framework\\Stdlib\\Cookie\\CookieMetadataFactory#0000000037bfc7d400000000339ff389#, &Magento\\Framework\\App\\State\\Interceptor#0000000037bfc70800000000339ff389#) called at [vendor\/magento\/module-backend\/Model\/Auth\/Session.php:101]\n#5 Magento\\Backend\\Model\\Auth\\Session->__construct(&Magento\\Framework\\App\\Request\\Http#0000000037bfc7ab00000000339ff389#, &Magento\\Framework\\Session\\SidResolver\\Proxy#0000000037bfc7e700000000339ff389#, &Magento\\Backend\\Model\\Session\\AdminConfig#0000000037bfc67800000000339ff389#, &Magento\\Framework\\Session\\SaveHandler#0000000037bfc69000000000339ff389#, &Magento\\Framework\\Session\\Validator#0000000037bfc69b00000000339ff389#, &Magento\\Framework\\Session\\Storage#0000000037bfc69500000000339ff389#, &Magento\\Framework\\Stdlib\\Cookie\\PhpCookieManager#0000000037bfc7d000000000339ff389#, &Magento\\Framework\\Stdlib\\Cookie\\CookieMetadataFactory#0000000037bfc7d400000000339ff389#, &Magento\\Framework\\App\\State\\Interceptor#0000000037bfc70800000000339ff389#, &Magento\\Framework\\Acl\\Builder\\Proxy#0000000037bfc69800000000339ff389#, &Magento\\Backend\\Model\\UrlInterface\\Proxy#0000000037bfc60200000000339ff389#, &Magento\\Backend\\App\\Config#0000000037bfc61400000000339ff389#) called at [generated\/code\/Magento\/Backend\/Model\/Auth\/Session\/Interceptor.php:14]\n#6 Magento\\Backend\\Model\\Auth\\Session\\Interceptor->__construct(&Magento\\Framework\\App\\Request\\Http#0000000037bfc7ab00000000339ff389#, &Magento\\Framework\\Session\\SidResolver\\Proxy#0000000037bfc7e700000000339ff389#, &Magento\\Backend\\Model\\Session\\AdminConfig#0000000037bfc67800000000339ff389#, &Magento\\Framework\\Session\\SaveHandler#0000000037bfc69000000000339ff389#, &Magento\\Framework\\Session\\Validator#0000000037bfc69b00000000339ff389#, &Magento\\Framework\\Session\\Storage#0000000037bfc69500000000339ff389#, &Magento\\Framework\\Stdlib\\Cookie\\PhpCookieManager#0000000037bfc7d000000000339ff389#, &Magento\\Framework\\Stdlib\\Cookie\\CookieMetadataFactory#0000000037bfc7d400000000339ff389#, &Magento\\Framework\\App\\State\\Interceptor#0000000037bfc70800000000339ff389#, &Magento\\Framework\\Acl\\Builder\\Proxy#0000000037bfc69800000000339ff389#, &Magento\\Backend\\Model\\UrlInterface\\Proxy#0000000037bfc60200000000339ff389#, &Magento\\Backend\\App\\Config#0000000037bfc61400000000339ff389#) called at [vendor\/magento\/framework\/ObjectManager\/Factory\/AbstractFactory.php:116]\n#7 Magento\\Framework\\ObjectManager\\Factory\\AbstractFactory->createObject('Magento\\Backend\\...', array(&Magento\\Framework\\App\\Request\\Http#0000000037bfc7ab00000000339ff389#, &Magento\\Framework\\Session\\SidResolver\\Proxy#0000000037bfc7e700000000339ff389#, &Magento\\Backend\\Model\\Session\\AdminConfig#0000000037bfc67800000000339ff389#, &Magento\\Framework\\Session\\SaveHandler#0000000037bfc69000000000339ff389#, &Magento\\Framework\\Session\\Validator#0000000037bfc69b00000000339ff389#, &Magento\\Framework\\Session\\Storage#0000000037bfc69500000000339ff389#, &Magento\\Framework\\Stdlib\\Cookie\\PhpCookieManager#0000000037bfc7d000000000339ff389#, &Magento\\Framework\\Stdlib\\Cookie\\CookieMetadataFactory#0000000037bfc7d400000000339ff389#, &Magento\\Framework\\App\\State\\Interceptor#0000000037bfc70800000000339ff389#, &Magento\\Framework\\Acl\\Builder\\Proxy#0000000037bfc69800000000339ff389#, &Magento\\Backend\\Model\\UrlInterface\\Proxy#0000000037bfc60200000000339ff389#, &Magento\\Backend\\App\\Config#0000000037bfc61400000000339ff389#)) called at [vendor\/magento\/framework\/ObjectManager\/Factory\/Dynamic\/Developer.php:66]\n#8 Magento\\Framework\\ObjectManager\\Factory\\Dynamic\\Developer->create('Magento\\Backend\\...') called at [vendor\/magento\/framework\/ObjectManager\/ObjectManager.php:70]\n#9 Magento\\Framework\\ObjectManager\\ObjectManager->get('Magento\\Backend\\...') called at [vendor\/magento\/framework\/ObjectManager\/Factory\/AbstractFactory.php:160]\n#10 Magento\\Framework\\ObjectManager\\Factory\\AbstractFactory->resolveArgument(array('instance' => 'Magento\\Backend\\...'), 'Magento\\Backend\\...', NULL, 'authStorage', 'Magento\\Backend\\...') called at [vendor\/magento\/framework\/ObjectManager\/Factory\/AbstractFactory.php:246]\n#11 Magento\\Framework\\ObjectManager\\Factory\\AbstractFactory->resolveArgumentsInRuntime('Magento\\Backend\\...', array(array('eventManager', 'Magento\\Framewor...', true, NULL), array('backendData', 'Magento\\Backend\\...', true, NULL), array('authStorage', 'Magento\\Backend\\...', true, NULL), array('credentialStorag...', 'Magento\\Backend\\...', true, NULL), array('coreConfig', 'Magento\\Framewor...', true, NULL), array('modelFactory', 'Magento\\Framewor...', true, NULL)), array()) called at [vendor\/magento\/framework\/ObjectManager\/Factory\/Dynamic\/Developer.php:34]\n#12 Magento\\Framework\\ObjectManager\\Factory\\Dynamic\\Developer->_resolveArguments('Magento\\Backend\\...', array(array('eventManager', 'Magento\\Framewor...', true, NULL), array('backendData', 'Magento\\Backend\\...', true, NULL), array('authStorage', 'Magento\\Backend\\...', true, NULL), array('credentialStorag...', 'Magento\\Backend\\...', true, NULL), array('coreConfig', 'Magento\\Framewor...', true, NULL), array('modelFactory', 'Magento\\Framewor...', true, NULL)), array()) called at [vendor\/magento\/framework\/ObjectManager\/Factory\/Dynamic\/Developer.php:59]\n#13 Magento\\Framework\\ObjectManager\\Factory\\Dynamic\\Developer->create('Magento\\Backend\\...') called at [vendor\/magento\/framework\/ObjectManager\/ObjectManager.php:70]\n#14 Magento\\Framework\\ObjectManager\\ObjectManager->get('Magento\\Backend\\...') called at [vendor\/magento\/framework\/ObjectManager\/Factory\/AbstractFactory.php:160]\n#15 Magento\\Framework\\ObjectManager\\Factory\\AbstractFactory->resolveArgument(array('instance' => 'Magento\\Backend\\...'), 'Magento\\Backend\\...', NULL, 'auth', 'Magento\\Backend\\...') called at [vendor\/magento\/framework\/ObjectManager\/Factory\/AbstractFactory.php:246]\n#16 Magento\\Framework\\ObjectManager\\Factory\\AbstractFactory->resolveArgumentsInRuntime('Magento\\Backend\\...', array(array('auth', 'Magento\\Backend\\...', true, NULL), array('formKeyValidator', 'Magento\\Framewor...', true, NULL), array('backendUrl', 'Magento\\Backend\\...', true, NULL), array('redirectFactory', 'Magento\\Framewor...', true, NULL), array('rawResultFactory', 'Magento\\Framewor...', true, NULL)), array()) called at [vendor\/magento\/framework\/ObjectManager\/Factory\/Dynamic\/Developer.php:34]\n#17 Magento\\Framework\\ObjectManager\\Factory\\Dynamic\\Developer->_resolveArguments('Magento\\Backend\\...', array(array('auth', 'Magento\\Backend\\...', true, NULL), array('formKeyValidator', 'Magento\\Framewor...', true, NULL), array('backendUrl', 'Magento\\Backend\\...', true, NULL), array('redirectFactory', 'Magento\\Framewor...', true, NULL), array('rawResultFactory', 'Magento\\Framewor...', true, NULL)), array()) called at [vendor\/magento\/framework\/ObjectManager\/Factory\/Dynamic\/Developer.php:59]\n#18 Magento\\Framework\\ObjectManager\\Factory\\Dynamic\\Developer->create('Magento\\Backend\\...') called at [vendor\/magento\/framework\/ObjectManager\/ObjectManager.php:70]\n#19 Magento\\Framework\\ObjectManager\\ObjectManager->get('Magento\\Backend\\...') called at [vendor\/magento\/framework\/ObjectManager\/Factory\/AbstractFactory.php:196]\n#20 Magento\\Framework\\ObjectManager\\Factory\\AbstractFactory->parseArray(array('csrf_validator' => array('instance' => 'CsrfRequestValid...'), 'http_method_vali...' => array('instance' => 'Magento\\Framewor...'))) called at [vendor\/magento\/framework\/ObjectManager\/Factory\/AbstractFactory.php:172]\n#21 Magento\\Framework\\ObjectManager\\Factory\\AbstractFactory->resolveArgument(array('csrf_validator' => array('instance' => 'CsrfRequestValid...'), 'http_method_vali...' => array('instance' => 'Magento\\Framewor...')), NULL, NULL, 'validators', 'RequestValidator') called at [vendor\/magento\/framework\/ObjectManager\/Factory\/AbstractFactory.php:246]\n#22 Magento\\Framework\\ObjectManager\\Factory\\AbstractFactory->resolveArgumentsInRuntime('RequestValidator', array(array('validators', NULL, true, NULL)), array('validators' => array('csrf_validator' => array('instance' => 'CsrfRequestValid...'), 'http_method_vali...' => array('instance' => 'Magento\\Framewor...')))) called at [vendor\/magento\/framework\/ObjectManager\/Factory\/Dynamic\/Developer.php:34]\n#23 Magento\\Framework\\ObjectManager\\Factory\\Dynamic\\Developer->_resolveArguments('RequestValidator', array(array('validators', NULL, true, NULL)), array('validators' => array('csrf_validator' => array('instance' => 'CsrfRequestValid...'), 'http_method_vali...' => array('instance' => 'Magento\\Framewor...')))) called at [vendor\/magento\/framework\/ObjectManager\/Factory\/Dynamic\/Developer.php:59]\n#24 Magento\\Framework\\ObjectManager\\Factory\\Dynamic\\Developer->create('RequestValidator') called at [vendor\/magento\/framework\/ObjectManager\/ObjectManager.php:70]\n#25 Magento\\Framework\\ObjectManager\\ObjectManager->get('RequestValidator') called at [vendor\/magento\/framework\/App\/FrontController.php:71]\n#26 Magento\\Framework\\App\\FrontController->__construct(&Magento\\Framework\\App\\RouterList#0000000037bfc67200000000339ff389#, &Magento\\Framework\\App\\Response\\Http\\Interceptor#0000000037bfc7d600000000339ff389#, NULL, NULL, NULL) called at [generated\/code\/Magento\/Framework\/App\/FrontController\/Interceptor.php:14]\n#27 Magento\\Framework\\App\\FrontController\\Interceptor->__construct(&Magento\\Framework\\App\\RouterList#0000000037bfc67200000000339ff389#, &Magento\\Framework\\App\\Response\\Http\\Interceptor#0000000037bfc7d600000000339ff389#, NULL, NULL, NULL) called at [vendor\/magento\/framework\/ObjectManager\/Factory\/AbstractFactory.php:116]\n#28 Magento\\Framework\\ObjectManager\\Factory\\AbstractFactory->createObject('Magento\\Framewor...', array(&Magento\\Framework\\App\\RouterList#0000000037bfc67200000000339ff389#, &Magento\\Framework\\App\\Response\\Http\\Interceptor#0000000037bfc7d600000000339ff389#, NULL, NULL, NULL)) called at [vendor\/magento\/framework\/ObjectManager\/Factory\/Dynamic\/Developer.php:66]\n#29 Magento\\Framework\\ObjectManager\\Factory\\Dynamic\\Developer->create('Magento\\Framewor...') called at [vendor\/magento\/framework\/ObjectManager\/ObjectManager.php:70]\n#30 Magento\\Framework\\ObjectManager\\ObjectManager->get('Magento\\Framewor...') called at [vendor\/magento\/framework\/App\/Http.php:136]\n#31 Magento\\Framework\\App\\Http->launch() called at [generated\/code\/Magento\/Framework\/App\/Http\/Interceptor.php:24]\n#32 Magento\\Framework\\App\\Http\\Interceptor->launch() called at [vendor\/magento\/framework\/App\/Bootstrap.php:261]\n#33 Magento\\Framework\\App\\Bootstrap->run(&Magento\\Framework\\App\\Http\\Interceptor#0000000037bfc7d900000000339ff389#) called at [index.php:39]\n<\/pre>",
"url": "\/admin_path\/sales\/order\/index\/key\/2edc3f0ed792ca4a373568bb83d7c186a2e23dca87d47a092b8c05717a19411f\/",
"script_name": "\/index.php"
}So I changed in _getHosts()
vendor/magento/framework/Session/SessionManager.php)
This: return $_SESSION[self::HOST_KEY] ?? [];
To this: return isset($_SESSION[self::HOST_KEY]) ? [$_SESSION[self::HOST_KEY]] : [];
And now I have another problem:
{
"0": "Warning: PDO::quote() expects parameter 1 to be string, object given in \/PATH\/public_html\/vendor\/magento\/zendframework1\/library\/Zend\/Db\/Adapter\/Pdo\/Abstract.php on line 296",
"1": "<pre>#1 PDO->quote(&Magento\\User\\Model\\User\\Interceptor#00000000781e6e2f0000000078de6f03#) called at [vendor\/magento\/zendframework1\/library\/Zend\/Db\/Adapter\/Pdo\/Abstract.php:296]\n#2 Zend_Db_Adapter_Pdo_Abstract->_quote(&Magento\\User\\Model\\User\\Interceptor#00000000781e6e2f0000000078de6f03#) called at [vendor\/magento\/zendframework1\/library\/Zend\/Db\/Adapter\/Abstract.php:906]\n#3 Zend_Db_Adapter_Abstract->quote(&Magento\\User\\Model\\User\\Interceptor#00000000781e6e2f0000000078de6f03#, NULL) called at [vendor\/magento\/zendframework1\/library\/Zend\/Db\/Adapter\/Abstract.php:931]\n#4 Zend_Db_Adapter_Abstract->quoteInto('`authorization_r...', &Magento\\User\\Model\\User\\Interceptor#00000000781e6e2f0000000078de6f03#, NULL, NULL) called at [vendor\/magento\/framework\/DB\/Adapter\/Pdo\/Mysql.php:1497]\n#5 Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->quoteInto('`authorization_r...', &Magento\\User\\Model\\User\\Interceptor#00000000781e6e2f0000000078de6f03#, NULL) called at [vendor\/magento\/zendframework1\/library\/Zend\/Db\/Select.php:1031]\n#6 Zend_Db_Select->_where('`authorization_r...', &Magento\\User\\Model\\User\\Interceptor#00000000781e6e2f0000000078de6f03#, NULL, true) called at [vendor\/magento\/zendframework1\/library\/Zend\/Db\/Select.php:496]\n#7 Zend_Db_Select->where('`authorization_r...', &Magento\\User\\Model\\User\\Interceptor#00000000781e6e2f0000000078de6f03#, NULL) called at [vendor\/magento\/framework\/DB\/Select.php:120]\n#8 Magento\\Framework\\DB\\Select->where('`authorization_r...', &Magento\\User\\Model\\User\\Interceptor#00000000781e6e2f0000000078de6f03#) called at [vendor\/magento\/framework\/Model\/ResourceModel\/Db\/AbstractDb.php:378]\n#9 Magento\\Framework\\Model\\ResourceModel\\Db\\AbstractDb->_getLoadSelect('`authorization_r...', &Magento\\User\\Model\\User\\Interceptor#00000000781e6e2f0000000078de6f03#, &Magento\\Authorization\\Model\\Role#00000000781e6b050000000078de6f03#) called at [vendor\/magento\/framework\/Model\/ResourceModel\/Db\/AbstractDb.php:349]\n#10 Magento\\Framework\\Model\\ResourceModel\\Db\\AbstractDb->load(&Magento\\Authorization\\Model\\Role#00000000781e6b050000000078de6f03#, &Magento\\User\\Model\\User\\Interceptor#00000000781e6e2f0000000078de6f03#, 'role_id') called at [vendor\/magento\/framework\/Model\/AbstractModel.php:540]\n#11 Magento\\Framework\\Model\\AbstractModel->load(&Magento\\User\\Model\\User\\Interceptor#00000000781e6e2f0000000078de6f03#, NULL, NULL) called at [vendor\/magento\/framework\/Model\/AbstractModel.php:540]\n#12 Magento\\Framework\\Model\\AbstractModel->load(NULL) called at [vendor\/magento\/module-user\/Model\/User.php:650]\n#13 Magento\\User\\Model\\User->reload() called at [vendor\/magento\/module-backend\/App\/Action\/Plugin\/Authentication.php:122]\n#14 Magento\\Backend\\App\\Action\\Plugin\\Authentication->aroundDispatch(&Magento\\Ui\\Controller\\Adminhtml\\Index\\Render\\Interceptor#00000000781e6cc90000000078de6f03#, &Closure#00000000781e6cce0000000078de6f03#, &Magento\\Framework\\App\\Request\\Http#00000000781e6f2f0000000078de6f03#) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:135]\n#15 Magento\\Ui\\Controller\\Adminhtml\\Index\\Render\\Interceptor->Magento\\Framework\\Interception\\{closure}(&Magento\\Framework\\App\\Request\\Http#00000000781e6f2f0000000078de6f03#) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#16 Magento\\Ui\\Controller\\Adminhtml\\Index\\Render\\Interceptor->___callPlugins('dispatch', array(&Magento\\Framework\\App\\Request\\Http#00000000781e6f2f0000000078de6f03#), NULL) called at [generated\/code\/Magento\/Ui\/Controller\/Adminhtml\/Index\/Render\/Interceptor.php:26]\n#17 Magento\\Ui\\Controller\\Adminhtml\\Index\\Render\\Interceptor->dispatch(&Magento\\Framework\\App\\Request\\Http#00000000781e6f2f0000000078de6f03#) called at [vendor\/magento\/framework\/App\/FrontController.php:159]\n#18 Magento\\Framework\\App\\FrontController->processRequest(&Magento\\Framework\\App\\Request\\Http#00000000781e6f2f0000000078de6f03#, &Magento\\Ui\\Controller\\Adminhtml\\Index\\Render\\Interceptor#00000000781e6cc90000000078de6f03#) called at [vendor\/magento\/framework\/App\/FrontController.php:99]\n#19 Magento\\Framework\\App\\FrontController->dispatch(&Magento\\Framework\\App\\Request\\Http#00000000781e6f2f0000000078de6f03#) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#20 Magento\\Framework\\App\\FrontController\\Interceptor->___callParent('dispatch', array(&Magento\\Framework\\App\\Request\\Http#00000000781e6f2f0000000078de6f03#)) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#21 Magento\\Framework\\App\\FrontController\\Interceptor->Magento\\Framework\\Interception\\{closure}(&Magento\\Framework\\App\\Request\\Http#00000000781e6f2f0000000078de6f03#) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#22 Magento\\Framework\\App\\FrontController\\Interceptor->___callPlugins('dispatch', array(&Magento\\Framework\\App\\Request\\Http#00000000781e6f2f0000000078de6f03#), array(array('default_store_se...', 'page_cache_from_...', 'storeCookieValid...', 'install', 'configHash'))) called at [generated\/code\/Magento\/Framework\/App\/FrontController\/Interceptor.php:26]\n#23 Magento\\Framework\\App\\FrontController\\Interceptor->dispatch(&Magento\\Framework\\App\\Request\\Http#00000000781e6f2f0000000078de6f03#) called at [vendor\/magento\/framework\/App\/Http.php:137]\n#24 Magento\\Framework\\App\\Http->launch() called at [generated\/code\/Magento\/Framework\/App\/Http\/Interceptor.php:24]\n#25 Magento\\Framework\\App\\Http\\Interceptor->launch() called at [vendor\/magento\/framework\/App\/Bootstrap.php:261]\n#26 Magento\\Framework\\App\\Bootstrap->run(&Magento\\Framework\\App\\Http\\Interceptor#00000000781e6fc80000000078de6f03#) called at [index.php:39]\n<\/pre>",
"url": "\/admin_URL\/mui\/index\/render\/key\/7ea285897c8fb6fe8d7882a615b79164e2032445c1bb582463e4e6f705c3d070\/?namespace=sales_order_grid&search=&filters%5Bplaceholder%5D=true&paging%5BpageSize%5D=20&paging%5Bcurrent%5D=1&sorting%5Bfield%5D=created_at&sorting%5Bdirection%5D=desc&isAjax=true",
"script_name": "\/index.php"
} So is there someone who can help me with it? Or just describe me why this is happening?
Thanks in advance 