From 1132af15151713f52d8d1e320271185865a79633 Mon Sep 17 00:00:00 2001 From: multiple creatures Date: Sat, 16 Nov 2019 21:01:07 -0600 Subject: Moved to using a normalized text column for searches. Admins using an FTS-enabled version of Monsterfork will need to apply the migration from `dist/search.sql` then run `bundle exec rails monsterfork:index_statuses`. --- app/lib/bangtags.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'app/lib/bangtags.rb') diff --git a/app/lib/bangtags.rb b/app/lib/bangtags.rb index 60fb426b3..d708683cb 100644 --- a/app/lib/bangtags.rb +++ b/app/lib/bangtags.rb @@ -720,7 +720,7 @@ class Bangtags q = cmd[1..-1].join.strip next if q.blank? begin - data = @account.statuses.where('text ~* ?', expand_search_query(q)) + data = @account.statuses.where('normalized_text ~ ?', expand_search_query(q)) .reorder(:created_at) .pluck(:created_at) .map { |d| d.strftime('%Y-%m') } -- cgit