Error: Error: Table 'bolgarka4.oc_bolgarka_search' doesn't exist
Error No: 1146
SELECT `p`.`product_id`, `pd`.`name`, `p`.`image`, `p`.`price`, `p`.`quantity`,
SUM(`s2`.`weight`) AS `score`
FROM `oc_bolgarka_search` `s1`
JOIN `oc_bolgarka_search` `s2`
ON (`s2`.`token` = `s1`.`token` AND `s2`.`product_id` <> `s1`.`product_id`)
JOIN `oc_product` `p` ON (`p`.`product_id` = `s2`.`product_id`)
JOIN `oc_product_description` `pd`
ON (`pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = '2')
JOIN `oc_product_to_store` `p2s`
ON (`p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = '0')
WHERE `s1`.`product_id` = '611'
AND `p`.`status` = '1'
AND `p`.`date_available` <= NOW()
-- та же подкатегория
AND EXISTS (SELECT 1 FROM `oc_product_to_category` `a`
JOIN `oc_product_to_category` `b` ON (`b`.`category_id` = `a`.`category_id`)
WHERE `a`.`product_id` = '611' AND `b`.`product_id` = `p`.`product_id`)
-- слишком частые слова о схожести не говорят
AND (SELECT COUNT(*) FROM `oc_bolgarka_search` `c`
WHERE `c`.`token` = `s1`.`token`) <= 120
-- то, что уже показано в «Смотрите также»
AND NOT EXISTS (SELECT 1 FROM `oc_product_related` `r`
WHERE `r`.`product_id` = '611' AND `r`.`related_id` = `p`.`product_id`)
GROUP BY `p`.`product_id`
ORDER BY `score` DESC, (`p`.`quantity` > 0) DESC,
ABS(`p`.`price` - (SELECT `price` FROM `oc_product` WHERE `product_id` = '611')) ASC
LIMIT 6
File: /var/www/bolgar.kz/system/library/db/mysqli.php
Line: 122
Backtrace: 0
File: /var/www/bolgar.kz/system/library/db.php
Line: 54
Class: Opencart\System\Library\DB\MySQLi
Function: query
Backtrace: 1
File: /var/www/bolgar.kz/extension/bolgarka/catalog/model/catalog/search.php
Line: 465
Class: Opencart\System\Library\DB
Function: query
Backtrace: 2
File: /var/www/bolgar.kz/system/engine/loader.php
Line: 351
Class: Opencart\Catalog\Model\Extension\Bolgarka\Catalog\Search
Function: getSimilar
Backtrace: 3
File: /var/www/bolgar.kz/system/engine/proxy.php
Line: 91
Class: Opencart\System\Engine\Loader
Function: Opencart\System\Engine\{closure}
Backtrace: 4
File: /var/www/bolgar.kz/extension/bolgarka/catalog/controller/event/theme.php
Line: 1127
Class: Opencart\System\Engine\Proxy
Function: __call
Backtrace: 5
File: /var/www/bolgar.kz/extension/bolgarka/catalog/controller/event/theme.php
Line: 1036
Class: Opencart\Catalog\Controller\Extension\Bolgarka\Event\Theme
Function: similar
Backtrace: 6
File: /var/www/bolgar.kz/extension/bolgarka/catalog/controller/event/theme.php
Line: 160
Class: Opencart\Catalog\Controller\Extension\Bolgarka\Event\Theme
Function: product
Backtrace: 7
File: /var/www/bolgar.kz/system/engine/action.php
Line: 96
Class: Opencart\Catalog\Controller\Extension\Bolgarka\Event\Theme
Function: index
Backtrace: 8
File: /var/www/bolgar.kz/system/engine/event.php
Line: 72
Class: Opencart\System\Engine\Action
Function: execute
Backtrace: 9
File: /var/www/bolgar.kz/system/engine/loader.php
Line: 184
Class: Opencart\System\Engine\Event
Function: trigger
Backtrace: 10
File: /var/www/bolgar.kz/catalog/controller/product/product.php
Line: 466
Class: Opencart\System\Engine\Loader
Function: view
Backtrace: 11
File: /var/www/bolgar.kz/system/engine/action.php
Line: 96
Class: Opencart\Catalog\Controller\Product\Product
Function: index
Backtrace: 12
File: /var/www/bolgar.kz/system/framework.php
Line: 275
Class: Opencart\System\Engine\Action
Function: execute
Backtrace: 13
File: /var/www/bolgar.kz/index.php
Line: 21
Function: require_once