Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help with "Unknown column in Field List"


Guest

Recommended Posts

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

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

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

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

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

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...