WP Query breaks if there are term_ids in tax_query are more than 192

[Seldimi]

Hello.
I have faced a very wired issue. I am using a WP_Query to get custom posts (more specific 'product') with a tax query of around 193 term_ids as array as NOT IN. The wired problem is that WordPress adds odd term_ids in the $query->request... It works great until I have 192 term_ids, but if I add more, the query gets wired and blocks everything.

I am attaching the args and the query on a txt file.

Check that I dont filter term_category 239 but you will see it in request

[Seldimi]

Args and request

[javorszky]

Hi @Seldimi ,

When you say "gets wired and blocks everything.", what do you mean? What's the error message in the logs?

[Seldimi]

Hello again.
Sorry for not being specific in post. Well the sql generated from the WP Query adds more terns than those I give on arguments

If you check my attached file you will see an array of 193 term ids I want to add on the wp query.
If you see the generated query, it automatically adds more terms than I supplied.

Eg Term 239 is not on args but it’s on query generated! If I limit terms to 191, everything works normal.

[javorszky]

I've just noticed that your args structure is wrong. The tax query -> terms contains itself again. Can you double check that the args are correct?

[Seldimi]

Sorry was wrong on copy paste.. The query is working really well and used to be working for years. It's on a plugin I have made and it's used over 100 wordpress installations.

It's just the first time we had a website that needed over 192 terms. Can you simulate it somewhere?
Pretty odd but I'm sure I'm not doing anything wrong.

[Seldimi]

Correct file!