Database error 1054 occurs with Low Search
The problems happens after an entry is edited and submitted, this error message appears:
A Database Error Occurred
Error Number: 1054
Unknown column 'd.field_id_7' in 'field list'
SELECT 't'.'entry_id', 't'.'channel_id', 't'.'title' AS field_id_0, 'd'.'field_id_6', 'd'.'field_id_7', 'd'.'field_id_30', 'd'.'field_id_31' FROM ('exp_channel_titles' t) INNER JOIN 'exp_channel_data' d ON 't'.'entry_id' = 'd'.'entry_id' WHERE 't'.'channel_id' IN ('2') AND 't'.'entry_id' IN ('22') ORDER BY 'entry_id' asc
Filename: third_party/low_search/libraries/Low_search_index.php
Line Number: 187
It comes from Low Search or from an other module, plugin??
Thanks,
Stéphane
Replies
Stéphane Cabaret 3 Jan 2014 23:20
Low,
The problem was solved after a rebuild index of the collection. But the rebuild works only after i clicked in the collection label name and came back to the rebuild index page.
Now it's working fine!!
Stéphane
Low 4 Jan 2014 11:33
It probably needed a re-save of the collection settings after a custom field was deleted. Deleting a custom field that was part of a search collection could have that effect.
Glad it's solved now!
Stéphane Cabaret 4 Jan 2014 12:15
Thanks for your reply!