Guest Posted August 10, 2008 Share Posted August 10, 2008 Hi All i am trying to install this and i have a error on the sql file Error SQL query: ALTER TABLE `orders` ADD `usps_track_num` VARCHAR( 40 ) AFTER `orders_date_finished` , ADD `ups_track_num 2` VARCHAR( 40 ) AFTER `usps_track_num` , ADD `fedex_track_num 2` VARCHAR( 40 ) AFTER `ups_track_num` , ADD `fedex_track_num 2` VARCHAR( 40 ) AFTER `fedex_track_num` , ADD `dhl_track_num 2` VARCHAR( 40 ) AFTER `fedex_freight_track_num` MySQL said: #1054 - Unknown column 'fedex_freight_track_num' in 'orders' as i dont now alot about mysql would i of you help me out here thanks Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted August 10, 2008 Share Posted August 10, 2008 You might want to remove an extra freight_ ADD `dhl_track_num 2` VARCHAR( 40 ) AFTER `fedex_freight_track_num` ADD `dhl_track_num 2` VARCHAR( 40 ) AFTER `fedex_track_num` But I would prefer to see the whole statement. Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
spooks Posted August 10, 2008 Share Posted August 10, 2008 Perhaps you ment: ALTER TABLE `orders` ADD `usps_track_num` VARCHAR( 40 ) AFTER `orders_date_finished` , ADD `ups_track_num 2` VARCHAR( 40 ) AFTER `usps_track_num` , ADD `fedex_track_num 2` VARCHAR( 40 ) AFTER `ups_track_num` , ADD `fedex_track_num 2` VARCHAR( 40 ) AFTER `fedex_track_num` , ADD `dhl_track_num 2` VARCHAR( 40 ) AFTER `fedex_track_num 2` Quote Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
satish Posted August 10, 2008 Share Posted August 10, 2008 fedex_freight_track_num add this field to the table. Satish Quote Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. 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.