Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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
Comment #1
Pedro Gomide CreditAttribution: Pedro Gomide commentedThis is similar to http://drupal.org/node/885026
Comment #2
jhodgdonThis has already been reported:
EDIT (wrong issue link before)
#488166: Search relevance calculation fails if last_comment_timestamp is NULL