cdi-buy.com Posted April 25, 2004 Posted April 25, 2004 Does anyone know what would cause this message to occur right after a UK customer would confirm an order? 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 ('65', 'Leonie Barnes', '', '90 Toxteth street', '', 'Openshaw', 'M11 1 EU', 'Manchester', 'United Kingdom', '01613709610', '[email protected]', '1', 'Leonie Barnes', '', '90 Toxteth street', '', 'Openshaw', 'M11 1 EU', 'Manchester', 'United Kingdom', '1', 'Leonie Barnes', '', '90 Toxteth street', '', 'Openshaw', 'M11 1 EU', 'Manchester', 'United Kingdom', '1', '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]
Guest Posted April 25, 2004 Posted April 25, 2004 sounds like you added a payment contribution, but did not run the sql statement to modify the database
cdi-buy.com Posted April 25, 2004 Author Posted April 25, 2004 I dont know...it works fine for USA purchases (store based in USA)
cdi-buy.com Posted April 26, 2004 Author Posted April 26, 2004 No one knows? I'd like to get this working for foreign orders if I can....I already have UK friends who are spreading the word.
cdi-buy.com Posted April 26, 2004 Author Posted April 26, 2004 Ok I was wrong. I get that error for all orders, US and foreign (no matter what mayment method is selected) - anyone know what's going on?? PayPal seems to work but I don't have a way to test through the whole way to make sure. Any help would greatly appreciated....
Recommended Posts
Archived
This topic is now archived and is closed to further replies.