There has been a critical error processing your request

[streamce1]

Can anyone help with this. I just upgraded and everytime i go to look at order details I get this error

SQL Error: Unknown column 'ps.sort_order' in 'order clause'
Error No: 1054
SQL: SELECT ops.*, COALESCE(ps.quantity,'absent') as available_quantity FROM ab4a_order_product_stock_locations ops LEFT JOIN ab4a_product_stock_locations ps ON (ps.product_id = ops.product_id AND COALESCE(ps.product_option_value_id,0) = COALESCE(ops.product_option_value_id,0) AND ps.location_id = ops.location_id ) WHERE ops.order_product_id=263 ORDER BY ops.sort_order ASC, ps.sort_order ASC in /home/****/public_html/AbanteCart/core/database/amysqli.php on line 109

Thanks for any suggestions

[Basara]

Hello.
You have missing tables columns in your database

[streamce1]

Thanks for the reply!

would you know what is missing and in what table?

im by no means an expert at this, it just happened after the upgrade and finding it difficult to pinpoint what exactly it is that needs fixed.

thanks!