Guest Posted January 6, 2005 Share Posted January 6, 2005 Hello, When trying to place an order or view order status in admin area of MS2 i get the following error: 1054 - Unknown column 'orders_status_id' in 'field list' select orders_status_id, date_added, customer_notified, comments from orders_status_history where orders_id = '7207' order by date_added [TEP STOP] I am in the process of upgrading a 2.1 release to ms2. Any help? Jeremy Link to comment Share on other sites More sharing options...
onnig Posted January 6, 2005 Share Posted January 6, 2005 There is a table called 'field list' in your mysql database which is missing a column labeled 'orders_status_id'. Just go into the database and add that column. Sounds like there was some kind of mod on your install. Onnig Link to comment Share on other sites More sharing options...
Guest Posted January 6, 2005 Share Posted January 6, 2005 There is a table called 'field list' in your mysql database which is missing a column labeled 'orders_status_id'. Just go into the database and add that column. Sounds like there was some kind of mod on your install. <{POST_SNAPBACK}> I cannot find the table called 'field list'? Any idea where to look? I have the following tables: Table Action Records Type Size address_book 4,689 MyISAM 488.7 KB address_format 5 MyISAM 2.5 KB banners 12 MyISAM 6.3 KB banners_history 1,213 MyISAM 41.6 KB categories 5 MyISAM 3.2 KB categories_description 5 MyISAM 3.1 KB configuration 160 MyISAM 32.3 KB configuration_group 15 MyISAM 2.9 KB counter 1 MyISAM 1.0 KB counter_history 0 MyISAM 1.0 KB countries 239 MyISAM 16.1 KB currencies 4 MyISAM 2.2 KB customers 4,282 MyISAM 478.6 KB customers_basket 1,547 MyISAM 77.3 KB customers_basket_attributes 712 MyISAM 29.6 KB customers_info 4,282 MyISAM 192.7 KB geo_zones 1 MyISAM 2.1 KB languages 1 MyISAM 3.0 KB manufacturers 1 MyISAM 3.0 KB manufacturers_info 1 MyISAM 2.1 KB master_password 1 MyISAM 2.1 KB newsletters 2 MyISAM 9.5 KB orders 4,962 MyISAM 1.5 MB orders_products 15,261 MyISAM 1.2 MB orders_products_attributes 6,001 MyISAM 281.1 KB orders_products_download 0 MyISAM 1.0 KB orders_status 5 MyISAM 3.1 KB orders_status_history 10,297 MyISAM 385.6 KB orders_total 19,845 MyISAM 1.4 MB products 150 MyISAM 17.5 KB products_attributes 112 MyISAM 5.8 KB products_attributes_download 1 MyISAM 2.0 KB products_description 150 MyISAM 83.3 KB products_discounts 353 MyISAM 16.3 KB products_notifications 1,121 MyISAM 36.6 KB products_options 3 MyISAM 2.1 KB products_options_values 40 MyISAM 2.9 KB products_options_values_to_products_options 39 MyISAM 2.5 KB products_to_categories 150 MyISAM 5.3 KB reviews 51 MyISAM 4.7 KB reviews_description 51 MyISAM 20.7 KB search_engines 1,084 MyISAM 95.3 KB search_words 6,279 MyISAM 449.1 KB sessions 2 MyISAM 5.9 KB specials 4 MyISAM 2.2 KB state_codes 63 MyISAM 2.4 KB tax_class 1 MyISAM 2.1 KB tax_rates 1 MyISAM 2.1 KB top_month 4 MyISAM 3.7 KB whos_online 1 MyISAM 5.6 KB zones 181 MyISAM 9.0 KB zones_to_geo_zones 1 MyISAM 2.1 KB Link to comment Share on other sites More sharing options...
etepalusip Posted January 6, 2005 Share Posted January 6, 2005 Check your orders_status_history table. There should be 6 fields: orders_status_history_id orders_id orders_status_id date_added customer_notified comments orders_status_id is of type int(5) Pete http://www.RouseArtCo.com Link to comment Share on other sites More sharing options...
onnig Posted January 6, 2005 Share Posted January 6, 2005 Hi Pete, Yeah, weird, I don't have it either, that's why I thought it's probably from a mod then again 'field list' is two words without the '_' to join them so it couldn't be a table. So it must be what you said, where 'field list' is actually pointing the the field list in the table order_status_history. Thanks again. Onnig Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.