Guest Posted January 7, 2008 Share Posted January 7, 2008 Hello everyone I constructed a site recently, when it was finished I incorporated a contribution that did not work. I removed it. I have received help from another support member, that was great. However, I only have the following error to repair and I get the site back to normal. When I click on the Customers>Orders>Edit, Invoice or packing slip I get the following error: 1054 - Unknown column 'shipdate' in 'field list' select customers_name, shipdate, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '10' [TEP STOP] Can anyone tell me how to get rid of the 'shipdate' in the 'field list'? Kind regards Brian Link to comment Share on other sites More sharing options...
Guest Posted January 7, 2008 Share Posted January 7, 2008 Were you installing a contribution that required you to run an sql file file and you did not do it? Link to comment Share on other sites More sharing options...
Guest Posted January 7, 2008 Share Posted January 7, 2008 Yes I did have to run an SQL File. It was the following: ALTER TABLE `orders` ADD `shipdate` VARCHAR( 10 ) NOT NULL I have since deleted the shipdate column from MYSQL. Brian Link to comment Share on other sites More sharing options...
Guest Posted January 7, 2008 Share Posted January 7, 2008 Yes I did have to run an SQL File. It was the following: ALTER TABLE `orders` ADD `shipdate` VARCHAR( 10 ) NOT NULL I have since deleted the shipdate column from MYSQL. Brian OK, you just need to undo that part of the addon that called for shipdate. Link to comment Share on other sites More sharing options...
Guest Posted January 7, 2008 Share Posted January 7, 2008 OK, you just need to undo that part of the addon that called for shipdate. Thanks for that, Can you tell me what to do please? Brian Link to comment Share on other sites More sharing options...
Guest Posted January 7, 2008 Share Posted January 7, 2008 Thanks for that, Can you tell me what to do please? Brian Hello Brian Please follow your install instructions undoing everything they asked you to do. Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 7, 2008 Share Posted January 7, 2008 Brian Thought you sorted this on the 30th. You need to look at the files that are in the contribution and undo each and every change you made to install it. Either use your backup copies of the files you made before changing them or if you havenot made and changes from the initial installation you could download a fresh copy and copy thse over. An open source program called winmerge can be used to compare 2 versions of the same file to highlight the differences. 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...
Guest Posted January 8, 2008 Share Posted January 8, 2008 Thank you very much to all who helped me get this back on track. I went through and reinstalled all the files and it worked. Again thanks very much. If there is anything I can do to help with anything, Just sing out. Kind regards Brian Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.