Fatal error: Uncaught Exception: Error: 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 '), ' ') LIKE '% кс%' AND CONCAT(' ', REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(R' at line 1 Error Code : 42000 <br />SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ( (LOWER(pd.name) LIKE '%кс%' OR LOWER(pd.name) LIKE '%ks%') AND (LOWER(pd.name) LIKE '%кольцо%' OR LOWER(pd.name) LIKE '%kolco%') OR LCASE(p.model) = 'кс кольцо' OR LCASE(p.sku) = 'кс кольцо' OR LCASE(p.upc) = 'кс кольцо' OR LCASE(p.ean) = 'кс кольцо' OR LCASE(p.jan) = 'кс кольцо' OR LCASE(p.isbn) = 'кс кольцо' OR LCASE(p.mpn) = 'кс кольцо') AND (CONCAT(' ', REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(LCASE(REPLACE(REPLACE(pd.name, 'Ё', 'е'), 'ё', 'е')), '-', ' '), '/', ' '), ',', ' '), '.', ' '), '_', ' '), '(', ' '), ')', ' '), '"', ' '), ' '), ' ') LIKE '% кс%' AND CONCAT(' ', REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(LCASE(REPLACE(REPLACE(pd.name, 'Ё', 'е'), 'ё', 'е')), '-', ' '), '/', ' '), ',', ' '), '.', ' '), '_', ' '), '(', ' '), ')', ' '), '"', ' '), ' '), ' ') LIKE '% кольцо%') in /home/e/e909253c/e909253c.beget.tech/public_html/system/library/db/mpdo.php:70
Stack trace:
#0 /home/e/e909253c/e909253c.beget.tech/public_html/system/library/db.php(16): DB\mPDO->query('SELECT COUNT(DI...', Array)
#1 /home/e/e909253c/e909253c.beget.tech/public_html/system/storage/modification/catalog/model/catalog/product.php(1127): DB->query('SELECT COUNT(DI...')
#2 [internal function]: ModelCatalogProduct->getTotalProducts(Array)
#3 /home/e/e909253c/e909253c.beget.tech/public_html/system/storage/modification/system/engine/loader.php(178): call_user_func_array(Array, Array)
#4 [internal function]: Loader->{closure}(Array, Array)
#5 /home/e/e909253c/e909253c.beget.tech/public_html/system/engine/proxy.php(25): call_user_func_array(Object(Closure), Array)
#6 /home/e/e909253c/e909253c.beget.tech/public_html/catalog/controller/extension/module/html.php(190): Proxy->__call('getTotalProduct...', Array)
#7 [internal function]: ControllerExtensionModuleHTML->index(Array)
#8 /home/e/e909253c/e909253c.beget.tech/public_html/system/storage/modification/system/engine/action.php(53): call_user_func_array(Array, Array)
#9 /home/e/e909253c/e909253c.beget.tech/public_html/system/storage/modification/system/engine/loader.php(24): Action->execute(Object(Registry), Array)
#10 /home/e/e909253c/e909253c.beget.tech/public_html/system/storage/modification/catalog/controller/common/content_top.php(75): Loader->controller('extension/modul...', Array)
#11 [internal function]: ControllerCommonContentTop->index(Array)
#12 /home/e/e909253c/e909253c.beget.tech/public_html/system/storage/modification/system/engine/action.php(53): call_user_func_array(Array, Array)
#13 /home/e/e909253c/e909253c.beget.tech/public_html/system/storage/modification/system/engine/loader.php(24): Action->execute(Object(Registry), Array)
#14 /home/e/e909253c/e909253c.beget.tech/public_html/catalog/controller/common/home.php(39): Loader->controller('common/content_...')
#15 [internal function]: ControllerCommonHome->index()
#16 /home/e/e909253c/e909253c.beget.tech/public_html/system/storage/modification/system/engine/action.php(53): call_user_func_array(Array, Array)
#17 /home/e/e909253c/e909253c.beget.tech/public_html/catalog/controller/startup/router.php(25): Action->execute(Object(Registry))
#18 [internal function]: ControllerStartupRouter->index()
#19 /home/e/e909253c/e909253c.beget.tech/public_html/system/storage/modification/system/engine/action.php(53): call_user_func_array(Array, Array)
#20 /home/e/e909253c/e909253c.beget.tech/public_html/system/engine/front.php(34): Action->execute(Object(Registry))
#21 /home/e/e909253c/e909253c.beget.tech/public_html/system/engine/front.php(29): Front->execute(Object(Action))
#22 /home/e/e909253c/e909253c.beget.tech/public_html/system/framework.php(103): Front->dispatch(Object(Action), Object(Action))
#23 /home/e/e909253c/e909253c.beget.tech/public_html/system/startup.php(105): require_once('/home/e/e909253...')
#24 /home/e/e909253c/e909253c.beget.tech/public_html/index.php(20): start('catalog')
#25 {main}
  thrown in /home/e/e909253c/e909253c.beget.tech/public_html/system/library/db/mpdo.php on line 70