I have updated our magento from 1.9.2.1 to 1.9.3.3 after trying to convince the owner for a while. Everything looks like working as they should, except the search in the orders page. When we try to search for any order we get the following error:
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'increment_id' in where clause is ambiguous, query was: SELECT `main_table`.*, `ordercomment_table`.`comment` AS `ordercomment`, `sales_flat_shipment`.`email_sent` FROM `sales_flat_order_grid` AS `main_table`
LEFT JOIN `sales_flat_order_status_history` AS `ordercomment_table` ON main_table.entity_id = ordercomment_table.parent_id AND ordercomment_table.comment IS NOT NULL
LEFT JOIN `sales_flat_shipment` ON main_table.entity_id = sales_flat_shipment.order_id WHERE (`increment_id` LIKE '%100008517%') GROUP BY `main_table`.`entity_id` ORDER BY main_table.created_at DESC LIMIT 20
I can't figure out what the problem is. Can you help me?
We run on magento 1.9.3.3 ce.
