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