dmzw

Now i have this

[16-Mar-2026 07:13:26 UTC] PHP Warning: foreach() argument must be of type array|object, string given in /wp-content/plugins/schema-and-structured-data-for-wp/output/markup.php on line 3495

The story continues. Another bug has been identified .

A critical bug in the current version of WP Multilang that causes SQL syntax errors when used with WooCommerce filters (e.g., in get_filtered_term_product_counts).

The issue causes “merged” strings in the final SQL query, such as:

1. _languages'mt1.meta_value (Missing AND between meta keys)
2. post_status = 'publish' ( (Missing AND before the opening parenthesis)

Root Cause Analysis:
The bug is located in includes/class-wpm-posts.php within the filter_posts_by_language method.

1. Issue with wp_parse_args: The plugin uses wp_parse_args to merge language meta queries with the existing meta_query. This function “flattens” multi-dimensional arrays, which destroys the nested structure required by WooCommerce and WordPress for complex meta queries. This results in the missing AND and merged strings like _languages'mt1.meta_value.
2. Improper WHERE clause joining: In some cases, the language conditions are appended to the WHERE clause without checking for the existence of a logical operator (AND), leading to syntax errors like post_status = 'publish' (.

Proposed Fix:
Instead of using wp_parse_args, the meta queries should be merged while preserving their nested structure and explicitly defining the relation.

Suggested code change in filter_posts_by_language:

// Instead of:
// $lang_meta_query = wp_parse_args( $query->query_vars['meta_query'], $lang_meta_query );

// Use a safe nested merge:
if ( ! empty( $query->query_vars['meta_query'] ) ) {
    $lang_meta_query = array(
        'relation' => 'AND',
        array(
            'relation' => 'AND',
            $query->query_vars['meta_query']
        ),
        $lang_meta_query
    );
}

This ensures that the language filter is always added as a separate, properly joined block, preventing the SQL “merging” effect.

Please review this fix and include it in the next update to prevent errors when using faceted search or complex product filters.

“The issue occurs specifically during the execution of get_filtered_term_product_counts in WooCommerce. It happens when WP Multilang attempts to filter products by language within a complex SQL join created by the Layered Nav widget.

To reproduce:

1. Install WooCommerce and WP Multilang.
2. Create several products with translations (UA/EN).
3. Add the standard WooCommerce “Filter Products by Attribute” widget to a sidebar.
4. Navigate to the Shop page and interact with the attributes filter.
5. Check the error_log for a ‘SQL syntax error’ near _languages'mt1.meta_value.

The syntax error is caused by a missing space/operator between the meta_key and the next condition in the WHERE clause generated by your plugin.”

ok I’ll wait quietly but impatiently

but why is the topic marked as already solved?

NO!!!!

IT’S ANOTHER PROBLEM!!!
NOT FIXED in PREVIOUSLY CLOSED TOPIC!

https://ww.wp.xz.cn/support/topic/yoast-problem-4/#post-17919323

i tested again – 2.4.19 crashes the site.
rolling back to 2.4.18 – it is ok

it looks like plugin is deactivated
url mysite.com/en/* – 404 not found
but shows all with broken text in mysite.com/*

all menus, woo products – no translations, all text in raw format with []

text in pages – still ok (if not woo shortcode or menu widget inside)

It’s not about the theme
it’s about how WP-Miltilang processes Yoast titles
Maxspell’s site screen
https://prnt.sc/TISb88XQGeB5

I have the same. other Theme
AND i have sites with WP Multilang v 2.4.1 with no such issue (All sites – same Theme)

Moreover, in “secondary” language page I have BOTH Language TITLES
1) Title

https://prnt.sc/pllskc9jnRTc

<title>Default Language Title- Alternate Language Title - SITENAME [:]</title>

2) Title for OpenGraph
https://prnt.sc/szO3djufTWbq

<meta property="og:title" content="Default Language Title- Alternate Language Title - SITENAME [:]" default="" language="">

WHAT DETAILS???
i dont unerstand!!!

its simple woocomerce engine!
i gave you screenshots, then another screen.

made product example – you can test.
made explanations.
what else?