Support archive

Database error when non-superuser tries to look at Replace Log

Joe Beaver 28 Jul 2014 09:45 problem, complete

User group has "Can view replace log" ticked in Low Search control panel, but when I go to view it I get this DB error message:

A Database Error Occurred
Error Number: 1052

Column 'member_id' in where clause is ambiguous

SELECT 'exp_members'.'screen_name', 'exp_low_search_replace_log'.* FROM ('exp_low_search_replace_log') LEFT JOIN 'exp_members' ON 'exp_members'.'member_id' = 'exp_low_search_replace_log'.'member_id' WHERE 'site_id' = 1 AND 'member_id' = 59 ORDER BY 'replace_date' desc LIMIT 50

Filename: third_party/low_search/model.low_search.php

Line Number: 167

Also, on a slightly unrelated note - I cannot see the option to build the indexes when logged in as the same user - how do I show this?

Thanks!

EDIT: should probably note I'm using EE 2.7.3 with Low Search 3.1.5

Replies

1. Low 28 Jul 2014 09:56

   That'll be a bug. To fix, open up mcp.low_search.php and look up line 1933 (in v3.1.6), which reads:
   

   ee()->db->where('member_id', $member_id);

   ...and change that to:
   

   ee()->db->where('members.member_id', $member_id);
    

   That should solve it. Will add that fix to the next version.
   
   

2. Joe Beaver 28 Jul 2014 10:15

   Hi Low,
   
   thanks for that - all fixed and sorted now!