AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: Ollie on May 08, 2017, 11:57:40 AM

Title: Critical error when trying to edit an order
Post by: Ollie on May 08, 2017, 11:57:40 AM
I upgraded to v 1.2.10 and I'm getting this critical error when trying to edit an order in the store admin.

Error Log:

2017-05-09 0:59:50 - database error: AbanteCart core v.1.2.10 SQL Error: Column 'sku' in field list is ambiguous
Error No: 1052
SQL: SELECT sku FROM `ac_product_option_values` pov LEFT JOIN `ac_order_options` oo ON pov.product_option_value_id = oo.product_option_value_id WHERE oo.order_id = 255809 in <b>/home/xxx/public_html/store/core/database/amysqli.php</b> on line <b>109</b>

2017-05-09 0:59:50 - warning: AbanteCart core v.1.2.10 Invalid argument supplied for foreach() in <b>/home/xxx/public_html/store/extensions/sales_plus/admin/view/default/template/pages/sale/order_details.tpl</b> on line <b>15</b>

Any insights on how to fix this problem will be greatly appreciated.   
Title: Re: Critical error when trying to edit an order
Post by: Basara on May 09, 2017, 01:21:07 AM
Hi.

Try this solution http://forum.abantecart.com/index.php/topic,5587.msg24045.html#msg24045