Re: Empty facets on Solr with MySQL

2014-01-03 Thread Andrea Gazzarini
s! > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Empty-facets-on-Solr-with-MySQL-tp4109170p4109425.html > Sent from the Solr - User mailing list archive at Nabble.com. >

Re: Empty facets on Solr with MySQL

2014-01-03 Thread PeterKerk
No need, you solved it! It was the id name, it had to be uppercase. btw the ; is still there in the query, but everything still works. Thanks! -- View this message in context: http://lucene.472066.n3.nabble.com/Empty-facets-on-Solr-with-MySQL-tp4109170p4109425.html Sent from the Solr - User

Re: Empty facets on Solr with MySQL

2014-01-03 Thread Andrea Gazzarini
ectionImpl.java:2819) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768) > at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894) > at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732) > at > org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.< > init>(JdbcDataSource.java:246) > ... 13 more > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Empty-facets-on-Solr-with-MySQL-tp4109170p4109398.html > Sent from the Solr - User mailing list archive at Nabble.com. >

Re: Empty facets on Solr with MySQL

2014-01-03 Thread PeterKerk
he.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.< init>(JdbcDataSource.java:246) ... 13 more -- View this message in context: http://lucene.472066.n3.nabble.com/Empty-facets-on-Solr-with-MySQL-tp4109170p4109398.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Empty facets on Solr with MySQL

2014-01-03 Thread Andrea Gazzarini
and data-config.xml, since I'm not even sure where it would have to be >> defined). >> >> >> >> Andrea Gazzarini-4 wrote >> > You can debug the resultset in a main class by doing rs.getString >> > ("cat_name") >> >> Wha

Re: Empty facets on Solr with MySQL

