mossman Posted May 10, 2011 Share Posted May 10, 2011 Hello everyone! I just installed the add-on : http://addons.oscommerce.com/info/1462 "Fedex Real Time Quotes" I have update all the required information in the module. I'm getting a SQL error: 1054 - Unknown column 'products_ship_sep' in 'where clause' select products_id, products_price, products_tax_class_id, products_weight from products where products_id = '49' and products_ship_sep = '0' [TEP STOP] It can't find a column in the database. The install i downloaded didn't come with a .sql file for updating the database. Any help is greatly appreciated! Aaron Quote Link to comment Share on other sites More sharing options...
KDM Posted May 11, 2011 Share Posted May 11, 2011 Hello everyone! I just installed the add-on : http://addons.oscommerce.com/info/1462 "Fedex Real Time Quotes" I have update all the required information in the module. I'm getting a SQL error: 1054 - Unknown column 'products_ship_sep' in 'where clause' select products_id, products_price, products_tax_class_id, products_weight from products where products_id = '49' and products_ship_sep = '0' [TEP STOP] It can't find a column in the database. The install i downloaded didn't come with a .sql file for updating the database. Any help is greatly appreciated! Aaron I don't use the contribution but looking at the download that I see a file "fedex1.sql.php" sitting right outside of the catalog. Without reading the installation instruction myself I would bet that you need to run that program and it will update your data with the necessary field(s) needed. Read the instructions again and if that program is not there perhaps you need to download another version of the contribution to obtain that program. Quote Link to comment Share on other sites More sharing options...
mossman Posted May 11, 2011 Author Share Posted May 11, 2011 Thank you, i did find the proper download w/ the SQL. Unfortunetly i can get anything but the free shipping to display on my checkout. I have posted a topic here:http://www.oscommerce.com/forums/topic/375094-shipping-only-shows-free-shipping/ Thanks for responding to me! Aaron Quote 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.