search

WPDevelopers / essential-addons-for-elementor-lite

Essential Addons for Elementor. Ultimate elements library for Elementor.
https://essential-addons.com/elementor/
43 stars 41 forks source link

Post Grid sql query needs to be unique to avoid conflicts #732

Closed AllTrialsAwait closed 1 year ago

AllTrialsAwait commented 2 years ago

Hello looking through issues I noted one about the Post Grid having an error with Tribe Events BUT this is not unique to that plugin. I have had the same conflict but with a different plugin and the reason is this in the sql query WordPress database error Unknown column 'wp_postmeta.meta_value' in 'field list' for query

This is because it uses a ‘LEFT JOIN’s using ‘$wpdb->postmeta’ but WordPress only allows one of those at a time without an alias. Could you please solve this by aliasing that LEFT JOIN? It would future proof conflicts with other plugins and make yours more stable.

That is my advice thank you

abid112 commented 2 years ago

Thanks, @AllTrialsAwait for pointing this out! Our dev team is working on it. Hopefully, this will be fixed in the next few releases.

Have a good day!

abid112 commented 1 year ago

Hi @AllTrialsAwait

I wanted to let you know that we have already resolved this issue quite some time ago. Furthermore, our plugin does not employ any Left joining.

During our investigation, we discovered that the Event Calendar plugin was utilizing Left joining, which led to the problem you mentioned. There is a relevant discussion on the ORG thread that delves into this matter: link to the discussion.