Closed (fixed)
Project:
Apache Solr Search
Version:
6.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
29 Dec 2009 at 16:26 UTC
Updated:
12 May 2010 at 21:10 UTC
In order to be able to use the Apache Solr module with Postgres, please change in apachesolr_search.module on line 274:
From:
AND (r.rid IN (". db_placeholders($rids) .") OR r.rid IS NULL) LIMIT 0,1", 'b', 'bid'), array_merge(array($module, $delta, $theme_key), $rids));
To:
AND (r.rid IN (". db_placeholders($rids) .") OR r.rid IS NULL) LIMIT 0 OFFSET 1", 'b', 'bid'), array_merge(array($module, $delta, $theme_key), $rids));
Comments
Comment #1
damien tournoud commentedI guess you mean
LIMIT 1 OFFSET 0. That said, I don't know what prevent this query from using a properdb_query_range().Comment #2
jpmckinney commentedFixed. http://drupal.org/cvs?commit=359092
Comment #3
jpmckinney commentedComment #4
jpmckinney commentedOh, sweet, only applies to 6-2, as only 6-2 has apachesolr_search_browse.