lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrea Gazzarini <a.gazzar...@gmail.com>
Subject Re: Empty facets on Solr with MySQL
Date Fri, 03 Jan 2014 17:53:09 GMT
Yes, that definitely matters...I was talking about a simple java class.

Peter, sincerely? I don't know.

Are you sure you are doing then same queries with the same article.id as
solr does? and sorry for the stupid question but are you sure that for
those article ids the cat_name is not null?
 On 3 Jan 2014 18:37, "PeterKerk" <vetteparty@hotmail.com> wrote:

> But when I execute the query directly on MySQL I do get a cat_name column
> in
> there:
>
> select wt.name as
> cat_name,wt.slug,wtr.term_taxonomy_id,wtt.term_id,wtt.taxonomy from
> wp_term_relationships wtr
> INNER JOIN wp_term_taxonomy wtt ON
> wtt.term_taxonomy_id=wtr.term_taxonomy_id
> AND wtt.taxonomy='category'
> INNER JOIN wp_terms wt ON wt.term_id=wtt.term_taxonomy_id
> where wtr.object_id=18
>
> I see no reason why my configuration in my data-config.xml would not
> execute
> successfully:
>
>             <entity name="post_categories" query="select wt.name as
> cat_name,wt.slug,wtr.term_taxonomy_id,wtt.term_id,wtt.taxonomy from
> wp_term_relationships wtr
> INNER JOIN wp_term_taxonomy wtt ON
> wtt.term_taxonomy_id=wtr.term_taxonomy_id
> AND wtt.taxonomy='category'
> INNER JOIN wp_terms wt ON wt.term_id=wtt.term_taxonomy_id
> where wtr.object_id='${article.id}';">
>
>
>             </entity>
>
>
> I have no transformers on my resultset (I checked my querystring,
> schema.xml
> 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")
>
> 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! :)
>
>
>
> --
> 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.
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message