The above mentioned revision in Drupal 6.19 fails under PostgreSQL 8.3 as 'MAX(c.last_comment_timestamp) || 1)' is invalid.

Changing it to 'MAX(c.last_comment_timestamp), 1)' resolves the problem.

CommentFileSizeAuthor
node.module.patch807 bytesdeece

Comments

deece’s picture

deece commented
Status: Needs work » Needs review
damien tournoud’s picture

damien tournoud commented
Status: Needs review » Closed (duplicate)

This is a duplicate of #488166: Search relevance calculation fails if last_comment_timestamp is NULL.