Low Search: Error When Rebuilding Specific Index
Whenever Low Search attempts to index our Projects collection, we get the following error:
--
Error Number: 1054
Unknown column 'd.field_id_12' in 'field list'
SELECT 't'.'entry_id', 't'.'channel_id', 't'.'title' AS field_id_0, 'd'.'field_id_7', 'd'.'field_id_8', 'd'.'field_id_9', 'd'.'field_id_10', 'd'.'field_id_12', 'd'.'field_id_49' FROM ('exp_channel_titles' t) INNER JOIN 'exp_channel_data' d ON 't'.'entry_id' = 'd'.'entry_id' WHERE 't'.'channel_id' IN ('2') ORDER BY 'entry_id' asc LIMIT 100
Filename: third_party/low_search/libraries/Low_search_index.php
Line Number: 187
--
I can confirm there is no field in the system with an ID of 12. Why is Low looking for this field ID? All of our other indexes work fine. It's hard to say when this stopped working properly. We were using EE 2.5.5 and Low Search 2.2.0. I've now upgraded our site to EE 2.9.2 and Low Search 3.5.1 but the same error persists. Clearly somewhere along the line Low Search didn't get notified that field ID 12 was deleted. Can anyone recommend a fix??
Replies
Low 3 Feb 2015 07:39
Yeah, that behaviour was fixed in la ater version, but cannot be fixed by only upgrading. Try re-saving the collection that's causing the issue.
Dustin Hansen 3 Feb 2015 23:39
Thanks. That did the trick.