You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by solrEvaluation <ge...@gmail.com> on 2011/01/24 23:07:29 UTC

Solr set up issues with Magento

Hello Team:


  I am in the process of setting up Solr 1.4 with Magento ENterprise Edition
1.9. 

When I try to index the products I get the following error message.

Jan 24, 2011 3:30:14 PM org.apache.solr.update.processor.LogUpdateProcessor
fini
sh
INFO: {} 0 0
Jan 24, 2011 3:30:14 PM org.apache.solr.common.SolrException log
SEVERE: org.apache.solr.common.SolrException: ERROR:unknown field 'in_stock'
        at
org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.jav
a:289)
        at
org.apache.solr.update.processor.RunUpdateProcessor.processAdd(RunUpd
ateProcessorFactory.java:60)
        at
org.apache.solr.handler.XMLLoader.processUpdate(XMLLoader.java:139)
        at org.apache.solr.handler.XMLLoader.load(XMLLoader.java:69)
        at
org.apache.solr.handler.ContentStreamHandlerBase.handleRequestBody(Co
ntentStreamHandlerBase.java:54)
        at
org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandl
erBase.java:131)
        at org.apache.solr.core.SolrCore.execute(SolrCore.java:1316)
        at
org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter
.java:338)
        at
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilte
r.java:241)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:244)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:210)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:240)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:161)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:164)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:100)
        at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
550)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:118)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:380)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:243)
        at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:188)
        at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:166)
        at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoin
t.java:288)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec
utor.java:886)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:908)
        at java.lang.Thread.run(Thread.java:662)

Jan 24, 2011 3:30:14 PM org.apache.solr.core.SolrCore execute
INFO: [] webapp=/solr path=/update params={wt=json} status=400 QTime=0
Jan 24, 2011 3:30:14 PM org.apache.solr.update.DirectUpdateHandler2 rollback
INFO: start rollback
Jan 24, 2011 3:30:14 PM org.apache.solr.update.DirectUpdateHandler2 rollback
INFO: end_rollback
Jan 24, 2011 3:30:14 PM org.apache.solr.update.processor.LogUpdateProcessor
fini
sh
INFO: {rollback=} 0 16
Jan 24, 2011 3:30:14 PM org.apache.solr.core.SolrCore execute

I am a new to both Magento and SOlr. I could have done some thing stupid
during installation. I really look forward for your help.

Thank you,
Sandhya
-- 
View this message in context: http://lucene.472066.n3.nabble.com/Solr-set-up-issues-with-Magento-tp2323858p2323858.html
Sent from the Solr - User mailing list archive at Nabble.com.

Re: Solr set up issues with Magento

Posted by Erick Erickson <er...@gmail.com>.
There's almost no information to go on here. Please review:
http://wiki.apache.org/solr/UsingMailingLists

Best
Erick

On Tue, Jan 25, 2011 at 6:13 PM, Sandhya Padala <ge...@gmail.com> wrote:

