Guest Posted May 14, 2003 Posted May 14, 2003 I have poked and proded at my store and I think I am almost there except for the dreaded 1054 error. I have searched the boards and found some info on this, however, I have not come across anyone saying that the error is showing up for two different types of payments. I am able to get all the way to the CONFIRM or checkout_confirmation page but the minute I click "Confirm Order" I get the following errors: Check/Money Order 1054 - Unknown column 'customers_company' 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, orders_status, comments, currency, currency_value) values ('2', 'My Name, '', 'My Address', '', 'My City', 'Zip', '', 'United States', 'My Phone Number', '[email protected]', '2', 'Brandy Horkey', '', 'my address', '', 'my city', 'zip', '', 'United States', '2', 'Brandy Horkey', '', 'my address', '', 'my city', 'zip', '', 'United States', '2', 'Check/Money Order', '', '', '', '', now(), '1', '', 'USD', '1.00000000') [TEP STOP] PayPal IPN 1054 - Unknown column 'billing_name' in 'field list' insert into orders (customers_id, customers_name, 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_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, 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, orders_status, comments, currency, currency_value) values ('2', 'my name, 'my address', '', 'my city', 'zip', '', 'United States', 'my phone', '[email protected]', '2', 'my name', 'my address', '', 'my city', 'zip', '', 'United States', '2', 'my name', 'my address', '', 'my city', 'zip', '', 'United States', '2', 'PayPal IPN', '', '', '', '', now(), '99999', '', 'USD', '1.00000000') [TEP STOP] I have removed my personal information from the above but I see two things here. #1 the Unknown Column shown at the beginning of each of these errors and #2 the number listed on the last line just before USD...In checks/mo, it's 1, in IPN, it's 99999. When I installed IPN, I edited the existing 99999 references to 99990 and left them there. In my admin, this option exists. Order Status for COMPLETED Transactions 1 2 3 99990 If someone can help me out and tell me what I need to do to fix this, I would REALLY appreciate it! Please go easy on me with the explanations, MySQL is not one of my strong points and I have a bad feeling that this is where my problem is. Thanks Brandy
Recommended Posts
Archived
This topic is now archived and is closed to further replies.