cdi-buy.com Posted April 26, 2004 Posted April 26, 2004 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).
Guest Posted April 26, 2004 Posted April 26, 2004 You are missing the column 'payment_info' in your orders table - this is part of something you have added. Matti
cdi-buy.com Posted April 26, 2004 Author Posted April 26, 2004 cool thanks..I was able to add that table and it took care of it.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.