Re: Shipping Per Product BCSE Add-on SQL Errors
Quote:
Originally Posted by SBF
Anyone have this installed and working on 4.1.10? I've gone through the install twice and get these errors when trying to checkout or add items to my cart:
Code:
INVALID SQL: 1064 : 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 ') and code='' and active='Y' AND destination='L' AND weight_min<='3' AND (weig' at line 1
SQL QUERY FAILURE:SELECT count(xcart_shipping.shippingid) as total, xcart_shipping.*,productid FROM xcart_shipping left join product_shipping using (shippingid) WHERE ( ) and code='' and active='Y' AND destination='L' AND weight_min<='3' AND (weight_limit='0' OR weight_limit>='3') group BY shippingid having total= order by orderby
INVALID SQL: 1064 : 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 ') and subcode='52' AND active='Y' AND weight_min<='3' AND (weight_limit='0' OR ' at line 1
SQL QUERY FAILURE:SELECT count(xcart_shipping.shippingid) as total, xcart_shipping.*,productid, '5.80' AS rate, '' AS warning, shipping_time FROM xcart_shipping left join product_shipping using (shippingid) WHERE ( ) and subcode='52' AND active='Y' AND weight_min<='3' AND (weight_limit='0' OR weight_limit>='3') group BY shippingid having total= order by orderby
INVALID SQL: 1064 : 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 ') and code='' and active='Y' AND destination='L' AND weight_min<='3' AND (weig' at line 1
SQL QUERY FAILURE:SELECT count(xcart_shipping.shippingid) as total, xcart_shipping.*,productid FROM xcart_shipping left join product_shipping using (shippingid) WHERE ( ) and code='' and active='Y' AND destination='L' AND weight_min<='3' AND (weight_limit='0' OR weight_limit>='3') AND xcart_shipping.code='UPS' AND xcart_shipping.service_code!='' group BY shippingid having total= order by orderby
INVALID SQL: 1064 : 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 ') and subcode='1' AND active='Y' AND weight_min<='3' AND (weight_limit='0' OR w' at line 1
SQL QUERY FAILURE:SELECT count(xcart_shipping.shippingid) as total, xcart_shipping.*,productid, '6.85' AS rate, '' AS warning, shipping_time FROM xcart_shipping left join product_shipping using (shippingid) WHERE ( ) and subcode='1' AND active='Y' AND weight_min<='3' AND (weight_limit='0' OR weight_limit>='3') AND xcart_shipping.code='UPS' AND xcart_shipping.service_code!='' group BY shippingid having total= order by orderby
INVALID SQL: 1064 : 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 ') and subcode='23' AND active='Y' AND weight_min<='3' AND (weight_limit='0' OR ' at line 1
SQL QUERY FAILURE:SELECT count(xcart_shipping.shippingid) as total, xcart_shipping.*,productid, '11.06' AS rate, '' AS warning, '3 ~~~~|lbl_day_s| ||~~~~' AS shipping_time FROM xcart_shipping left join product_shipping using (shippingid) WHERE ( ) and subcode='23' AND active='Y' AND weight_min<='3' AND (weight_limit='0' OR weight_limit>='3') AND xcart_shipping.code='UPS' AND xcart_shipping.service_code!='' group BY shippingid having total= order by orderby
INVALID SQL: 1064 : 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 ') and subcode='2' AND active='Y' AND weight_min<='3' AND (weight_limit='0' OR w' at line 1
SQL QUERY FAILURE:SELECT count(xcart_shipping.shippingid) as total, xcart_shipping.*,productid, '15.44' AS rate, '' AS warning, '2 ~~~~|lbl_day_s| ||~~~~' AS shipping_time FROM xcart_shipping left join product_shipping using (shippingid) WHERE ( ) and subcode='2' AND active='Y' AND weight_min<='3' AND (weight_limit='0' OR weight_limit>='3') AND xcart_shipping.code='UPS' AND xcart_shipping.service_code!='' group BY shippingid having total= order by orderby
INVALID SQL: 1064 : 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 ') and subcode='20' AND active='Y' AND weight_min<='3' AND (weight_limit='0' OR ' at line 1
SQL QUERY FAILURE:SELECT count(xcart_shipping.shippingid) as total, xcart_shipping.*,productid, '28.89' AS rate, '' AS warning, '1 ~~~~|lbl_day_s| ||~~~~' AS shipping_time FROM xcart_shipping left join product_shipping using (shippingid) WHERE ( ) and subcode='20' AND active='Y' AND weight_min<='3' AND (weight_limit='0' OR weight_limit>='3') AND xcart_shipping.code='UPS' AND xcart_shipping.service_code!='' group BY shippingid having total= order by orderby
|
This is usually due to a common install mistake.
Contact us if you have this issue.
Thank you,
Carrie |
