Searching members by email fails

[Alex Duffy]

Hi

I'm getting this error when I try to search members by their email addresses.

This is a facility I use a lot.

Any help is appreciated.

Best wishes Alex

 

 

Quote

SELECT count(*) FROM `core_members`  LEFT JOIN `core_pfields_content` AS `p` ON p.member_id=core_members.member_id  LEFT JOIN `cloud_blocked_email_log` ON core_members.email=cloud_blocked_email_log.email WHERE core_members.email<>'' AND email LIKE '%emmacoo@hotmail.com%' AND 1=1
IPS\Db\Exception: Column 'email' in where clause is ambiguous (1052)
#0 /var/www/html/107682/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*b322245::b322...', Array, true)
#1 /var/www/html/107682/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#2 /var/www/html/107682/system/Db/Select.php(370): IPS\Db\_Select->rewind()
#3 /var/www/html/107682/system/Helpers/Table/Db.php(328): IPS\Db\_Select->first()
#4 /var/www/html/107682/system/Helpers/Table/Table.php(504): IPS\Helpers\Table\_Db->getRows(Array)
#5 /var/www/html/107682/applications/core/modules/admin/members/members.php(623): IPS\Helpers\Table\_Table->__toString()
#6 /var/www/html/107682/system/Dispatcher/Controller.php(118): IPS\core\modules\admin\members\_members->manage()
#7 /var/www/html/107682/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#8 /var/www/html/107682/admin/index.php(13): IPS\_Dispatcher->run()
#9 {main}

 

 

 

 

[Jim M]

May want to disable any third party applications/plugins to test what is happening here. The 1=1 at the end of the query here sounds like something else is adding in this query or manipulating it.

[Nathan Explosion]

I just sparked up a trial and reproduced that issue immediately...

Edited May 19, 2023 by Nathan Explosion

[Ryan Ashbrook]

This is a known issue, and we have a fix coming for it.

[Alex Duffy]

Thank you, It's working now as it should!

Edited May 24, 2023 by Alex Duffy