Preconditions
- Magento 1.9.3.8
- Install this extension version 1.1.11
Steps to reproduce
- Go to Orders grid in admin panel
- Filter by increment ID
Expected result
- Orders filtered by increment ID
Actual result
- Magento report page. The corresponding
var/report file contains the following error:
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'increment_id' in where clause is ambiguous, query was: SELECT `main_table`.*, `oe`.`mailchimp_campaign_id`, `mc`.`mailchimp_synced_flag`, `mc`.`id` FROM `sales_flat_order_grid` AS `main_table`
LEFT JOIN `sales_flat_order` AS `oe` ON oe.entity_id=main_table.entity_id
LEFT JOIN `mailchimp_ecommerce_sync_data` AS `mc` ON mc.related_id=main_table.entity_id AND type = 'ORD' WHERE (`increment_id` LIKE '%1271%') GROUP BY `main_table`.`entity_id` ORDER BY created_at DESC LIMIT 20
I think everyone knows what @mmenozzi is hinting at … this extension is the defacto solution for Magento & Mailchimp and as Mailchimp calls it “a drop in ready solution” …
Major release alas you can create a release schedule
Minor and urgent fixes can be released in minor versions … (otherwise how can we call this stable if it breaks the backend?)
So are you going to leave the order grid bug in the last “stable” version until the end of April? Is it correct?