Hi all,

Not work search after I updated drupal from 6-17 to 6-19.

I use PostgreSQL 8.4.4

I found error in syslog

ERROR:  operator does not exist: integer || integer

and postgresql.log

Aug 13 14:36:55 mysuperserver postgres[24797]: [2-3] STATEMENT:  SELECT COUNT(*) FROM (SELECT i.type, i.sid, 5 * (17.007091957346 * SUM(i.score * t.count)) + 5 * POW(2, (GREATEST(MAX(n.created), MAX(n.changed), MAX(c.last_comment_timestamp) || 1) - 1279444359) * 6.43e-8) + 5 * (2.0 - 2.0 / (1.0 + MAX(c.comment_count) * 1)) AS score FROM drupal_search_index i INNER JOIN drupal_search_total t ON i.word = t.word INNER JOIN drupal_node n ON n.nid = i.sid   LEFT JOIN drupal_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
Aug 13 14:36:55 mysuperserver postgres[24797]: [3-1] ERROR:  operator does not exist: integer || integer at character 155
Aug 13 14:36:55 mysuperserver postgres[24797]: [3-2] HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

Comments

jhodgdon’s picture

jhodgdon
she/her
Primary language English
CreditAttribution: jhodgdon commented

I have seen this error reported on another project. Apparently PostgreSQL does not accept "1" as a boolean value to do queries like "WHERE 1" or WHERE "1 OR another_condition". You have to do WHERE 1 = 1 to get this to work. Similarly WHERE 0 doesn't work, you have to do WHERE 1=0.

So this is probably a real issue in the search mdoule. We will need to do some revision of the search query to get this to work in PostgreSQL.

jhodgdon’s picture

jhodgdon
she/her
Primary language English
CreditAttribution: jhodgdon commented
Title: No search result » PostgreSQL query error when searching

updating title to be more descriptive

Damien Tournoud’s picture

Damien Tournoud CreditAttribution: Damien Tournoud commented
Status: Active » Closed (duplicate)

I reopened the issue that broke this: #488166: Search relevance calculation fails if last_comment_timestamp is NULL

PMunn’s picture

PMunn CreditAttribution: PMunn commented

Woo another PostgreSQL bug. Hi Damien, we last chatted on the thread ID getting too long bug, that nice one that's almost 4 years old! I'm seeing this too, all my searches fail to bring anything back.