After update from 6.17 to 6.19 search has ceased to work. At attempt that or to find, there is an error.

warning: pg_query(): Query failed: ERROR: operator does not exist: integer || integer LINE 1: ...d), MAX(n.changed), MAX(c.last_comment_timestamp) || 1) - 12... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in /var/www/tushna-hram.ru/public_html/includes/database.pgsql.inc on line 139.
user warning: query: SELECT COUNT(*) FROM (SELECT i.type, i.sid, 5 * (7.7158707745963 * SUM(i.score * t.count)) + 5 * POW(2, (GREATEST(MAX(n.created), MAX(n.changed), MAX(c.last_comment_timestamp) || 1) - 1281891201) * 6.43e-8) AS score FROM search_index i INNER JOIN search_total t ON i.word = t.word INNER JOIN node n ON n.nid = i.sid LEFT JOIN node_comment_statistics c ON c.nid = i.sid WHERE n.status = 1 AND (i.word = 'тушна') AND i.type = 'node' GROUP BY i.type, i.sid HAVING COUNT(*) >= 1) n1 in /var/www/example.com/public_html/modules/search/search.module on line 958.
warning: pg_query(): Query failed: ERROR: operator does not exist: integer || integer LINE 1: ...d), MAX(n.changed), MAX(c.last_comment_timestamp) || 1) - 12... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in /var/www/example.com/public_html/includes/database.pgsql.inc on line 139.
user warning: query: SELECT i.type, i.sid, 5 * (7.7158707745963 * SUM(i.score * t.count)) + 5 * POW(2, (GREATEST(MAX(n.created), MAX(n.changed), MAX(c.last_comment_timestamp) || 1) - 1281891201) * 6.43e-8) AS score FROM search_index i INNER JOIN search_total t ON i.word = t.word INNER JOIN node n ON n.nid = i.sid LEFT JOIN node_comment_statistics c ON c.nid = i.sid WHERE n.status = 1 AND (i.word = 'тушна') AND i.type = 'node' GROUP BY i.type, i.sid HAVING COUNT(*) >= 1 ORDER BY score DESC LIMIT 10 OFFSET 0 in /var/www/example.com/public_html/modules/search/search.module on line 958.

OS: Debian GNU/Linux squeeze
PHP 5.3.2-2
Postgresql 8.4.4-2
Apache 2.2.16-1

Comments

Pedro Gomide’s picture

jhodgdon’s picture

Status: Active » Closed (duplicate)

This has already been reported:
EDIT (wrong issue link before)
#488166: Search relevance calculation fails if last_comment_timestamp is NULL