Fatal error: 'Error: Table 'opencart_db_dev_staging.oc_add_on_deal_main_product' doesn't exist
Error No: 1146
SELECT add_on_product_id, add_on_price, aod.id as add_on_deal_id FROM `oc_add_on_deal_main_product` mp LEFT JOIN `oc_add_on_deal` aod ON aod.id = mp.add_on_deal_id LEFT JOIN `oc_add_on_deal_add_on_product` ap ON ap.add_on_deal_id = mp.add_on_deal_id WHERE mp.main_product_id = '18' AND '2024-11-01 11:43' BETWEEN add_on_start_date AND add_on_end_date;'
in /var/www/html/partner-dev/system/library/db/mysqli.php:40
Stack trace:
#0 system/library/db.php(16): DB\MySQLi->query('SELECT add_on_p...', Array)
#1 catalog/model/marketing/add_on_deal.php(9): DB->query('SELECT add_on_p...')
#2 [internal function]: ModelMarketingAddOnDeal->getProductAddOnProducts(18)
#3 vqmod/vqcache/vq2-system_storage_modification_system_engine_loader.php(178): call_user_func_array(Array, Array)
#4 [internal function]: Loader->{closure}(Array, Array)
#5 system/engine/proxy.php(25): call_user_func_array(Object(Closure), Array)
#6 system/storage/modification/catalog/controller/product/product.php(412): Proxy->__call('getProductAddOn...', Array)
#7 system/storage/modification/catalog/controller/product/product.php(412): Proxy->getProductAddOnProducts(18)
#8 [internal function]: ControllerProductProduct->index()
#9 vqmod/vqcache/vq2-system_storage_modification_system_engine_action.php(51): call_user_func_array(Array, Array)
#10 catalog/controller/startup/router.php(25): Action->execute(Object(Registry))
#11 [internal function]: ControllerStartupRouter->index()
#12 vqmod/vqcache/vq2-system_storage_modification_system_engine_action.php(51): call_user_func_array(Array, Array)
#13 system/storage/modification/system/engine/front.php(37): Action->execute(Object(Registry))
#14 system/storage/modification/system/engine/front.php(32): Front->execute(Object(Action))
#15 system/framework.php(103): Front->dispatch(Object(Action), Object(Action))
#16 vqmod/vqcache/vq2-system_startup.php(124): require_once('/var/www/html/p...')
#17 index.php(23): start('catalog')
#18 {main}