Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

two different 1054 errors on IPN and Check/MO options


Guest

Recommended Posts

Posted

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

Archived

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

×
×
  • Create New...