[tanyazailer]

Hi Geoff,

I did additional testings and I have some interesting results.
First, problem is now resolved, even for single April 2nd event.

1) Different languages in directories was already turned on
2) I switched off Rocket plugin

After testing of translations everything is working.

3) I switched back Rocket plugin – we need it for our business at this point
4) I deleted Russian translation of April 2nd to try to recreate it

After turning Rocket plugin on everything is still working. Event – April 2nd is translatable.

Conclusion: Seems like translations are working with Rocket plugin (we understand it’s no longer supported), but it seems like it’s not causing issues (at least not at this moment).

It seems like it was isolated event (on one Event), probably more related to WPML than to Events Calendar plugin. 🙂

Anyway, just to point out for other users who might read this, instructions that you provided in previous replies seems like sufficient steps to make this plugin work with WPML which is great! 🙂

Thank you for that,
All best,

[tanyazailer]

Hi George,

I’m sorry to hear that, but ok, we’ll find some workaround for our business.

I guess you are aware that you’re suggesting us to hire third party developers (not originally connected with your plugin or code) to implement feature / or resolve a bug that your company (with full team, resources and time) didn’t implement for nearly 2 years since first user requests… 🙂

All best,

[tanyazailer]

Hi Geoff,
Thank you very much, all best! 🙂

[tanyazailer]

Hi Geoff,

I’m not 100% sure it’s isolated event. I’m only sure that previous events didn’t have this and that simple event tests don’t have this issue. Maybe complicated events (with lots of code and meta, that our Editor is creating) will have this issue.

1) As you asked I provided sys info as a private reply.
2) I will print 2 screenshots, this is problematic event: http://cashflowtallinn.ee/event/open-cashflow-game-02-apr-2016-2/ , and these are examples of events that worked before:

http://cashflowtallinn.ee/event/open-cashflow-game-26-mar-2016/
http://cashflowtallinn.ee/event/open-cashflow-game-12-mar-2016/

3) Our primary language is English , and Russian and Estonian are secondary languages.

[tanyazailer]

This reply is private.

[tanyazailer]

Hi guys,
Quick addition to previous post. After quick testing of plugin with Query Monitor, this is what I came up with.
1) All of Tickets data is stored within _postmeta table, which is expected since Event is custom _post.
2) I looked at random queries from original plugin Events Calendar and this is what example select query looks like

SELECT t.element_id, t.language_code, t.source_language_code, t.trid
FROM l9iu_icl_translations t JOIN l9iu_posts p
ON t.element_id = p.ID
AND t.element_type = CONCAT(‘post_’, p.post_type) JOIN l9iu_icl_translations tridt
ON tridt.element_type = t.element_type
AND tridt.trid = t.trid
WHERE tridt.element_id IN (66,4396,4233)

Seems like these SQL queries are actually using _translations table and source_language_code and source_language attributes, which is also expected since plugin supports WPML.

3) When I looked at example query of Tickets plugin

SELECT l9iu_posts.ID
FROM l9iu_posts
INNER JOIN l9iu_postmeta
ON ( l9iu_posts.ID = l9iu_postmeta.post_id ) JOIN l9iu_icl_translations t
ON l9iu_posts.ID = t.element_id
AND t.element_type = CONCAT(‘post_’, l9iu_posts.post_type)
WHERE 1=1
AND ( ( l9iu_postmeta.meta_key = ‘_tribe_wooticket_for_event’
AND CAST(l9iu_postmeta.meta_value AS CHAR) = ‘6137’ ) )
AND l9iu_posts.post_type = ‘product’
AND ((l9iu_posts.post_status = ‘publish’))
AND ( ( t.language_code = ‘en’
AND l9iu_posts.post_type IN (‘post’,’page’,’attachment’,’product’,’product_variation’,’tribe_events’,’mc4wp-form’,’portfolio’ ) )
OR l9iu_posts.post_type NOT IN (‘post’,’page’,’attachment’,’product’,’product_variation’,’tribe_events’,’mc4wp-form’,’portfolio’ ) )
GROUP BY l9iu_posts.ID
ORDER BY l9iu_posts.post_date DESC

Seems like this query is not reading attributes from internationalization tables what so ever.

