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

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.