SOLR and POLYLANG integration

You need to re-index completely your 2 indexes, if they existed before.

OK. I will try it one more time anew completly removing all of them.

Just empty, and synchronize all your indexes (in “Solr indexing Batch” tab)

Ok I tried everything. It always says it indexed only 1 document. When I’m using the polylang integration. We have three languages and it indexes 1 document for each language. As if the query would find only one result to index.

Please contact me on the wpsolr.com chat box.

already on the chat now

Check the POLYLANG version.

Yea will do that. Thanks for the advice

I’ll upgrade the plugin integrations with the minimum compatible version tested.

You can also index with the “debug” checkbox.

You’ll see the sql generated to retrieve the posts in the index’s language.

You can eventually understand if the data models changed since your POLYLANG version.

Hey,
so I updated the polylang plugin just like we said. In fact I updated all the plugins we have and the wpsolr still finds only 1 document to index if polylang integrations is turned on. I turned on also the debug and this is the sql query which is run :

SELECT ID, post_modified, post_parent, post_type FROM wp_posts AS posts JOIN wp_term_relationships AS wp_term_relationships ON posts.ID = wp_term_relationships.object_id AND wp_term_relationships.term_taxonomy_id = ‘5051’ WHERE ( ( post_status=’publish’ AND ( post_type in (‘post’,’page’,’polylang_mo’,’post_paper’,’post_video’,’post_podcast’,’post_infographic’,’post_htmlpapers’) ) ) OR ( ( post_status=’publish’ OR post_status=’inherit’ ) AND post_type=’attachment’ AND post_mime_type in (‘application/pdf’) ) ) ORDER BY post_modified ASC

with polylang integration turned on and this is the one without it :

SELECT ID, post_modified, post_parent, post_type FROM wp_posts AS posts WHERE ( ( post_status=’publish’ AND ( post_type in (‘post’,’page’,’polylang_mo’,’post_paper’,’post_video’,’post_podcast’,’post_infographic’,’post_htmlpapers’) ) ) OR ( ( post_status=’publish’ OR post_status=’inherit’ ) AND post_type=’attachment’ AND post_mime_type in (‘application/pdf’) ) ) ORDER BY post_modified ASC

The first returns only one post the second one returns 7800 posts. I checked and it must be something with that wp_term_relationships.term_taxonomy_id = ‘5051’ because that limits it to one post. Is that some kind of language ID in polylang which should define which posts to choose based on that ID ?

Thank you

yes, 5051 should contain the language definition that you selected for this index in your polylang integration settings.

You should have something like that in your wp_term_taxonomy table:

5051 5051 language a:2:{s:6:”locale”;s:5:”fr_FR”;s:3:”rtl”;i:0;} 0 123

ok so I got the problem my wp_term_relationships.term_taxonomy_id isn’t 5051 but 5581 … look …

5581 5051language a:2:{s:6:”locale”;s:5:”en_US”;s:3:”rtl”;s:1:”0″;}

5051 is the term_id

5581 is the term_taxonomy_id

How can we fix this ?

Thanks

term_taxonomy_id term_id taxonomy count
5581 5051 language a:2:{s:6:”locale”;s:5:”en_US”;s:3:”rtl”;s:1:”0″;} 3916

Here is a better version

In my own version of POLYLANG, term_id is always equal to term_taxonomy_id.

But it seems term_id should be used in the sql query.

Can you replace (line 80 of file wpsolr-search-engine/classes/extensions/polylang/plugin-polylang.php):

$sql_joint_statement .= " ON posts.ID = wp_term_relationships.object_id AND wp_term_relationships.term_taxonomy_id = '%s' ";

by

$sql_joint_statement .= " ON posts.ID = wp_term_relationships.object_id AND wp_term_relationships.term_id = '%s'  AND taxonomy = 'language'  ";