AbanteCart Community

Shopping Cart Operations => Support => Topic started by: streamce1 on November 13, 2019, 07:29:44 PM

Title: There has been a critical error processing your request
Post by: streamce1 on November 13, 2019, 07:29:44 PM

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

Title: Re: There has been a critical error processing your request
Post by: Basara on November 14, 2019, 02:40:53 AM

Hello.
You have missing tables columns in your database

Title: Re: There has been a critical error processing your request
Post by: streamce1 on November 14, 2019, 06:36:38 AM

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!