RE: Implement price range filter: DataImportHandler started. Not Initialized. No commands can be run

[Dyer, James]

No, you still have to fix problems with data-config.xml.  Just that prior to 
4.0-alpha if you started solr with a problem in the config, you had no way to 
fix it and refreshing without restarting solr (or at least doing a core 
reload).  With 4.0, you can fix your config file and just retry.

I think the problem might be the escaped quotes and amperstands.  Change it 
to...

<entity name="pricerange" query="With
Categorized as 
(Select 
 CASE When prijs &amp;amp;lt;= 1000 Then '&amp;lt;10' 
      When prijs &amp;amp;gt; 1000 and prijs &amp;amp;lt;= 2500 Then
'[10-25]' 
          When prijs &amp;amp;gt; 2500 and prijs &amp;amp;lt;= 5000 Then
'[25-50]' 
      Else '>50' 
 END as PriceCategory  From products) 
Select PriceCategory, Count(*) as Cnt From Categorized Group By 
PriceCategory "> 
</entity> James Dyer
Ingram Content Group
(615) 213-4311


-----Original Message-----
From: PeterKerk [mailto:vettepa...@hotmail.com] 
Sent: Thursday, February 14, 2013 10:01 AM
To: solr-user@lucene.apache.org
Subject: RE: Implement price range filter: DataImportHandler started. Not 
Initialized. No commands can be run

Ok, but I restarted solr several times and the issue still occurs. So my
guess is that the entity I added contains errors:

<entity name=&amp;quot;pricerange&amp;quot; query=&amp;quot;;With
Categorized as 
(Select 
 CASE When prijs &amp;amp;lt;= 1000 Then '&amp;lt;10' 
      When prijs &amp;amp;gt; 1000 and prijs &amp;amp;lt;= 2500 Then
'[10-25]' 
          When prijs &amp;amp;gt; 2500 and prijs &amp;amp;lt;= 5000 Then
'[25-50]' 
      Else '>50' 
 END as PriceCategory  From products) 
Select PriceCategory, Count(*) as Cnt From Categorized Group By 
PriceCategory "> 
                        </entity> 

Or are you saying that this code is correct and that the 4.0-Alpha release
will resolve my issue?

Thanks!



--
View this message in context: 
http://lucene.472066.n3.nabble.com/Implement-price-range-filter-DataImportHandler-started-Not-Initialized-No-commands-can-be-run-tp4040418p4040483.html
Sent from the Solr - User mailing list archive at Nabble.com.