Calendar Bug

[Jonathan Hawkes]

It’s the event calendar which is throwing an error and breaking stuff. Can you submit a ticket and let them know they have an error?
We found an issue. Please see below

the-events-calendar/src/Tribe/Query.php on line 960

WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ wp_posts.post_date) AS post_date FROM wp_posts INNER JOIN wp_term_relationship’ at line 1 for query SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, IF (wp_posts.post_type = ‘tribe_events’, .meta_value, wp_posts.post_date) AS post_date FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_icl_translations t ON wp_posts.ID = t.element_id
AND t.element_type = CONCAT(‘post’, wp_posts.post_type) LEFT JOIN wp_postmeta as on wp_posts.ID = .post_id AND .meta_key = ‘EventStartDate’ WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (1283)
) AND wp_posts.post_type IN (‘post’, ‘tribe_events’) AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_author = 1 AND wp_posts.post_status = ‘private’) AND ( ( t.language_code = ‘ja’ AND wp_posts.post_type IN (‘post’,’page’,’acf-field-group’,’nereus_people’,’nereus_partner’,’nereus_publication’,’nereus_video’,’nereus_presentation’,’nereus_positions’,’tribe_events’,’tribe_venue’,’tribe_organizer’ ) ) OR wp_posts.post_type NOT IN (‘post’,’page’,’acf-field-group’,’nereus_people’,’nereus_partner’,’nereus_publication’,’nereus_video’,’nereus_presentation’,’nereus_positions’,’tribe_events’,’tribe_venue’,’tribe_organizer’ ) ) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

[Nico]

Hi Jonathan,

Thanks for reporting this issue! To make sure it’s a bug in our codebase, Can you please follow the steps described in our Testing for conflicts guide? This way we can see if this is a problem in our plugin or a conflict with the theme or other installed plugins.

Also it would be great if you could share your system information with me so I can check if everything looks right on that end.

Thanks,
Nico

[Jonathan Hawkes]

I have disabled your plugin and then went to the problem page: http://www.nereusprogram.org/ja/tag/climate-change-ja/ with your plugin enabled the JAPANESE tag articles do not show. But when your plugin is disabled it show’s no articles e.g. https://drive.google.com/file/d/0B2ipEo0PqtvdSm5hZEY0OXJZTTQ/view?usp=drivesdk

[Jonathan Hawkes]

i think you need to test you plugin with wpml and viewing tags in another language.

[Nico]

Hi Jonathan,

Thanks for following up with this information, I’ll add this for review in our product backlog.

For now can you try to use a plugin called Plugin Logic to disable The Events Calendar for that page. Also it would be useful to know if you noticed this happening with just default theme and with no other plugins active a part from WPML and ours.

Thanks for your patience on this,
Best,
Nico

[Jonathan Hawkes]

My developer was saying that the error was on all pages not just the one I pointed out. We used WP debug mode to see that error.

[Jonathan Hawkes]

This reply is private.

[Nico]

Hey Jonathan,

Thanks for that information. So recapping a bit on this bug report:

• You confirmed this is a conflict between WPML and The Events Calendar.
• This was tested with default WordPress theme and no other plugins active.
• You could see this error in all site views.
• The site is in English and Japanese, the later being default language.

Any other configuration I’ve might need to change in order to replicate this? Also can you please share your system information with me so I can check if everything looks right on that end also.

Thanks,
Nico

[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