error in SQL Query ; Events Calendar Pro 4.0.3

[v2lam]

Hello

I found the following error in log file

Unknown column ‘wp_postmeta.meta_value’ in ‘field list’ pour la requ\xc3\xaate

SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, IF (wp_posts.post_type = 'tribe_events', wp_postmeta.meta_value, wp_posts.post_date) AS post_date FROM wp_posts  WHERE 1=1 AND 0  ORDER BY wp_posts.post_date DESC LIMIT 0, 10 

faite par include(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

The query should call wp_postmeta TABLE in FROM statement

SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, IF (wp_posts.post_type = 'tribe_events', wp_postmeta.meta_value, wp_posts.post_date) AS post_date FROM wp_posts,wp_postmeta WHERE 1=1 AND 0 ORDER BY wp_posts.post_date DESC LIMIT 0, 10

Both queries were tested and only the second one is correct.
But I don’t know if the ouput is the expected result 🙂

and thanks for your very nice and useful plugin

Jean-Michel

[Barry]

Hi Jean-Michel,

Thanks for reporting this!

I definitely see the problem in the first query, which is either missing a join or has an extra field depending on which way you look at it.

Were you able to determine which view (or views) trigger this error? For instance, if you visit month view do you find a new entry in the logs with the same error will appear? Or, if you visit a page with a particular event widget do you reliably find a new log entry occurs then?

Thanks for your help 🙂

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts