Skip Navigation

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.
Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 13:00 5:00 – 13:00 5:00 – 13:00 5:00 – 13:00 5:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: America/Argentina/Buenos_Aires (GMT-03:00)

This topic contains 1 reply, has 0 voices.

Last updated by Otto 5 days, 20 hours ago.

Assisted by: Otto.

Author Posts
April 3, 2025 at 11:13 am #16891588

eiriniG-2

Background of the issue:
We are trying to add a second email to new orders in our WordPress site using WPML.

Symptoms:
Εντοπίσαμε ένα πρόβλημα με ορισμένους πίνακες στη βάση δεδομένων. Παρακαλούμε επικοινωνήστε με την υποστήριξη του WPML για να το διορθώσετε. Σφάλμα βάσης δεδομένων WordPress: Η ερώτηση δεν μπόρεσε να εκτελεστεί επειδή περιέχει μη έγκυρα δεδομένα.

Questions:
How can we resolve the database error when adding a second email to new orders?

April 4, 2025 at 1:12 pm #16897742

Otto
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Argentina/Buenos_Aires (GMT-03:00)

Hello,

I apologize for the delay in responding. I will take care of this ticket; the reply time will be shorter now.

To ensure the quickest and most accurate support, please provide your debug information so I can look at some of your configurations. We have an excellent article on how to locate it here: https://wpml.org/faq/provide-debug-information-faster-support/.

Based on your description, it looks like certain WPML-related tables in your database might be missing or corrupted, causing the database error when you attempt to add a second email address to the “New Order” notification.

To resolve this, please follow these steps:
❌ Please make a full website backup before proceeding ❌

❌ Ensure All WPML Plugins Are Installed and Up to Date ❌

❌ Check if “WooCommerce Multilingual & Multicurrency (WCML)” is also installed and updated. ❌

1.Deactivate and Reactivate WPML
• Deactivating and reactivating can re-generate any missing WPML tables.

2. Use the WPML Troubleshooting Page
• Go to “WPML → Support → Troubleshooting”.
• Run the following options:
• Clear the cache in WPML
• Remove ghost entries from the translation tables
• Fix element_type collation
• Set language information
https://wpml.org/documentation/support/wpml-troubleshooting-options/

If the issue persists:
Please follow the instructions mentioned on this page: https://wpml.org/documentation/support/debugging-wpml/
Then, try to reproduce the issue and check your installation's **wp-content** folder to see if a file named **"debug.log"** was created (it will only be generated if a server error occurs).
If the file was created, please upload it to a platform like **Google Drive** or **Dropbox** (whichever you usually use) and share the link with me (make sure it is publicly accessible) so I can analyze it.

Best Regards,
Otto