Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'posts_ft.most_relevant_post_id' in 'field list' (SQL: select discussions.*, posts_ft.most_relevant_post_id from discussions inner join (select posts.discussion_id, SUM(MATCH(posts.content) AGAINST (farewell)) as score, SUBSTRING_INDEX(GROUP_CONCAT(posts.id ORDER BY MATCH(posts.content) AGAINST (farewell) DESC, posts.number), ',', 1) as most_relevant_post_id from posts where exists (select 1 from discussions where discussions.id = posts.discussion_id and not exists (select 1 from discussion_tag where 0 = 1 and discussions.id = discussion_id) and (discussions.is_private = 0 or (discussions.is_approved = 0))) and (posts.is_private = 0 or (posts.is_approved = 0)) and posts.type = comment and MATCH(posts.content) AGAINST (farewell IN BOOLEAN MODE) and type in (comment, discussionRenamed, discussionLocked, discussionStickied, discussionTagged) group by posts.discussion_id) posts_ft on posts_ft.discussion_id = discussions.id where not exists (select 1 from discussion_tag where 0 = 1 and discussions.id = discussion_id) and (discussions.is_private = 0 or (discussions.is_approved = 0)) and (MATCH(discussions.title) AGAINST (farewell IN BOOLEAN MODE) or posts_ft.score is not null) and not exists (select 1 from discussion_tag where 0 = 1 and discussions.id = discussion_id) order by MATCH(discussions.title) AGAINST (farewell) desc, posts_ft.score desc limit 4) in /vendor/illuminate/database/Connection.php:664
