solpath/fluxx_grant — Issue #1: No Sphinx indexes for LOIs
Author: mike-marcacci
Created: 2012-02-09 22:02:52+00:00
State: open

On a fresh install (repeated multiple times), pulling up the LOIS card breaks, returning:

````
ThinkingSphinx::SphinxError in LoisController#index
unknown local index 'loi_first_core' in search request
````

The logs show:

````
CACHE (0.0ms) SELECT `multi_element_groups`.`id` FROM `multi_element_groups` LIMIT 1
MultiElementGroup Load (0.2ms) SELECT `multi_element_groups`.* FROM `multi_element_groups` WHERE (`multi_element_groups`.`target_class_name` = 'RequestTransactionFundingSource')
Sphinx Query (1.9ms)
Sphinx Found 0 results
Sphinx Sphinx Daemon returned error: unknown local index 'loi_first_core' in search request
Completed in 2177ms

ThinkingSphinx::SphinxError (unknown local index 'loi_first_core' in search request):
````

I am able to create new LOIs as a prospective grantee, but the logs show:

````
CACHE (0.0ms) SELECT `multi_element_groups`.`id` FROM `multi_element_groups` LIMIT 1
MultiElementGroup Load (0.1ms) SELECT `multi_element_groups`.* FROM `multi_element_groups` WHERE (`multi_element_groups`.`target_class_name` = 'RequestTransactionFundingSource')
Sphinx Query (1.7ms)
Sphinx Found 0 results
Sphinx Sphinx Daemon returned error: unknown local index 'loi_first_core' in search request
Sphinx Query (1.3ms)
Sphinx Found 0 results
Sphinx Sphinx Daemon returned error: unknown local index 'loi_first_delta' in search request
SQL (17.6ms) COMMIT
SQL (0.4ms) SELECT COUNT(*) FROM `delayed_jobs` WHERE (`delayed_jobs`.`locked_at` IS NULL) AND (`delayed_jobs`.`handler` = '--- !ruby/object:ThinkingSphinx::Deltas::DeltaJob \nindexes: \n- loi_first_delta\n')
````