Warning: Invalid argument supplied for foreach() in /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/module/Shop/src/Shop/Model/ItemsPropertiesTable.php on line 279
/var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/vendor/ZF2/library/Zend/Db/Adapter/Driver/Pdo/Statement.php:245
Statement could not be executed (42000 - 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%5B%5D ON p31%5B%5D.item=ii.id AND p31%5B%5D.property=31%5B%5D WHERE ()) AS i...' at line 4)
#0 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/module/Shop/src/Shop/Model/ItemsPropertiesTable.php(324): Zend\Db\Adapter\Driver\Pdo\Statement->execute(Array) #1 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/module/Shop/src/Shop/Controller/ShopController.php(154): Shop\Model\ItemsPropertiesTable->getFilterProperties('875', Array) #2 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/vendor/ZF2/library/Zend/Mvc/Controller/AbstractActionController.php(83): Shop\Controller\ShopController->folderAction() #3 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent)) #4 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/vendor/ZF2/library/Zend/EventManager/EventManager.php(468): call_user_func(Array, Object(Zend\Mvc\MvcEvent)) #5 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/vendor/ZF2/library/Zend/EventManager/EventManager.php(207): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #6 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/vendor/ZF2/library/Zend/Mvc/Controller/AbstractController.php(117): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #7 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/vendor/ZF2/library/Zend/Mvc/DispatchListener.php(114): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response)) #8 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent)) #9 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/vendor/ZF2/library/Zend/EventManager/EventManager.php(468): call_user_func(Array, Object(Zend\Mvc\MvcEvent)) #10 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/vendor/ZF2/library/Zend/EventManager/EventManager.php(207): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #11 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/vendor/ZF2/library/Zend/Mvc/Application.php(313): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #12 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/public/index.php(17): Zend\Mvc\Application->run() #13 {main}
/var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/vendor/ZF2/library/Zend/Db/Adapter/Driver/Pdo/Statement.php:240
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%5B%5D ON p31%5B%5D.item=ii.id AND p31%5B%5D.property=31%5B%5D WHERE ()) AS i...' at line 4
#0 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/vendor/ZF2/library/Zend/Db/Adapter/Driver/Pdo/Statement.php(240): PDOStatement->execute() #1 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/module/Shop/src/Shop/Model/ItemsPropertiesTable.php(324): Zend\Db\Adapter\Driver\Pdo\Statement->execute(Array) #2 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/module/Shop/src/Shop/Controller/ShopController.php(154): Shop\Model\ItemsPropertiesTable->getFilterProperties('875', Array) #3 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/vendor/ZF2/library/Zend/Mvc/Controller/AbstractActionController.php(83): Shop\Controller\ShopController->folderAction() #4 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent)) #5 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/vendor/ZF2/library/Zend/EventManager/EventManager.php(468): call_user_func(Array, Object(Zend\Mvc\MvcEvent)) #6 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/vendor/ZF2/library/Zend/EventManager/EventManager.php(207): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #7 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/vendor/ZF2/library/Zend/Mvc/Controller/AbstractController.php(117): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #8 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/vendor/ZF2/library/Zend/Mvc/DispatchListener.php(114): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response)) #9 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent)) #10 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/vendor/ZF2/library/Zend/EventManager/EventManager.php(468): call_user_func(Array, Object(Zend\Mvc\MvcEvent)) #11 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/vendor/ZF2/library/Zend/EventManager/EventManager.php(207): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #12 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/vendor/ZF2/library/Zend/Mvc/Application.php(313): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #13 /var/www/vhosts/zen-32000087-266782.host4g.ru/zenon.migration/propool.ru/public/index.php(17): Zend\Mvc\Application->run() #14 {main}