Home›Support›English Support›[Escalated to WPML Developers team] Multilingual & Multicurrency duplicates Bookings in WooCommerce Bookings
[Escalated to WPML Developers team] Multilingual & Multicurrency duplicates Bookings in WooCommerce Bookings
This is the technical support forum for WPML - the multilingual WordPress plugin.
Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.
Our wait time is higher than usual, please make sure you are meeting the minimum requirement - https://wpml.org/home/minimum-requirements before you report issues, and if you can take a look at current Known Issues - https://wpml.org/known-issues/. Thank you.
@Itamar
Well, I did test after setting wc_bookings as Not Translatable.
One more thing, I also made a separate language products (ENG and RUS) without translation and again the Bookings list looks very strange - each language product without translation has a dummy duplicate record in other language.
We are dealing with the "Incorrect booking stats" issue in this ticket. We have escalated the issue to our developers. We will update you once we have news regarding this issue.
We also have the following known issue, which has also been escalated to our developers: "The booking is added times the number of languages to Google Calendar." I mentioned it in my first reply to you on this thread.
We cannot add new issues to this ticket, as it has been escalated to our developers. If you believe that the last issue you found is new, please open a new ticket about it.
On live site the provided snippet does not work with following errors:
[12-Jul-2024 21:06:08 UTC] WordPress database error Unknown column 'translations.source_language_code' in 'where clause' for query SELECT COUNT(DISTINCT wcbookings.ID) AS count
FROM wp_posts AS wcbookings
INNER JOIN wp_posts AS wcorder
ON wcbookings.post_parent = wcorder.ID
WHERE wcorder.post_type IN ( 'shop_order' )
AND wcbookings.post_type IN ( 'wc_booking' )
AND wcorder.post_status IN ( 'wc-completed', 'wc-processing', 'wc-on-hold', 'wc-refunded' )
AND wcorder.post_date >= '2024-07-01'
AND wcorder.post_date < '2024-07-13 07:06:08' AND translations.source_language_code IS NULL made by wp_dashboard, do_meta_boxes, WC_Admin_Dashboard->status_widget, do_action('woocommerce_after_dashboard_status_widget'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Bookings_Report_Dashboard::add_stats_to_dashboard
[12-Jul-2024 21:06:08 UTC] WordPress database error Unknown column 'translations.source_language_code' in 'where clause' for query SELECT COUNT(DISTINCT wcbookings.ID) AS count
FROM wp_posts AS wcbookings
WHERE wcbookings.post_type IN ( 'wc_booking' )
AND wcbookings.post_status = 'pending-confirmation' AND translations.source_language_code IS NULL made by wp_dashboard, do_meta_boxes, WC_Admin_Dashboard->status_widget, do_action('woocommerce_after_dashboard_status_widget'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Bookings_Report_Dashboard::add_stats_to_dashboard
Our second-tier supporter asked you to check if you copied the code snippet for the workaround 1:1. He added that according to the error, it seems to be missing the inner join with the icl_translations table. Otherwise, please wait for a permanent fix.
The issue is still being escalated to our developers.
