cancel
Showing results for 
Search instead for 
Did you mean: 

Error in Orders search after updating to 1.9.3.3

Error in Orders search after updating to 1.9.3.3

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.