Wild guess: Is it possible that this bug is simply BAD SQL QUERY(s) for multilanguage SELECTION bug?
Question: Could it be possible to make this plugin support WPML with semi-simple changes inside SQL queries (maybe only select queries for tickets?)

You have language translation information inside _postmeta table when user created Event, so Ticket could “reuse” SQL concept that Event is using?

I don’t know ins and outs of Event and Ticket plugin so I’m unable to create some more serious testing for different SQL queries, but this seems doable?

Please, let me know what you think. Hope this is helpful in resolving this issue.
Let’s be real Tribe and resolve this issue together! 🙂

All best,

[tanyazailer]

+1 request for this feature 🙂
Please take a look at proposal https://theeventscalendar.com/support/forums/topic/issues-with-event-tickets-plus-and-wpml-multilingual-cms/

[tanyazailer]

Hi George,

Thank you for quick answer and for clear explanation that this feature is not currently supported, as well for a possibility for refund. However, we really like your plugin, and we’re open to search for different options to make this work.

Let me tell you our business model, so we can together figure out if we can make this work.
1) Our web site has several languages, WPML, WooCommerce and Events as main plugins
2) Our Events are translated with WPML and working correctly (since your infrastructure plugin provides WPML compatibility)
3) We need to sell tickets on our Events

I was thinking about options to make this work, please tell me what you think about them:
1) We’re open to hire you for custom coding to make this plugin support WPML. We need “minimum viable product”, so we need our tickets to simply appear on admin page and on frontend after we create them. We’re open to provide support from other side for bug tracking and cooperation of course.
2) Is there a way to disable WPML for this specific plugin? Some kind of patch to “hide” your plugin from WPML? This way, we could use our web site with WPML turned on, but it wouldn’t affect your plugin?
3) What other suggestion do you have for covering Event Tickets with WooCommerce on multilingual web sites? What other plugins for Ticket selling do you find compatible with your main plugin Events?

I did research trough your forum, WPML forum and WooCommerce forum, and I found many instances of users (since late 2014) which indicates this specific problem, and WPML response that they are open for collaboration.

I found this link on WooCommerce from June 2014 https://wpml.org/forums/topic/events-calendars-woocommerce-tickets-creation/ where WPML states it’s open for cooperation in order to make these plugins friendly. Since it seems like lots of users are affected is there some way of cooperation in order to resolve this? Maybe 3 side cooperation, WPML, Modern Tribe and us as beta end user? Just an idea.

Feel free to forward this question/initiative to parts of team who decides new features, and let me know if there’s anything we can do here.

All best,

p.s. Topic closely related to https://theeventscalendar.com/support/forums/topic/event-tickets-plus-and-wpml-compatibility/ and to several more. Seems like lots of premium users are actually begging this feature. 🙂

[tanyazailer]

Hi,
I did some more testing and this is what I got so far:

1. Yes, I can confirm https://theeventscalendar.com/knowledgebase/setting-up-the-events-calendar-with-wpml/
2. Yes, I translate events according https://theeventscalendar.com/knowledgebase/creating-translations-for-events-using-wpml/
3. When I create new event and test it everything is working…

After testing, seems like issue is related specifically to one event http://cashflowtallinn.ee/event/open-cashflow-game-02-apr-2016-2/?lang=en

For some reason, this event from 2nd April is not translatable (our Editor notified this as a bug, I double checked it)… After I try translation it simply doesn’t link En with Ru versions.

These are repeated events, and previous translations were working:

• http://cashflowtallinn.ee/event/open-cashflow-game-12-mar-2016/?lang=en
• http://cashflowtallinn.ee/event/open-cashflow-game-5-mar-2016/?lang=en

Seems like we’re experiencing this issue after large plugin update at 15th March.
If you like username/password for web site to check this out, just tell me which channel to use to provide it.

All best,

[tanyazailer]

Hi,
We found way to resolve issue.
We needed to install basic version of plugin and premium in order to make it work.
Licence activated, problem resolved.
All best,

[tanyazailer]

Hi everyone,

Same issue here, we have new licence related to site cashflowtallin.ee but dashboard reports “please install and activate latest version…”

All best,

[Author]

Posts