Error: Error: Table 'u545089396_RMkJH.gyab_product_special' doesn't exist
Error No: 1146
SELECT p.product_id, ( SELECT AVG(rating) total FROM `gyab_review` r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price FROM `gyab_product_discount` pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1 ) discount, ( SELECT price FROM `gyab_product_special` ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1 ) special, pw.viewed as `p.viewed`, if (p.quantity, 1, 0) in_stock FROM `gyab_product` p LEFT JOIN gyab_product_viewed pw ON (p.product_id = pw.product_id) LEFT JOIN `gyab_product_description` pd ON (p.product_id = pd.product_id) LEFT JOIN `gyab_product_to_store` p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '1' AND EXISTS (SELECT product_id FROM `gyab_product_special` ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))) GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 9999 File: /home/u545089396/domains/theadami.com/public_html/system/library/db/mysqli.php Line: 122 Backtrace: 0 File: /home/u545089396/domains/theadami.com/public_html/system/library/db.php Line: 54 Class: Opencart\System\Library\DB\MySQLi Function: query Backtrace: 1 File: /home/u545089396/domains/theadami.com/public_html/catalog/model/journal3/filter.php Line: 892 Class: Opencart\System\Library\DB Function: query Backtrace: 2 File: /home/u545089396/domains/theadami.com/public_html/system/engine/loader.php Line: 343 Class: ModelJournal3Filter Function: getProducts Backtrace: 3 File: /home/u545089396/domains/theadami.com/public_html/system/engine/proxy.php Line: 87 Class: Opencart\System\Engine\Loader Function: Opencart\System\Engine\{closure} Backtrace: 4 File: /home/u545089396/domains/theadami.com/public_html/catalog/controller/journal3/product_extras.php Line: 73 Class: Opencart\System\Engine\Proxy Function: __call Backtrace: 5 File: /home/u545089396/domains/theadami.com/public_html/system/engine/loader.php Line: 112 Class: ControllerJournal3ProductExtras Function: index Backtrace: 6 File: /home/u545089396/domains/theadami.com/public_html/catalog/controller/journal3/startup.php Line: 196 Class: Opencart\System\Engine\Loader Function: controller Backtrace: 7 File: /home/u545089396/domains/theadami.com/public_html/system/engine/loader.php Line: 112 Class: ControllerJournal3Startup Function: index Backtrace: 8 File: /home/u545089396/domains/theadami.com/public_html/extension/journal_3/catalog/controller/journal_3/startup.php Line: 56 Class: Opencart\System\Engine\Loader Function: controller Backtrace: 9 File: /home/u545089396/domains/theadami.com/public_html/system/engine/loader.php Line: 112 Class: Opencart\Catalog\Controller\Extension\Journal3\Journal3\Startup Function: index Backtrace: 10 File: /home/u545089396/domains/theadami.com/public_html/catalog/controller/startup/startup.php Line: 22 Class: Opencart\System\Engine\Loader Function: controller Backtrace: 11 File: /home/u545089396/domains/theadami.com/public_html/system/engine/action.php Line: 96 Class: Opencart\Catalog\Controller\Startup\Startup Function: index Backtrace: 12 File: /home/u545089396/domains/theadami.com/public_html/system/framework.php Line: 208 Class: Opencart\System\Engine\Action Function: execute Backtrace: 13 File: /home/u545089396/domains/theadami.com/public_html/index.php Line: 20 Function: require_once