I recently reinstalled tt-rss from an old slower raspberry pi to a faster similar version. While doing so I’ve run into a problem with the “af_psql_trgm” plugin. I have two feeds that sometimes turn up with quite similar titles (and content) so this plugin helped me a lot in the past but whenever I turn it on now, I only get error messages in the logs and the feeds stop updating.
This is what the error messages states:
SQLSTATE: Undefined function: 7 ERROR: function “similarity” does not exist LINE 1: select ‘similarity’::regproc ^#0 /var/www/html/tt-rss/plugins/af_psql_trgm/init.php(256): PDO->query('select ‘similar…’)
#1 /var/www/html/tt-rss/classes/rssutils.php(752): Af_Psql_Trgm->hook_article_filter(Array)
#2 /var/www/html/tt-rss/classes/rssutils.php(192): RSSUtils::update_rss_feed(13, true, false)
#3 /var/www/html/tt-rss/update.php(166): RSSUtils::update_daemon_common()
I have installed the postgresql extension via
CREATE EXTENSION pg_trgm;
I’m running version v18.8 (643d191) directly from git, with nginx, php7.2 and postgresql 10
Does anyone know which step I forgot to take or how I can resolve this?