1054 - Unknown column 'customers_company' in 'field list'

[sonic_forever]

hello i need some help here..i ve some problem when i m going to check out from my shopping cart there are a msgs like these

 

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, currency, currency_value) values ('2', 'jimmy sofian', '', 'Jl Pancoran 6 no 12', '', 'jakarta', '11120', '', 'Indonesia', '6602111', '[email protected]', '1', 'jimmy sofian', '', 'Jl Pancoran 6 no 12', '', 'jakarta', '11120', '', 'Indonesia', '1', 'jimmy sofian', '', 'Jl Pancoran 6 no 12', '', 'jakarta', '11120', '', 'Indonesia', '1', 'Cash on Delivery', '', '', '', '', now(), '1', 'USD', '1.00000000')

 

[TEP STOP]

 

can u help me how to fix this things??

 

Thank you very much for your help

[Guest]

http://www.oscommerce.com/forums/viewtopic.php...y+field+list%2A

 

HTH

The_Bear

[sonic_forever]

thank you for your help

 

i already upgrade it

 

1054 - Unknown column 'orders_status_id' in 'field list'

 

insert into orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) values ('1', '1', now(), '1', '')

 

[TEP STOP]

 

can somebody help me pls.and thank u once again

[Guest]

I am having the same problem as the last problem mentioned.

 

1054 - Unknown column 'orders_status_id' in 'field list'

 

insert into orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) values ('1338', '', now(), '1', '')

 

[TEP STOP]

 

I just installed the contribution (Credit Class and Gift Vouchers), I get the error after clicking on the finish button after checking out through 2CheckOut. Seems... to me "and I really don't know cause I am VERY new to all of this" that the problem happens when data is being passed back to oscommerce from 2checkout. The file this is erroring on is "checkout_process.php"

 

Any ideas! I am SOOOOOOO close to being done with everything! Whoo hoooo

[Guest]

Me too - Any Ideas

[EmpressChang]

I am having similar difficulties after adding the PayPal IPN mod. This is the first mod I ever put in, so I sure the error is all on my end; however, I was very careful when adding this mod.

 

Here is the error I receive:

 

1054 - Unknown column 'orders_status_id' in 'field list'

 

insert into orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) values ('1', '99999', now(), '1', '')

 

[TEP STOP]

 

 

Thanks for your time & consideration!

[Guest]

I was getting a similar error when i went to checkout confirmation using the GV contribution, i then added the missing lines onto the database (using phpmyadmin) and it then gave me a 404 error. If i dont order a gift voucher, the system works fine so ive done away with the gift voucher, too much hassle.

 

Im not sure if i can be of any help to your problem but it could be one little thing that triggers off this error.

 

PR