Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1054 - Unknown column orders_status_id in field li


Guest

Recommended Posts

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

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

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.

 

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

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

Archived

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

×
×
  • Create New...