You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
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.
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
The text was updated successfully, but these errors were encountered: