Warning: Undefined array key "file" in /var/www/new.mxguards.com/public_html/system/framework.php on line 87Warning: Undefined array key "line" in /var/www/new.mxguards.com/public_html/system/framework.php on line 88Warning: Undefined array key "file" in /var/www/new.mxguards.com/public_html/system/framework.php on line 87Warning: Undefined array key "line" in /var/www/new.mxguards.com/public_html/system/framework.php on line 88Error: Error: 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 'JOIN oc_product p ON p.product_id = pbc.product_id and p.status != 0 ' at line 8
Error No: 1064
SELECT DISTINCT pbc.make FROM microst0_szuro.product_bike_compatibility_test pbc JOIN oc_product_to_store pts ON pts.product_id = pbc.product_id AND pts.store_id = JOIN oc_product p ON p.product_id = pbc.product_id and p.status != 0 WHERE pbc.make != '9999' ORDER BY pbc.make ASC File: /var/www/new.mxguards.com/public_html/system/library/db/mysqli.php Line: 109 Backtrace: 0 File: /var/www/new.mxguards.com/public_html/system/library/db.php Line: 48 Class: Opencart\System\Library\DB\MySQLi Function: query Backtrace: 1 File: /var/www/new.mxguards.com/public_html/catalog/model/module/bike_compatibility.php Line: 17 Class: Opencart\System\Library\DB Function: query Backtrace: 2 File: /var/www/new.mxguards.com/public_html/catalog/controller/bike_fitment/index.php Line: 446 Class: ModelModuleBikeCompatibility Function: getAllMakes Backtrace: 3 File: /var/www/new.mxguards.com/public_html/catalog/controller/bike_fitment/index.php Line: 56 Class: ControllerBikeFitmentIndex Function: _getBikeSelectData Backtrace: 4 File: Line: Class: ControllerBikeFitmentIndex Function: getBikeSelect Backtrace: 5 File: /var/www/new.mxguards.com/public_html/system/engine/action.php Line: 121 Function: call_user_func Backtrace: 6 File: /var/www/new.mxguards.com/public_html/system/engine/loader.php Line: 37 Class: Opencart\System\Engine\Action Function: execute Backtrace: 7 File: /var/www/new.mxguards.com/public_html/catalog/controller/common/home.php Line: 16 Class: Opencart\System\Engine\Loader Function: controller Backtrace: 8 File: Line: Class: ControllerCommonHome Function: index Backtrace: 9 File: /var/www/new.mxguards.com/public_html/system/engine/action.php Line: 121 Function: call_user_func Backtrace: 10 File: /var/www/new.mxguards.com/public_html/system/framework.php Line: 240 Class: Opencart\System\Engine\Action Function: execute Backtrace: 11 File: /var/www/new.mxguards.com/public_html/index.php Line: 15 Function: require_once