Available Solutions

Problem:
WordPress found a fatal database error on the Website that looks this way:

COLLATION ‘utf8_general_ci’ is not valid for CHARACTER SET ‘utf8mb4’

Solution:
The reason for this issue is that various database tables use a different collations.

To solve the issue a matching and similar collation for all DB tables.

You can run the following MySQL query to solve such an issue, but it will need to be adjusted with the matching table prefix and also in case a different collation is used than mentioned inside the query:

ALTER TABLE wp_posts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;

Relevant Documentation:
https://dev.mysql.com/doc/refman/8.0/en/charset-database.html

Problem:
My problem now is that I want to add en-GB as a language. When I try to add English with a code of 'uk' I get an error that 'The Language code already exists.'. I assume this is because the database is pre-populated with Ukraine as a language. This is not unreasonable, but people in the UK often refer to the country as UK not GB, and even if I could change my folder for UK English to be GB it is pre-existing as UK, so this would cost me in SEO which I cannot accept.

Solution:
Deleting a language from WPML is not a good idea.
Instead, you can go to WPML → Languages → Site Languages, press the Add / Remove languages, add the Ukraininan language, then press the Edit Languages link. This way you'll be able to "transform" Ukrainian into UK English.

Relevant Documentation:
https://wpml.org/documentation/getting-started-guide/language-setup/#site-languages

Problem: I want to know how to translate some strings from a plugin

Solution: Please follow any of the methods described in the link below

Relevant Documentation: https://wpml.org/documentation/getting-started-guide/string-translation/finding-strings-that-dont-appear-on-the-string-translation-page/

Problem:
When moving between months, the url now looks like this:
domain.com/(/?:events)/(/?:month)/2020-05/ when it should look like domain.com/events/month/2020-05/

Solution:
Events Calendar takes the translation of months from WordPress language files. If you have those translation downloaded, month and day strings will be loaded from those files. Otherwise, you can delete language files and translate months using WPML.

Relevant Documentation:
https://theeventscalendar.com/knowledgebase/k/changing-the-language-on-your-calendar/

Problem:
When translating a page, it includes content that doesn't exist on the page. Upon investigation, I found that this is content that was added to the native WordPress editor. Upon switching the editor to Divi Builder, it saves it in the background, so it can be restored when you disable the Divi Builder again.

The problem is that WPML also sends this old content to the translator, who will then translate and charge for it. I can't find a way to get rid of it from within WordPress/Divi, so was hoping there is a way to exclude it from being send to the translator.

Solution:
The field that you're looking for is _et_pb_old_content.

I'm not sure if this field is needed by the Divi builder or not, but I went to WPML → Settings → Custom field translation, searched for this field, pressed the lock icon to be able to change its settings, and set it to copy (just to be safe).

Now, I went back to the page I created (in the original language), just hit the Update button (without opening the page in Divi builder), then updated the translation. This time, the field-_et_pb_old_content didn't appear anymore.

Relevant Documentation:
https://wpml.org/documentation/getting-started-guide/translating-custom-fields/

Problem: if you use Uni CPO and Multicurrency, you get always the default currency symbol even when you switch languages

Solution: see below

Relevant Documentation: https://wpml.org/forums/topic/wrong-currency-symbol-if-using-uni-cpo/#post-5792065

Problem:
Product variations are not copied / translated when a product is translated

Solution:
It should automatically copied: https://wpml.org/documentation/related-projects/woocommerce-multilingual/#variations

if not,
Did you install the WooCommerce Multilingual ? https://wpml.org/documentation/related-projects/woocommerce-multilingual/

Did you translate the attributes ?

Make the attribute copy/copy once/translate in WPML > Settings > Custom Term Meta Translation. screenshot attached.

Please go to WooCommerce -> WooCommerce Multilingual -> Attributes. Here, select your attribute and then click "Sync attributes and update product variations". Does this resolve the issue for you?

If not, please go to WooCommerce Multilingual and click on the Status tab. Scroll down and click the troubleshooting link. Then run through the troubleshooting steps. Does this resolve the issue?

Please be sure to make a full backup of your site and database.

Then, go to WPML -> Support -> Troubleshooting.

Look for 'Clean up' and click the following:

- Synchronize posts taxonomies (run this once for Variations and once for Products)

- Clear the cache in WPML

- Remove ghost entries from the translation tables

- Fix element_type collation

- Set language information

- Fix Terms count

- Fix post assignment for translations

After these steps, do the Product -> Attributes should show the correct counts.

Problem:
The main domain is mydomain.be. The second domain is mydomain.com. My objective here is: when people are in Dutch, they see the .be site. When they're in English, they see the .com site.

Solution:
Set up both domains to point to the same server IP address and the same directory where WordPress is located. Alias configuration should all point to the same physical folder where your WordPress is being installed. URL should show the same website.

Relevant Documentation:
https://wpml.org/tutorials/2016/04/use-wpml-different-domains-per-language/