[v1.0.5] Fix the issue Integrity constraint violation: 1052 Column 'email' in where clause is ambiguous

Created by Rosa Truong, Modified on Fri, 14 Jan, 2022 at 11:21 AM by Rosa Truong

Issue:


We are getting the following error in the log file when we search any customer email from the Magento customer grid 


Integrity constraint violation: 1052 Column 'email' in where clause is ambiguous, query was: SELECT `main_table`.*, `customer_entity`.`mp_ace_blacklist`, `bss_companycredit_credit`.`available_credit`, `bss_companycredit_credit`.`allow_exceed`, `bss_companycredit_credit`.`currency_code` FROM `customer_grid_flat` AS `main_table`


We are using version 1.0.5 on Magento 2.4.0 CE.

Could you please check and solve it?


Solution:


The issue happens due to the module's bug.

To solve it, please overwrite this file app/code/Bss/CompanyCredit/Plugin/Customer/Grid/JoinCollection.php 

Please apply it on the site and flush the cache.


If you have any issues, please feel free to contact us.

We're always willing to support you.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article