rhytha Posted July 12, 2003 Share Posted July 12, 2003 i had upgraded from dec snapshot to ms1. all things seems ok(though i have a probelm with chekout confirmation using sutorize.net, but that's another story :? ). but when i choose cash on delivery and click confimation iam getting this error. :( thanx in advance for any help :P 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 ('64', 'Muthukumar prakasham', '', '11/529', 'Mugappair East', 'Chennai', '600050', 'TN', 'India', '6561032', '[email protected]', '1', 'Muthukumar prakasham', '', '11/529', 'Mugappair East', 'Chennai', '600050', 'TN', 'India', '1', 'Muthukumar prakasham', '', '11/529', 'Mugappair East', 'Chennai', '600050', 'TN', 'India', '1', 'Cash on Delivery', '', '', '', '', now(), '1', 'USD', '1.00000000') [TEP STOP] Link to comment Share on other sites More sharing options...
Guest Posted July 12, 2003 Share Posted July 12, 2003 I never filled one of these out , but I can see you have no value in the ,'', which is the error it calls, also there are 2 more like it, and an address of 11/529 I don't understand , may be another problem Link to comment Share on other sites More sharing options...
rhytha Posted July 12, 2003 Author Share Posted July 12, 2003 hi horseonetwo, if i add a field ''customers_company' will it ok, i mean it won;t afftect the other settings or won't harm the databse un anyway will it?? Link to comment Share on other sites More sharing options...
Guest Posted July 12, 2003 Share Posted July 12, 2003 No, you can safely add columns to the database. I wouldn't do so indiscriminately, but this column should be there now. Good luck, Matt Link to comment Share on other sites More sharing options...
rhytha Posted July 13, 2003 Author Share Posted July 13, 2003 h guys thanx for the help i had used beyondcompare to find the diff between my existing database and ms1. then using phpmyadmin i had updated the missing columns. :lol: thanx for you help 8) Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.