> Thank you Markus. I have added few more fields to schema.xml.
>
> Now looks like the products are getting indexed. But no search results.
>
> In Magento if I configure to use SOlr as the search engine. Search is not
> returning any results.  If I change the search engine to use Magento's
> inbuilt MYSQL , Search results are returned.  Can you please direct me on
> where/how I  should start debug process.
>
> If I use Solr admin and enter the search query that doesn't return any
> results either.
>
> Thank you,
> Sandhya
>
> On Mon, Jan 24, 2011 at 4:11 PM, Markus Jelsma
> <ma...@openindex.io>wrote:
>
> > Hi,
> >
> > You haven't defined the field in Solr's schema.xml configuration so it
> > needs to
> > be added first. Perhaps following the tutorial might be a good idea.
> >
> > http://lucene.apache.org/solr/tutorial.html
> >
> > Cheers.
> >
> > > Hello Team:
> > >
> > >
> > >   I am in the process of setting up Solr 1.4 with Magento ENterprise
> > > Edition 1.9.
> > >
> > > When I try to index the products I get the following error message.
> > >
> > > Jan 24, 2011 3:30:14 PM
> > org.apache.solr.update.processor.LogUpdateProcessor
> > > fini
> > > sh
> > > INFO: {} 0 0
> > > Jan 24, 2011 3:30:14 PM org.apache.solr.common.SolrException log
> > > SEVERE: org.apache.solr.common.SolrException: ERROR:unknown field
> > > 'in_stock' at
> > > org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.jav
> > > a:289)
> > >         at
> > > org.apache.solr.update.processor.RunUpdateProcessor.processAdd(RunUpd
> > > ateProcessorFactory.java:60)
> > >         at
> > > org.apache.solr.handler.XMLLoader.processUpdate(XMLLoader.java:139)
> > >         at org.apache.solr.handler.XMLLoader.load(XMLLoader.java:69)
> > >         at
> > > org.apache.solr.handler.ContentStreamHandlerBase.handleRequestBody(Co
> > > ntentStreamHandlerBase.java:54)
> > >         at
> > > org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandl
> > > erBase.java:131)
> > >         at org.apache.solr.core.SolrCore.execute(SolrCore.java:1316)
> > >         at
> > > org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter
> > > .java:338)
> > >         at
> > > org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilte
> > > r.java:241)
> > >         at
> > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
> > > icationFilterChain.java:244)
> > >         at
> > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> > > ilterChain.java:210)
> > >         at
> > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
> > > alve.java:240)
> > >         at
> > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
> > > alve.java:161)
> > >         at
> > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
> > > ava:164)
> > >         at
> > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
> > > ava:100)
> > >         at
> > > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
> > > 550)
> > >         at
> > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
> > > ve.java:118)
> > >         at
> > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
> > > a:380)
> > >         at
> > > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
> > >
> > > :243)
> > >
> > >         at
> > > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
> > > ss(Http11Protocol.java:188)
> > >         at
> > > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
> > > ss(Http11Protocol.java:166)
> > >         at
> > > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoin
> > > t.java:288)
> > >         at
> > > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec
> > > utor.java:886)
> > >         at
> > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
> > > .java:908)
> > >         at java.lang.Thread.run(Thread.java:662)
> > >
> > > Jan 24, 2011 3:30:14 PM org.apache.solr.core.SolrCore execute
> > > INFO: [] webapp=/solr path=/update params={wt=json} status=400 QTime=0
> > > Jan 24, 2011 3:30:14 PM org.apache.solr.update.DirectUpdateHandler2
> > > rollback INFO: start rollback
> > > Jan 24, 2011 3:30:14 PM org.apache.solr.update.DirectUpdateHandler2
> > > rollback INFO: end_rollback
> > > Jan 24, 2011 3:30:14 PM
> > org.apache.solr.update.processor.LogUpdateProcessor
> > > fini
> > > sh
> > > INFO: {rollback=} 0 16
> > > Jan 24, 2011 3:30:14 PM org.apache.solr.core.SolrCore execute
> > >
> > > I am a new to both Magento and SOlr. I could have done some thing
> stupid
> > > during installation. I really look forward for your help.
> > >
> > > Thank you,
> > > Sandhya
> >
>

Re: Solr set up issues with Magento

Posted by Sandhya Padala <ge...@gmail.com>.
Thank you Markus. I have added few more fields to schema.xml.

Now looks like the products are getting indexed. But no search results.

In Magento if I configure to use SOlr as the search engine. Search is not
returning any results.  If I change the search engine to use Magento's
inbuilt MYSQL , Search results are returned.  Can you please direct me on
where/how I  should start debug process.

If I use Solr admin and enter the search query that doesn't return any
results either.

Thank you,
Sandhya

On Mon, Jan 24, 2011 at 4:11 PM, Markus Jelsma
<ma...@openindex.io>wrote:

> Hi,
>
> You haven't defined the field in Solr's schema.xml configuration so it
> needs to
> be added first. Perhaps following the tutorial might be a good idea.
>
> http://lucene.apache.org/solr/tutorial.html
>
> Cheers.
>
> > Hello Team:
> >
> >
> >   I am in the process of setting up Solr 1.4 with Magento ENterprise
> > Edition 1.9.
> >
> > When I try to index the products I get the following error message.
> >
> > Jan 24, 2011 3:30:14 PM
> org.apache.solr.update.processor.LogUpdateProcessor
> > fini
> > sh
> > INFO: {} 0 0
> > Jan 24, 2011 3:30:14 PM org.apache.solr.common.SolrException log
> > SEVERE: org.apache.solr.common.SolrException: ERROR:unknown field
> > 'in_stock' at
> > org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.jav
> > a:289)
> >         at
> > org.apache.solr.update.processor.RunUpdateProcessor.processAdd(RunUpd
> > ateProcessorFactory.java:60)
> >         at
> > org.apache.solr.handler.XMLLoader.processUpdate(XMLLoader.java:139)
> >         at org.apache.solr.handler.XMLLoader.load(XMLLoader.java:69)
> >         at
> > org.apache.solr.handler.ContentStreamHandlerBase.handleRequestBody(Co
> > ntentStreamHandlerBase.java:54)
> >         at
> > org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandl
> > erBase.java:131)
> >         at org.apache.solr.core.SolrCore.execute(SolrCore.java:1316)
> >         at
> > org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter
> > .java:338)
> >         at
> > org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilte
> > r.java:241)
> >         at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
> > icationFilterChain.java:244)
> >         at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> > ilterChain.java:210)
> >         at
> > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
> > alve.java:240)
> >         at
> > org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
> > alve.java:161)
> >         at
> > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
> > ava:164)
> >         at
> > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
> > ava:100)
> >         at
> > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
> > 550)
> >         at
> > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
> > ve.java:118)
> >         at
> > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
> > a:380)
> >         at
> > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
> >
> > :243)
> >
> >         at
> > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
> > ss(Http11Protocol.java:188)
> >         at
> > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
> > ss(Http11Protocol.java:166)
> >         at
> > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoin
> > t.java:288)
> >         at
> > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec
> > utor.java:886)
> >         at
> > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
> > .java:908)
> >         at java.lang.Thread.run(Thread.java:662)
> >
> > Jan 24, 2011 3:30:14 PM org.apache.solr.core.SolrCore execute
> > INFO: [] webapp=/solr path=/update params={wt=json} status=400 QTime=0
> > Jan 24, 2011 3:30:14 PM org.apache.solr.update.DirectUpdateHandler2
> > rollback INFO: start rollback
> > Jan 24, 2011 3:30:14 PM org.apache.solr.update.DirectUpdateHandler2
> > rollback INFO: end_rollback
> > Jan 24, 2011 3:30:14 PM
> org.apache.solr.update.processor.LogUpdateProcessor
> > fini
> > sh
> > INFO: {rollback=} 0 16
> > Jan 24, 2011 3:30:14 PM org.apache.solr.core.SolrCore execute
> >
> > I am a new to both Magento and SOlr. I could have done some thing stupid
> > during installation. I really look forward for your help.
> >
> > Thank you,
> > Sandhya
>