2014-01-03 Thread Andrea Gazzarini
wrote > > You can debug the resultset in a main class by doing rs.getString > > ("cat_name") > > What do you mean by 'in a main class'? Where can I define that? (ps. I'm > working with ASP.NET if that matters) > > Thanks again! :) > > &

Re: Empty facets on Solr with MySQL

2014-01-03 Thread PeterKerk
ne that? (ps. I'm working with ASP.NET if that matters) Thanks again! :) -- View this message in context: http://lucene.472066.n3.nabble.com/Empty-facets-on-Solr-with-MySQL-tp4109170p4109388.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Empty facets on Solr with MySQL

2014-01-03 Thread Andrea Gazzarini
; > > > **schema.xml** > > multiValued="true" /> > stored="true" multiValued="true" /> > > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Empty-facets-on-Solr-with-MySQL-tp4109170p4109353.html > Sent from the Solr - User mailing list archive at Nabble.com. >

Re: Empty facets on Solr with MySQL

2014-01-03 Thread PeterKerk
** -- View this message in context: http://lucene.472066.n3.nabble.com/Empty-facets-on-Solr-with-MySQL-tp4109170p4109353.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Empty facets on Solr with MySQL

2014-01-03 Thread Andrea Gazzarini
ryReader( > segments_4p:1330871938621:nrt)} > 36611 [Thread-15] INFO > org.apache.solr.handler.dataimport.SimplePropertiesWrite > r û Read dataimport.properties > 36614 [Thread-15] INFO > org.apache.solr.handler.dataimport.SimplePropertiesWrite > r û Wrote last indexed time to dataimport.properties > 36614 [Thread-15] INFO org.apache.solr.handler.dataimport.DocBuilder û > Time ta > ken = 0:0:0.367 > 36614 [Thread-15] INFO org.apache.solr.update.processor.LogUpdateProcessor > û [ > tv-wordpress] webapp=/solr path=/dataimport params={command=full-import} > status= > 0 QTime=13 {deleteByQuery=*:*,commit=} 0 13 > > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Empty-facets-on-Solr-with-MySQL-tp4109170p4109330.html > Sent from the Solr - User mailing list archive at Nabble.com. >

Re: Empty facets on Solr with MySQL

2014-01-03 Thread PeterKerk
a ken = 0:0:0.367 36614 [Thread-15] INFO org.apache.solr.update.processor.LogUpdateProcessor û [ tv-wordpress] webapp=/solr path=/dataimport params={command=full-import} status= 0 QTime=13 {deleteByQuery=*:*,commit=} 0 13 -- View this message in context: http://lucene.472066.n3.nabble.com/Empty-facets-on-Solr-wit

Re: Empty facets on Solr with MySQL

2014-01-03 Thread Andrea Gazzarini
ntire DB currently holds only 4 records, there's no need for a LIMIT > clause > I guess? > > > Andrea Gazzarini-4 wrote > > In the solr console set to DEBUG / FINEST the level of DIH classes > > How do I do that? > > Thanks! > > > > -- > View thi

Re: Empty facets on Solr with MySQL

2014-01-03 Thread Andrea Gazzarini
Thanks! > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Empty-facets-on-Solr-with-MySQL-tp4109170p4109290.html > Sent from the Solr - User mailing list archive at Nabble.com. >

Re: Empty facets on Solr with MySQL

2014-01-03 Thread PeterKerk
n the solr console set to DEBUG / FINEST the level of DIH classes How do I do that? Thanks! -- View this message in context: http://lucene.472066.n3.nabble.com/Empty-facets-on-Solr-with-MySQL-tp4109170p4109290.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Empty facets on Solr with MySQL

2014-01-02 Thread Andrea Gazzarini
Hi Peter, Hi Andrea, I changed it to: When I run full-import 0 documents are indexed, but no errors in the console. That's the reason why you can't see facets and errors: 0 documents are indexed When I run my query via MySQL Workbench the statement executes correctly. Once I spent a who

Re: Empty facets on Solr with MySQL

2014-01-02 Thread PeterKerk
.nabble.com/Empty-facets-on-Solr-with-MySQL-tp4109170p4109199.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Empty facets on Solr with MySQL

2014-01-02 Thread Andrea Gazzarini
Info available :(" -- View this message in context: http://lucene.472066.n3.nabble.com/Empty-facets-on-Solr-with-MySQL-tp4109170p4109186.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Empty facets on Solr with MySQL

2014-01-02 Thread PeterKerk
I get "Sorry, no Term Info available :(" -- View this message in context: http://lucene.472066.n3.nabble.com/Empty-facets-on-Solr-with-MySQL-tp4109170p4109186.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Empty facets on Solr with MySQL

2014-01-02 Thread Ahmet Arslan
host:8983/solr/wordpress/select/?indent=on&facet=true&sort=post_modified%20desc&q=*:*&start=0&rows=10&fl=id,post_title&facet.field=cat_name_raw&facet.mincount=1 But still I see empty facets. What more can I test? -- View this message in context: http://lucene.472066.

Re: Empty facets on Solr with MySQL

2014-01-02 Thread PeterKerk
ess/select/?indent=on&facet=true&sort=post_modified%20desc&q=*:*&start=0&rows=10&fl=id,post_title&facet.field=cat_name_raw&facet.mincount=1 But still I see empty facets. What more can I test? -- View this message in context: http://lucene.472066.n3.nabble.com/Empt

Re: Empty facets on Solr with MySQL

2014-01-02 Thread Ahmet Arslan
message in context: http://lucene.472066.n3.nabble.com/Empty-facets-on-Solr-with-MySQL-tp4109170.html Sent from the Solr - User mailing list archive at Nabble.com.

Empty facets on Solr with MySQL

2014-01-02 Thread PeterKerk
p;facet.mincount=1 **data-config.xml** **schema.xml** What am I missing? -- View this message in context: http://lucene.472066.n3.nabble.com/Empty-facets-on-Solr-with-MySQL-tp4109170.html Sent from the Solr - User mailing list archive at Nabble.com.