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