I have installed 6.19 on postgresql and activated the search module. I have made a very simple page and when i search for a word that is on the page i get the following error! :
warning: pg_query() [function.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 /home/sites/gmus/public_html/includes/database.pgsql.inc on line 139.
user warning: query: SELECT COUNT(*) FROM (SELECT i.type, i.sid, 5 * (7.46859455988 * SUM(i.score * t.count)) + 5 * POW(2, (GREATEST(MAX(n.created), MAX(n.changed), MAX(c.last_comment_timestamp) || 1) - 1281993312) * 6.43e-8) + 5 * (2.0 - 2.0 / (1.0 + MAX(c.comment_count) * 1)) 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 = 'vores') AND i.type = 'node' GROUP BY i.type, i.sid HAVING COUNT(*) >= 1) n1 in /home/sites/gmus/public_html/modules/search/search.module on line 958.
warning: pg_query() [function.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 /home/sites/gmus/public_html/includes/database.pgsql.inc on line 139.
user warning: query: SELECT i.type, i.sid, 5 * (7.46859455988 * SUM(i.score * t.count)) + 5 * POW(2, (GREATEST(MAX(n.created), MAX(n.changed), MAX(c.last_comment_timestamp) || 1) - 1281993312) * 6.43e-8) + 5 * (2.0 - 2.0 / (1.0 + MAX(c.comment_count) * 1)) 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 = 'vores') AND i.type = 'node' GROUP BY i.type, i.sid HAVING COUNT(*) >= 1 ORDER BY score DESC LIMIT 10 OFFSET 0 in /home/sites/gmus/public_html/modules/search/search.module on line 958.
postgresql version 8.3.11
apache 2.2.9
php 5.2.6
Is the postgresql support production ready???
Comments
same here
i see the same here, after updating from 6.17 to 6.19
pg 8.4.4_2
apache 2.2.16
php 5.3.3
freebsd 8.0
Same error
The same error is happening here also. When upgrading from 6.17 to 6.19 .
I have the same problem
I have the same problem http://drupal.org/node/888164
Fix available via patch
My understanding from the thread mentioned above (#888164):
It's reported...
See http://drupal.org/node/488166 for further discussion.
help
please i need your help , i have the same problem you describe , could you tell me where can i find this patch and how to configure it or do it , i am new using drupal, thanks