Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Errors at Checkout Confirmation


cdi-buy.com

Recommended Posts

Posted

I get this error when a customer tries to confirm an order, instead of them being directed back to the Success page:

1054 - Unknown column 'payment_info' 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, payment_info, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value, paypal_ipn_id) values, 'Check/Money Order', 'Make Payable To: CDI Buy!

 

Send To:

CDI Buy!?

1029 Mainsville Rd.

Shippensburg, PA 17257

 

Your order will not ship until we receive payment.', '', '', '', '', now(), '1', 'USD', '1.00000000', '')

 

[TEP STOP]

 

I've taken out customer specific information from this quote for their own security (hopefully). Any help would be appreciated greatly. It looks as though I'm missing database tables but I'm not sure and I don't know which one(s).

Posted

You are missing the column 'payment_info' in your orders table - this is part of something you have added.

 

Matti

Archived

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

×
×
  • Create New...