Hi, can you post
* the output of MySQL's describe command for all tables/views referenced in your DIH configuration
* the DIH configuration file (i.e., data-config.xml) * the schema definition (i.e., schema.xml) -Sascha Jean-Michel Philippon-Nadeau wrote:
Hi, It is my first install of Solr. The setup has been pretty straightforward and yet, the performance is very impressive. I am running into an issue with my MySQL DataImportHandler. I've followed the quick-start in order to write the necessary config and so far everything seemed to work. However, I am missing some fields in my index. I've switched all fields to stored="true" temporarily in my schema to troubleshoot the issue. I only have 3 fields listed in search results while I should have 8. Could this be caused by ampersands or illegal entities in my database? How can I see if DIH is importing correctly all my rows into the index? Follows is the warning I have in my catalina.log. Thank you very much, Jean-Michel === Feb 2, 2010 12:21:07 AM org.apache.solr.handler.dataimport.SolrWriter upload WARNING: Error creating document : SolrInputDocument[{keywords=keywords(1.0)={Dolce}, name=name(1.0)={Dolce & Gabbana D&G Neckties designer Tie for men 543}, productID=productID(1.0)={220213}}] java.lang.NullPointerException at org.apache.lucene.util.StringHelper.intern(StringHelper.java:36) at org.apache.lucene.document.Field.<init>(Field.java:341) at org.apache.lucene.document.Field.<init>(Field.java:305) at org.apache.solr.schema.FieldType.createField(FieldType.java:210) at org.apache.solr.schema.SchemaField.createField(SchemaField.java:94) at org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.java:246) at org.apache.solr.update.processor.RunUpdateProcessor.processAdd(RunUpdateProcessorFactory.java:60) at org.apache.solr.handler.dataimport.SolrWriter.upload(SolrWriter.java:75) at org.apache.solr.handler.dataimport.DataImportHandler $1.upload(DataImportHandler.java:292) at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:392) at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:242) at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:180) at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:331) at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:389) at org.apache.solr.handler.dataimport.DataImporter $1.run(DataImporter.java:370)