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.