I am using the event calendar pro plugin to create events.
I have created some series/recurring events, but when I want to translate those recurring events, the language pane is missing the the options for us to translate or duplicate this event. Screenshot: hidden link
For non-recurring events, it has the 2 options, so that's good
screenshot : hidden link
Why are those 2 options missing for the recurring events? and how can I translate those?
Also, do we need to set 'Series' (that's part of the event calendar pro) to be Translatable in settings?
Screenshot: hidden link
When I set "Series" to 'Translatable' I get the error when I go to 'Series' page, and all my series disappeared.
screenshot: hidden link
This is the error:
"WordPress database error: [Unknown column 'wpml_translations.language_code' in 'where clause']
SELECT SQL_CALC_FOUND_ROWS wp_riKa6lc4lh_posts.ID FROM wp_riKa6lc4lh_posts LEFT JOIN wp_riKa6lc4lh_tec_series_relationships ON wp_riKa6lc4lh_posts.ID = wp_riKa6lc4lh_tec_series_relationships.series_post_id LEFT JOIN wp_riKa6lc4lh_tec_events ON wp_riKa6lc4lh_tec_events.event_id = wp_riKa6lc4lh_tec_series_relationships.event_id WHERE 1=1 AND ((wp_riKa6lc4lh_posts.post_type = 'tribe_event_series' AND (wp_riKa6lc4lh_posts.post_status = 'publish' OR wp_riKa6lc4lh_posts.post_status = 'tribe-ea-success' OR wp_riKa6lc4lh_posts.post_status = 'tribe-ea-failed' OR wp_riKa6lc4lh_posts.post_status = 'tribe-ea-schedule' OR wp_riKa6lc4lh_posts.post_status = 'tribe-ea-pending' OR wp_riKa6lc4lh_posts.post_status = 'tribe-ea-draft' OR wp_riKa6lc4lh_posts.post_status = 'future' OR wp_riKa6lc4lh_posts.post_status = 'draft' OR wp_riKa6lc4lh_posts.post_status = 'pending' OR wp_riKa6lc4lh_posts.post_status = 'private'))) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_riKa6lc4lh_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','tribe_event_series','tribe_venue','tribe_organizer','tribe_events' ) ) OR wp_riKa6lc4lh_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','tribe_event_series','tribe_venue','tribe_organizer','tribe_events' ) ) GROUP BY wp_riKa6lc4lh_posts.ID ORDER BY wp_riKa6lc4lh_tec_events.start_date_utc DESC LIMIT 0, 20"
I have deactivated most of the plugins keeping only:
-The Events Calendar
-The Events Calendar PRO
-WPML Multilingual CMS
-WPML String Translation
And I have switched the theme to the WP 2021 theme, the issue still persists.
I understand you can't translate the new "recurring events" feature in The Events Calendar PRO plugin.
Our developers are aware of this issue and working with the Events Calendar team to resolve it.
In the meantime, the Events Calendar development team shared a workaround to revert to the old data storage by adding this code in the wp-config.php file:
Thank you Ahmed! Adding the line of code resolved the issue, but the 'Series' Post type doesn't exist anymore, is that correct?
Adding that line of code reverts it back to the old way, which I prefer more because it shows all instances of the recurring events.
When I created new recurring events, it shows all the instances in the admin Events page (admin), which is fine.
Screenshot of the new recurring event that I've created after the code is added: hidden link
Before adding the line of code, I have a couple of Series events already created, but now it still only shows the first instance.
Screenshot of the recurring event showing only the first instance after code is added: hidden link
What do I have to do to display all instances of those recurring events?
Thank you for confirming that the code resolved the original issue.
When you say "Series' Post type doesn't exist anymore" I assume that some posts with Series in the title are now lost. If that is the case, this should not happen with the code. Most probably there was some other issue causing this. If this is a different case please let me know more details on the issue.
Can you please Backup the site to prevent any issues then:
- go to: WordPress Dashboard -> WPML -> Support page, Click on the "Troubleshooting" link there
- click on the Clear and Fix options there like the following options except for the Reset options. Those options will fix any translation and Database issues if there are any.
Clear the Cache in WPML
Remove ghost entries from the translation tables
Fix element_type collation
Fix WPML table collation
Set language information
Thank you for the updates. I would need to take a closer look at your site. So I would need to request temporary access (WP-Admin and FTP), preferably to a test site where the problem has been replicated.
Your next answer will be private, which means only you and I have access to it.
IMPORTANT: Please take a complete backup of the site to avoid data loss.
Regards,
Subash
The topic ‘[Closed] Issue with translating Recurring Events (the event calendar pro)’ is closed to new replies.
