Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1054 - Unknown column 'comments' in 'field list'


graphicore

Recommended Posts

I am having this error when checking out after trying again to install the version 5.0 of downloads_controller.

 

1054 - Unknown column 'comments' in 'field list'

 

insert into orders (customers_id, customers_name, 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, date_purchased, last_modified, orders_status, comments, currency, currency_value) values ('2', 'John Doe', '', '11 smith', '', 'Greendale', '07201', 'Wichita', 'Yugoslavia', '773-678-9809', '[email protected]', '1', 'John Doe', '', '11 smith', '', 'Greendale', '07201', 'Wichita', 'Yugoslavia', '1', 'John Doe', '', '11 smith', '', 'Greendale', '07201', 'Wichita', 'Yugoslavia', '1', 'Check/Money Order', '', '', '', '', now(), now(), '1', 'Oh please work', 'USD', '1.00000000')

 

Can someone let me know where to define the comments field????????

Link to comment
Share on other sites

Never Mind.... I figure it out. Thanks anyway for the pointer.

 

For those having the same type of issue just go to your site control panel under MySQL and look for admin via PHP... There you can see the fields that are used and just create one with the missing column name.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...