Support

Forum Navigation
You need to log in to create posts and topics.

Search functionality does not work

Hi,

Since I've added More-Lang I have a problem with the search function of my site.

I've created a product named "test product" in woocommerce and made it visible in seearch, if I type "test" without More Lang I get the product page as a search result. If More-Lang is active I get the search page with zero results, even if I enter other keywords belonging to that product.

This problem occurs both with the custom search widget of my theme and with the default Wordpress search widget.

I have More-Lang Pro and I have enabled plugin support for WooCommerce in the settings.

Thank you

Hi giessedati,

   I can't reproduce the issue on my local server.

   Is the Product in URI-map? If a Post is in URI-map, it will be excluded from search if it's not in the current language. And to put Products in URI-map is not recommended, because their attributes are not synchronized.

Regards!

Hi,

thank you for your response.

I'm not using URI-map for products, I've also tried disabling More-Lang Pro just to be sure, but I still have this problem.

It resolves only if I deactivate More-Lang, but I don't know what could it be, I tried adding other products, I've made them visible in search but still they won't show up.

I've made a search with debug mode active and this is the result.

Thank you

 

Uploaded files:
  • Schermata-2020-08-19-alle-14.34.11.png

Hi giessedati,

   It's very likely that a plugin or the theme conflicts with More-Lang (both of them modify the SQL),  could you paste a full text of the "SELECT  SQL_CALC_FOUND_ROWS..." section?

Thanks!

Hi,

this is the full text:

SELECT SQL_CALC_FOUND_ROWS DISTINCT zy4CUL_posts.ID FROM
zy4CUL_posts LEFT JOIN zy4CUL_postmeta ON (zy4CUL_posts.ID =
zy4CUL_postmeta.post_id AND zy4CUL_postmeta.meta_key =
'rms_rm_uniq_meta_post_id' ) LEFT JOIN zy4CUL_postmeta AS mt1 ON
(zy4CUL_posts.ID = mt1.post_id AND mt1.meta_key =
'rms_remote_featured_image' ) LEFT JOIN zy4CUL_postmeta ON
zy4CUL_posts.ID = zy4CUL_postmeta.post_id WHERE 1=1 AND (
zy4CUL_posts.ID NOT IN (
SELECT object_id
FROM zy4CUL_term_relationships
WHERE term_taxonomy_id IN (6)
)
) AND (((zy4CUL_posts.post_title LIKE '%test%') OR
(zy4CUL_postmeta.meta_key LIKE '%morelang_nml_%' AND
zy4CUL_postmeta.meta_value LIKE '%test%') OR (zy4CUL_posts.post_excerpt
LIKE '%test%') OR (zy4CUL_posts.post_content LIKE '%test%'))) AND (
zy4CUL_postmeta.post_id IS NULL
AND
mt1.post_id IS NULL
) AND zy4CUL_posts.post_type = 'product' AND (zy4CUL_posts.post_status =
'publish' OR zy4CUL_posts.post_status = 'private') And zy4CUL_posts.ID
NOT IN (3276) GROUP BY zy4CUL_posts.ID ORDER BY zy4CUL_posts.post_title
LIKE '%test%' DESC, zy4CUL_posts.post_date DESC LIMIT 0, 9

I can say it's not the theme because even changing it does not solves the issue.

Thank you

Hi giessedati,
   The issue was confirmed. It is a plugins conflict issue. More-Lang can do something to avoid this type of conflict. It will be implemented in the next More-Lang release.
Thanks!

Hi,

thank you very much, I'm looking forward to the new update then, I tried deactivating every plugin but still got the same problem somehow.

If it can help, I use also an Event Calendar plugin, and it does not shows (or search for) any event only if more-lang is active.

This is the log:

SELECT SQL_CALC_FOUND_ROWS DISTINCT zy4CUL_posts.ID FROM
zy4CUL_posts LEFT JOIN zy4CUL_postmeta ON (zy4CUL_posts.ID =
zy4CUL_postmeta.post_id AND zy4CUL_postmeta.meta_key =
'_EventHideFromUpcoming' ) LEFT JOIN zy4CUL_postmeta AS mt1 ON (
zy4CUL_posts.ID = mt1.post_id ) LEFT JOIN zy4CUL_postmeta AS mt2 ON
(zy4CUL_posts.ID = mt2.post_id AND mt2.meta_key =
'rms_rm_uniq_meta_post_id' ) LEFT JOIN zy4CUL_postmeta AS mt3 ON
(zy4CUL_posts.ID = mt3.post_id AND mt3.meta_key =
'rms_remote_featured_image' ) LEFT JOIN zy4CUL_postmeta ON
zy4CUL_posts.ID = zy4CUL_postmeta.post_id WHERE 1=1 AND (
zy4CUL_postmeta.post_id IS NULL
AND
( mt1.meta_key = '_EventEndDateUTC' AND CAST(mt1.meta_value AS
DATETIME) < '2020-08-20 10:15:01' )
AND
mt2.post_id IS NULL
AND
mt3.post_id IS NULL
) AND zy4CUL_posts.post_type = 'tribe_events' AND
((zy4CUL_posts.post_status = 'publish' OR zy4CUL_posts.post_status =
'private')) And zy4CUL_posts.ID NOT IN (3276) GROUP BY zy4CUL_posts.ID
ORDER BY zy4CUL_posts.post_date ASC LIMIT 0, 13

Thank you

Hi giessedati,
   The new More-Lang was released, please upgrade to verify the conflict issue.
Thanks!

It works now, thanks!

I'd like to ask, would it be possible to get an Invoice (with VAT) for More-Lang Pro purchase?

Hi giessedati,

That's all right! Sorry, currently I am not able to provide.

Regards!


CONTACT: