caspire Posted July 28, 2005 Share Posted July 28, 2005 Hi, I am installing Free shipping per product 1.1, link: http://www.oscommerce.com/community/contributions,2517 After I installed, when looking at the product info I get this error message: "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 ' p.products_free_shipping from products p, products_description select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_retail_price, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from, p.products_free_shipping from products p, products_description pd where p.products_status = '1' and p.products_id = '619' and pd.products_id = p.products_id and pd.language_id = '1' [TEP STOP]" I also have the contribution "EZier New Fields 5.0" which shows amount customer is saving "retail price: 89.99 our price: 45.00 you save: 44.99 or 50%" I am not sure if this contribution is messing with the Free shipping one or if I have made an error. Any suggestions? If I did make a mistake, what file is it likely to be in? Product_info.php? Thank you... Quote Link to comment Share on other sites More sharing options...
caspire Posted July 28, 2005 Author Share Posted July 28, 2005 I got it...thanks Quote Link to comment Share on other sites More sharing options...
newbie05 Posted March 21, 2008 Share Posted March 21, 2008 Help! I installed Free Shipping Per Product, and all seems fine until checkout! In my Admin section, I can select the free shipping drop down and enter 0 lbs for an item. In checkout though, it shows shipping for 3 lbs for this same item that should be free shipping. Even if I add multiple free shipping items in my shopping cart, it still shows the 3 lbs (and only 3 lbs...not 3 lbs. for each item). Any thoughts? Thanks so much! Quote Link to comment Share on other sites More sharing options...
Guest Posted March 22, 2008 Share Posted March 22, 2008 Where are the orginal files to upload? It talks about changing files in the later addition/fixes but the link for the orginal changes files is broken. Quote Link to comment Share on other sites More sharing options...
Guest Posted March 22, 2008 Share Posted March 22, 2008 (edited) I started to make the changes and they did not work without the original files so I upload old files from my computer. Now my shopping cart is missing the checkout and remove from cart buttons. I uploaded: Catalog/checkout_shipping.php Catalog/includes/classes/shopping_cart.php Catalog/includes/modules/shipping/item.php I need new files for them. Here the site: My store Edited April 26, 2008 by Jan Zonjee Quote Link to comment Share on other sites More sharing options...
Guest Posted March 22, 2008 Share Posted March 22, 2008 (edited) Catalog/checkout_shipping.php This files loads as a blank page Edited March 22, 2008 by Mad Duck Quote Link to comment Share on other sites More sharing options...
jgeoff Posted April 26, 2008 Share Posted April 26, 2008 Has anyone gotten this add-on working on the latest version of osC? :huh: Quote osC v2.2 RC2a w/ no special templates PHP Version 5.2.14 / MySQL 5.0.91-community Link to comment Share on other sites More sharing options...
jgeoff Posted April 28, 2008 Share Posted April 28, 2008 Okay, I pretty much got it to work -- BUT -- all this does is subtract the # of items before calculating per-item shipping. What I need is for it to subtract the free shipping product weights before I pass it along to the UPS module... :/ Quote osC v2.2 RC2a w/ no special templates PHP Version 5.2.14 / MySQL 5.0.91-community Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.