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

[gaspower]

Hello,

I am adding a bin field to my OSC and all works fine until view orders. I was using an older version of OSC and updating to the new RC1 version. In admin/includes/classes/order.php, I went from,

 

$index = 0;

$orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'");

while ($orders_products = tep_db_fetch_array($orders_products_query)) {

$this->products[$index] = array('qty' => $orders_products['products_quantity'],

'name' => $orders_products['products_name'],

'model' => $orders_products['products_model'],

'tax' => $orders_products['products_tax'],

'price' => $orders_products['products_price'],

'final_price' => $orders_products['final_price']);

 

 

To:

 

$index = 0;

$orders_products_query = tep_db_query("select orders_products_id, products_name, products_bin, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'");

while ($orders_products = tep_db_fetch_array($orders_products_query)) {

$this->products[$index] = array('qty' => $orders_products['products_quantity'],

'bin' => $orders_products['products_bin'],

'name' => $orders_products['products_name'],

'model' => $orders_products['products_model'],

'tax' => $orders_products['products_tax'],

'price' => $orders_products['products_price'],

'final_price' => $orders_products['final_price']);

 

and I get the following error,

 

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

 

select orders_products_id, products_name, products_bin, products_model, products_price, products_tax, products_quantity, final_price from orders_products where orders_id = '23'

 

Thanks JR