{"name":"Database Exception","message":"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'теди baby\" яблоко-морковь%\"\n                            OR LOWE' at line 2\nThe SQL being executed was: SELECT `product`.* FROM `product` LEFT JOIN `product_catalog` ON product_catalog.product_id = product.id RIGHT JOIN `offer` ON offer.product_id = product.id LEFT JOIN `price` ON price.id = offer.price_id LEFT JOIN `supplier` ON supplier.id = price.supplier_id LEFT JOIN `supplier_region` ON supplier_region.supplier_id = supplier.id LEFT JOIN `user` ON user.id = supplier.user_id WHERE (`product_catalog`.`catalog_id` IN (2, 3)) AND (`offer`.`is_published`=1) AND (`price`.`is_deleted`=0) AND (`supplier_region`.`region_id`='2') AND (`supplier_region`.`is_deleted`=0) AND (`user`.`status` <> 2) AND ((\n                            LOWER(`product`.name) LIKE \"%пюре\"теди baby\" яблоко-морковь%\"\n                            OR LOWER(`product`.keywords) LIKE \"%пюре\"теди baby\" яблоко-морковь%\"\n                            OR LOWER(`product`.barcode) LIKE \"%пюре\"теди baby\" яблоко-морковь%\"\n                            OR CONCAT_WS(\" \", `product`.name, `product`.unit) LIKE \"%пюре\"теди baby\" яблоко-морковь%\"\n                            OR CONCAT_WS(\" \", `product`.name, `product`.unit,`product`.pack) LIKE \"%пюре\"теди baby\" яблоко-морковь%\"\n                        ) AND (\n                            LOWER(`product`.name) LIKE \"%2%\"\n                            OR LOWER(`product`.keywords) LIKE \"%2%\"\n                            OR LOWER(`product`.barcode) LIKE \"%2%\"\n                            OR CONCAT_WS(\" \", `product`.name, `product`.unit) LIKE \"%2%\"\n                            OR CONCAT_WS(\" \", `product`.name, `product`.unit,`product`.pack) LIKE \"%2%\"\n\n                        )) GROUP BY `product`.`id` LIMIT 10","code":42000,"type":"yii\\db\\Exception","file":"/opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/db/Schema.php","line":674,"stack-trace":["#0 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/db/Command.php(1295): yii\\db\\Schema->convertException(Object(PDOException), 'SELECT `product...')","#1 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/db/Command.php(1158): yii\\db\\Command->internalExecute('SELECT `product...')","#2 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/db/Command.php(399): yii\\db\\Command->queryInternal('fetchAll', NULL)","#3 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/db/Query.php(237): yii\\db\\Command->queryAll()","#4 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/db/ActiveQuery.php(133): yii\\db\\Query->all(NULL)","#5 /opt/apps/vtochku24-v2019-12-10-25-48-staging/models/searchd/ProductSearchD.php(148): yii\\db\\ActiveQuery->all()","#6 /opt/apps/vtochku24-v2019-12-10-25-48-staging/controllers/api/SearchController.php(30): app\\models\\searchd\\ProductSearchD->search(Array)","#7 [internal function]: app\\controllers\\api\\SearchController->actionIndex()","#8 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)","#9 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/base/Controller.php(157): yii\\base\\InlineAction->runWithParams(Array)","#10 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/base/Module.php(528): yii\\base\\Controller->runAction('', Array)","#11 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/web/Application.php(103): yii\\base\\Module->runAction('api/search', Array)","#12 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/base/Application.php(386): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))","#13 /opt/apps/vtochku24-v2019-12-10-25-48-staging/web/index.php(18): yii\\base\\Application->run()","#14 {main}"],"error-info":["42000",1064,"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'теди baby\" яблоко-морковь%\"\n                            OR LOWE' at line 2"],"previous":{"name":"Exception","message":"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'теди baby\" яблоко-морковь%\"\n                            OR LOWE' at line 2","code":"42000","type":"PDOException","file":"/opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/db/Command.php","line":1290,"stack-trace":["#0 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/db/Command.php(1290): PDOStatement->execute()","#1 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/db/Command.php(1158): yii\\db\\Command->internalExecute('SELECT `product...')","#2 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/db/Command.php(399): yii\\db\\Command->queryInternal('fetchAll', NULL)","#3 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/db/Query.php(237): yii\\db\\Command->queryAll()","#4 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/db/ActiveQuery.php(133): yii\\db\\Query->all(NULL)","#5 /opt/apps/vtochku24-v2019-12-10-25-48-staging/models/searchd/ProductSearchD.php(148): yii\\db\\ActiveQuery->all()","#6 /opt/apps/vtochku24-v2019-12-10-25-48-staging/controllers/api/SearchController.php(30): app\\models\\searchd\\ProductSearchD->search(Array)","#7 [internal function]: app\\controllers\\api\\SearchController->actionIndex()","#8 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)","#9 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/base/Controller.php(157): yii\\base\\InlineAction->runWithParams(Array)","#10 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/base/Module.php(528): yii\\base\\Controller->runAction('', Array)","#11 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/web/Application.php(103): yii\\base\\Module->runAction('api/search', Array)","#12 /opt/apps/vtochku24-v2019-12-10-25-48-staging/vendor/yiisoft/yii2/base/Application.php(386): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))","#13 /opt/apps/vtochku24-v2019-12-10-25-48-staging/web/index.php(18): yii\\base\\Application->run()","#14 {main}"]}}