Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Shipping Per Product BCSE Add-on SQL Errors
 
Reply
   X-Cart forums > X-Cart 4 > Third Party Add-Ons for X-Cart 4
 
Thread Tools
  #1  
Old 07-20-2008, 02:53 PM
 
SBF SBF is offline
 

Advanced Member
  
Join Date: Jul 2008
Posts: 33
 

Question Shipping Per Product BCSE Add-on SQL Errors

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
__________________
Version 4.1.10
Reply With Quote
  #2  
Old 07-21-2008, 11:37 AM
  Jon's Avatar 
Jon Jon is offline
 

X-Guru
  
Join Date: Oct 2002
Location: Vancouver, Canada
Posts: 4,174
 

Default Re: Shipping Per Product BCSE Add-on SQL Errors

You have an empty where clause in the query, you'll have to contact BCSE.
__________________
|
Our clients strive to be the best in their industry.
We position you for success with our strategically integrated approach to software, search engine optimization and social media.

E-COMMERCE FUTURE
https://www.stackdigital.com

LINKEDIN
https://www.linkedin.com/in/smackdigital
Reply With Quote
  #3  
Old 08-18-2008, 04:59 PM
  BCSE's Avatar 
BCSE BCSE is online now
 

X-Man
  
Join Date: Apr 2003
Location: Ohio - bcsengineering.com
Posts: 2,894
 

Default 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
__________________
Custom Development, Custom Coding and Pre-built modules for X-cart since 2002!

We support X-cart versions 3.x through 5.x!

Home of the famous Authorize.net DPM & CIM Modules, Reward Points Module, Point of Sale module, Speed Booster modules and more!


Over 200 X-cart Mods available & Thousands of Customizations Since 2002 - bcsengineering.com

Please E-Mail us for questions/support!
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Third Party Add-Ons for X-Cart 4


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 03:24 AM.

   

 
X-Cart forums © 2001-2018