bossballa Posted January 24, 2007 Share Posted January 24, 2007 I work for a company that processess about 20-30 orders daily that ships through UPS. We have the WorldShip software and it is very annoying to manually enter each one. anyway, i found a contribution that would help me out but i can't get it running: Contribuiton URL: http://www.oscommerce.com/community/contributions,2390 I installed it to a tee but i get this error everytime i press the export to UPS button on the order: ========================================== 1054 - Unknown column 'delivery_company' in 'field list' select delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_state, delivery_postcode, delivery_country, customers_email_address, customers_telephone, orders_status from orders where orders_id = '66' [TEP STOP] ========================================== I don't know MySQL, I think this means that I'm not using a database prefix, if so how/where do i add it and if not, what do i do? Quote Link to comment Share on other sites More sharing options...
bossballa Posted January 25, 2007 Author Share Posted January 25, 2007 sorry, the fill error statement is... 1054 - Unknown column 'delivery_company' in 'field list' select delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_state, delivery_postcode, delivery_country, customers_email_address, customers_telephone, orders_status from orders where orders_id = '66' [TEP STOP] 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.
Note: Your post will require moderator approval before it will be visible.