Error turning on sorting by relevance

[neemiasjr]

Dear, to enable sorting by relevance in version 2.9.5, php server returns the error below:

phpMyFAQ warning [2]: pg_query (): Query failed: ERROR: column "relevance_thema" does not exist LINE 9: ORDER BY DESC relevance_thema, relevance ... ^ in / sites / base / homologation / inc / PMF / DB / Pgsql. php on line 112
Fatal error: Uncaught exception 'Exception' with message 'Error while fetching result: ERROR: column "relevance_thema" does not exist LINE 9: ORDER BY DESC relevance_thema, relevance ... ^' in / sites / base / homologation / inc / PMF / DB / Pgsql.php: 170 Stack trace: # 0 /sites/base/homologacao/inc/PMF/Relation.php(106): PMF_DB_Pgsql-> fetchAll (false) # 1 /sites/base/homologacao/artikel.php ( 175): PMF_Relation-> getAllRelatedById ('10' '(1004) Pineapple', 'Guava') # 2 /sites/base/homologacao/index.php(767): require ( '/ sites / base / hom .. . ') # 3 {main} thrown in /sites/base/homologacao/inc/PMF/DB/Pgsql.php on line 170

After checking the query in postgres server, I captured the following query in the database:

SELECT
fd.id AS id, fd.lang AS lang, fcr.category_id AS category_id, fd.thema AS question, fd.content AS answer, TS_RANK_CD(SETWEIGHT(TO_TSVECTOR(COALESCE(fd.keywords, '')), 'C'), query) AS relevance_keywords
FROM
phpmyfaq_crel_faqdata AS fd LEFT JOIN phpmyfaq_crel_faqcategoryrelations AS fcr ON fd.id = fcr.record_id AND fd.lang = fcr.record_lang , plainto_tsquery('Check list diário da SSCO

checklist, check list, check-list, SSCO') query
WHERE
((to_tsvector(coalesce(fd.keywords,''))) @@ query) OR (fd.keywords) ILIKE ('%Check list diário da SSCO

checklist, check list, check-list, SSCO%')
AND fd.active = 'yes' AND fd.lang = 'pt-br'
ORDER BY relevance_thema DESC, relevance_content DESC, relevance_keywords DESC

[neemiasjr]

I did a clean install of 2.9.5 version and the same error occurs when you enable sorting by relevance. I upgraded version .2.8.12 -> 2.9.0 -> 2.9.5 and error also occurs.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.