Re: Solr set up issues with Magento

Posted by Markus Jelsma <ma...@openindex.io>.
Hi,

You haven't defined the field in Solr's schema.xml configuration so it needs to 
be added first. Perhaps following the tutorial might be a good idea.

http://lucene.apache.org/solr/tutorial.html

Cheers.

> Hello Team:
> 
> 
>   I am in the process of setting up Solr 1.4 with Magento ENterprise
> Edition 1.9.
> 
> When I try to index the products I get the following error message.
> 
> Jan 24, 2011 3:30:14 PM org.apache.solr.update.processor.LogUpdateProcessor
> fini
> sh
> INFO: {} 0 0
> Jan 24, 2011 3:30:14 PM org.apache.solr.common.SolrException log
> SEVERE: org.apache.solr.common.SolrException: ERROR:unknown field
> 'in_stock' at
> org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.jav
> a:289)
>         at
> org.apache.solr.update.processor.RunUpdateProcessor.processAdd(RunUpd
> ateProcessorFactory.java:60)
>         at
> org.apache.solr.handler.XMLLoader.processUpdate(XMLLoader.java:139)
>         at org.apache.solr.handler.XMLLoader.load(XMLLoader.java:69)
>         at
> org.apache.solr.handler.ContentStreamHandlerBase.handleRequestBody(Co
> ntentStreamHandlerBase.java:54)
>         at
> org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandl
> erBase.java:131)
>         at org.apache.solr.core.SolrCore.execute(SolrCore.java:1316)
>         at
> org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter
> .java:338)
>         at
> org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilte
> r.java:241)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
> icationFilterChain.java:244)
>         at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> ilterChain.java:210)
>         at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
> alve.java:240)
>         at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
> alve.java:161)
>         at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
> ava:164)
>         at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
> ava:100)
>         at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
> 550)
>         at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
> ve.java:118)
>         at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
> a:380)
>         at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
> 
> :243)
> 
>         at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
> ss(Http11Protocol.java:188)
>         at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
> ss(Http11Protocol.java:166)
>         at
> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoin
> t.java:288)
>         at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec
> utor.java:886)
>         at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
> .java:908)
>         at java.lang.Thread.run(Thread.java:662)
> 
> Jan 24, 2011 3:30:14 PM org.apache.solr.core.SolrCore execute
> INFO: [] webapp=/solr path=/update params={wt=json} status=400 QTime=0
> Jan 24, 2011 3:30:14 PM org.apache.solr.update.DirectUpdateHandler2
> rollback INFO: start rollback
> Jan 24, 2011 3:30:14 PM org.apache.solr.update.DirectUpdateHandler2
> rollback INFO: end_rollback
> Jan 24, 2011 3:30:14 PM org.apache.solr.update.processor.LogUpdateProcessor
> fini
> sh
> INFO: {rollback=} 0 16
> Jan 24, 2011 3:30:14 PM org.apache.solr.core.SolrCore execute
> 
> I am a new to both Magento and SOlr. I could have done some thing stupid
> during installation. I really look forward for your help.
> 
> Thank you,
> Sandhya