Skip to content

Error turning on sorting by relevance #1255

Open
@neemiasjr

Description

@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

Metadata

Metadata

Assignees

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions