Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted May 19, 20231 yr 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}
May 19, 20231 yr 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.
May 19, 20231 yr I just sparked up a trial and reproduced that issue immediately... Edited May 19, 20231 yr by Nathan Explosion
May 24, 20231 yr Author Thank you, It's working now as it should! Edited May 24, 20231 yr by Alex Duffy