Jump to content

Searching members by email fails

Go to solution Solved by Ryan Ashbrook,

Recommended Posts


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


Could contain: Page, Text



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}



Could contain: File, Webpage, Page, Text



Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...