shanep Posted July 7, 2003 Share Posted July 7, 2003 Can anyone tell me where I can remove the 'customer_company' bit in the admin order file i think, so that i dont get an error 1054 - Unknown column 'customers_company' in 'field list' select 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, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '12' [TEP STOP] It is not in my database. is there a way around this please, i have orders, but cant veiw them.. any help would be great please Shane Link to comment Share on other sites More sharing options...
Guest Posted July 8, 2003 Share Posted July 8, 2003 Easiest way is to add that field to the database or check the query to see if you have a field you should not Link to comment Share on other sites More sharing options...
Guest Posted March 24, 2004 Share Posted March 24, 2004 I have no idea why, but out of the blue, I'm getting an error on catalog/admin/orders.php when I click on "edit": 1054 - Unknown column 'customers_company' in 'field list' select 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, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '37' [TEP STOP] I added the field "company_name" to the table, and then got a "1054 - Unknown column 'delivery_company' in 'field list'" I'd much rather find the misbehaving SQL sentance and not add a milliion unnecasery columns ot the DB! I have no idea what went wrong, or where the SQL sentance is. For referance, the latest change I made was installing the printable catalog V3.0, which added values to 'configuration_group' and to 'configuration'. I don't know if this could have afected anything else, but I have no idea what the problem is. Needless to say, this is URGENT! I have a live store, and can't process orders. I just hope this error doesn't show up anywhere customer-side! Link to comment Share on other sites More sharing options...
Guest Posted March 25, 2004 Share Posted March 25, 2004 Got it figured out. It was coused by diferences in the Db structure between osC2.2 and an older version, from which I had imported the database. Since 2.2 has features that were not available in the past, such as adding a billing address, or comments in the order_status_history table, the columns that were missing had to be added. all is well (for) now... 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.