mc-magento: Orders grid filter by increment ID is broken after upgrade to 1.1.11

Preconditions

  1. Magento 1.9.3.8
  2. Install this extension version 1.1.11

Steps to reproduce

  1. Go to Orders grid in admin panel
  2. Filter by increment ID

Expected result

  1. Orders filtered by increment ID

Actual result

  1. 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

About this issue

  • Original URL
  • State: closed
  • Created 6 years ago
  • Reactions: 2
  • Comments: 26 (17 by maintainers)

Commits related to this issue

Most upvoted comments

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?