[Resolved] US variation of the page does not work

Hello again,

I have double-checked the problem, but so far I haven't been able to find a fix. I asked my colleagues to take a look to see if there's anything I'm missing.

I'll come back here as soon as one of them answers me (which shouldn't take long). Thank you in advance for your patience!

Regards,
Mateus.

Hi,

I have escalated this ticket to our 2nd tier of support where our 2nd tier specialists will take a deeper look at this issue and will try to find a solution.

I will get back to you as soon as I get an answer from them.

Best regards,
Mateus

Hey there,

Thanks for your patience.

Upon further inspection, we were able to spot several issues in the codes of your custom theme. For example, in the file: /wp-content/themes/lifebreath/controllers/Language.php you have this custom logic: https://pastebin.com/5zFQgsAg

This is hooked onto:

add_action( 'posts_where', array( $this, 'posts_where' ) );

And this is what makes the post return 404 error in the frontend. Basically, the code "switch the language" by replacing a query with a regular expression to the default language. So, if we have a clause "WHERE":

AND (wp_posts.ID = '321739') AND wp_posts.post_type = 'page' AND ( ( ( wpml_translations.language_code = 'us' OR 0 ) AND wp_posts.post_type  IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','product','product_variation','team-member','testimonial','resource','career' )  ) OR wp_posts.post_type  NOT  IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','product','product_variation','team-member','testimonial','resource','career' )  )</cde>

The logic replaces it to:

[php] AND (wp_posts.ID = '321739') AND wp_posts.post_type = 'page' AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_posts.post_type  IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','product','product_variation','team-member','testimonial','resource','career' )  ) OR wp_posts.post_type  NOT  IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','product','product_variation','team-member','testimonial','resource','career' )  )

If our post with ID 321739 (new translation in our sandbox) is with language "us", it alters the query so that we search for language "en" and this returns NOTHING. Here is where the problem lies.

As a workaround, you can go to the file: /wp-content/themes/lifebreath/controllers/Language.php, and comment-out the hook:

add_action( 'posts_where', array( $this, 'posts_where' ) );

And it should work fine.

However, please note: the solution provided is to be used just as an informational one. Remember that custom coding is out of the scope of our support so we can't create, debug or modify code for you and it's your responsibility to maintain it. We hope the one we used as an example could point you in the right direction. Please check our support policy: https://wpml.org/purchase/support-policy/

Thanks for your understanding.

Regards,
Mateus.

Hey there,

Thanks for your reply.

We have tested the workaround in our copy versions, and it works. Now you need to apply it to your website, could you please do that and tell us how it goes?

Just make sure to have a website backup before doing so.

Thank you, please let me know.