Skip to content Skip to sidebar

Home › Support › English Support › [Resolved] We have detected a problem with some tables in the database. Please contact WPML

[Resolved] We have detected a problem with some tables in the database. Please contact WPML

This thread is resolved. Here is a description of the problem and solution.

Problem:
The client reported issues after downloading the OTs installer, noting that the WPML plugin was missing and encountering a database error indicating that certain tables did not exist. Additionally, the client was unable to view content for translation when clicking the '+' in the WPML interface.

Solution:
We advised the client to follow these steps:
1. Visit the errata page for missing database tables at https://wpml.org/errata/missing-_icl_strings-_icl_string_translations-data-tables/ and apply the suggested fixes.
2. Remove the 'wpml_string_table_ok_for_mo_import' key from the '_options' database table.
3. Clear the website's cache to see if the issue persists.
4. Increase the WordPress memory limit by adding the following instructions from this link: https://wpml.org/faq/checklist-before-opening-a-ticket-in-wpml-support/#how-can-i-increase-my-sites-memory-limit
5. Ensure to back up the website fully before making any changes.

If these steps do not resolve the issue or if the solution seems outdated or irrelevant to your case, we highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If further assistance is needed, please open a new support ticket at WPML support forum.

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.

Tagged: 

This topic contains 8 replies, has 2 voices.

Last updated by Marsel Nikolli 1 year, 1 month ago.

Assisted by: Marsel Nikolli.

Author Posts
June 11, 2024 at 2:37 pm #15727345

shaunC-4

I dont know what is going on. I downloaded your OTs installer, and now its saying theres no WPML plugin.

Then this issue pops up

We have detected a problem with some tables in the database. Please contact WPML support to get this fixed.

Table 'i1575400_h8ai1.lszl_icl_strings' doesn't exist
Array
(
[language] => en
[context] => admin_texts_fusion_options
[gettext_context] =>
[domain_name_context_md5] => 96269b4483a75d85717941355fdbccaf
[name] => [fusion_options]header_number
[value] => Call Us Today! 1.555.555.555
[status] => 0
[translation_priority] => optional
[allow_empty_value] => 1
)
June 11, 2024 at 2:51 pm #15727475

Marsel Nikolli

Hi,

Thank you for contacting WPML Support, I will gladly help you.

Can you please check the instructions from this link:
https://wpml.org/errata/missing-_icl_strings-_icl_string_translations-data-tables/

Let me know how it goes,
Marsel
June 11, 2024 at 2:58 pm #15727509

shaunC-4

So do i remove the code or leave it there? in the functions file?
this image is still showing?

Im trying to translate a page to spanish from english. my about us page.

However when i click the + or gear icon only this is showing.

See images for original english page and only showing About us text on Spanish Page.

And why does it say waiting for translators. I dont want translators to do anything. Im doing the translating.

Screenshot 2024-06-11 at 16.56.56.png
Screenshot 2024-06-11 at 16.57.24.png
Screenshot 2024-06-11 at 16.57.31.png
Screenshot 2024-06-11 at 16.55.33.png
June 11, 2024 at 3:15 pm #15727872

Marsel Nikolli

Hi,

You should remove the code (as instructed on the link I shared).
Also, remove the “wpml_string_table_ok_for_mo_import” key from the “_options” database table.

After please try clearing the website's cache and check if the issue persists.

* Note: Please make sure you have a full backup of your website before making any updates/changes to your website.
June 11, 2024 at 3:17 pm #15727875

shaunC-4

I already removed the code, and showed you the same message above.
June 11, 2024 at 3:28 pm #15727961

Marsel Nikolli

The reason why the popup with the message "Waiting for the translator" is showing is that the user "admin" started the translation at some point and it wasn't completed. You can take the translation over and complete it after the popup should disappear.

1) Did you remove the “wpml_string_table_ok_for_mo_import” key from the “_options” database table?

2) Can you please share WPML support debug information from your site? To provide the debug information:

- Login to your site and go to WPML -> Support, in there click on the “debug information” link at the bottom of the page.
- Once on the “debug information” page, select the entire text box content and copy it.
- Go back to our support forum, find the debug information box, and paste it.

* Please do not share the debug information on your reply but only in the designated space.

More information on the link: https://wpml.org/faq/provide-debug-information-faster-support/
June 11, 2024 at 3:38 pm #15728028

shaunC-4

1. Ok but still i cannot see the content from the original page still. I already showed you the images?
Why when i click the + it opens the page but i cannot see the contentn to trasnlate?

1) Did you remove the “wpml_string_table_ok_for_mo_import” key from the “_options” database table?

No what on earth is that? But i did remove the code you told me to add from the functions p.p file

2) Can you please share WPML support debug information from your site? To provide the debug information:
yes
June 11, 2024 at 3:48 pm #15728038

Marsel Nikolli

Thank you for the debug information.

According to your debug.info, the WP memory limit needs to be increased, WordPress uses 40Mb as default and the minimum requirements for WPML are 128 MB.
Kindly check this page: https://wpml.org/home/minimum-requirements/

Please add the following code in your wp-config.php file right before the line: /* That's all, stop editing! Happy publishing. */ 

/* Memory Limit */
define('WP_MEMORY_LIMIT', '256M');
define( 'WP_MAX_MEMORY_LIMIT', '256M');

* Note: Please make sure you have a full backup of your website before making any updates/changes to your website.

---

I would need temporary access to your website to investigate this issue. Please create an administrator user using any email address you prefer.

Please fully back up your site (files and database) and confirm it in your next reply.
* Note: I might need to enable/disable plugins, switch themes, and access your website database.

I would need to access both your site's WP-admin and FTP account, please provide both.
Your next reply is set to private so you can provide the username and password details.

The “wpml_string_table_ok_for_mo_import” is a key on the “_options” database table, if it exists it needs to be removed. To check your database (if access from the server is not possible) I would need to use the plugin: https://wordpress.org/plugins/pexlechris-adminer/

Thanks,
Marsel
June 12, 2024 at 6:30 am #15729501

Marsel Nikolli

Hi,

Thank you for the access, I was able to check, and using the Adminer plugin I was able to delete the entry from the database. Now the notification message is removed.

I've noticed that the WP memory limit needs to be increased, WordPress uses 40Mb as default and the minimum requirements for WPML are 128 MB. (Kindly check this page: https://wpml.org/home/minimum-requirements/)

You can increase it by adding the following code in your wp-config.php file right before the line: /* That's all, stop editing! Happy publishing. */ 

/* Memory Limit */
define('WP_MEMORY_LIMIT', '256M');
define( 'WP_MAX_MEMORY_LIMIT', '256M');

* Note: Please make sure you have a full backup of your website before making any updates/changes to your website.

Let me know if you have any questions or need further assistance.

Kind regards,
Marsel