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.

This topic contains 2 replies, has 2 voices.

Last updated by Bruno Kos 2 months ago.

Assigned support staff: Bruno Kos.

Author Posts
August 11, 2019 at 8:37 pm

kerstinK-2

I get the following error:

We have detected a problem with some tables in the database. Please contact WPML support to get this fixed.
Table 'wesound.BzS4i0Qm_icl_strings' doesn't exist in engine
Array
(
[language] => de
[context] => admin_texts_wpseo_titles
[gettext_context] =>
[domain_name_context_md5] => e378148fddf4e947517c053abc51db93
[name] => [wpseo_titles]title-home-wpseo
[value] => %%sitename%% %%page%% %%sep%% %%sitedesc%%
[status] => 0
[translation_priority] => optional
[allow_empty_value] => 1
)

August 11, 2019 at 9:27 pm #4377553

kerstinK-2

Additonally, in my error_logs I get the following error message:

Got error 'PHP message: WordPress database error Table 'wesound.BzS4i0Qm_icl_strings' doesn't exist in engine for query SHOW FULL COLUMNS FROM `BzS4i0Qm_icl_strings` WHERE Collation LIKE 'utf8mb4%' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_Translations_File_Scan_Hooks->import_translations_files, WPML_ST_Translations_File_Queue->import, WPML_ST_Translations_File_Scan->load_translations, WPML_ST_Translations_File_Scan_Db_Charset_Filter_Factory->create, WPML_ST_Translations_File_Scan_Db_Charset_Validation->is_valid, WPML_ST_Translations_File_Scan_Db_Charset_Validation->get_unique_collation_list_from_table\nPHP message: WordPress database error Table 'wesound.BzS4i0Qm_icl_strings' doesn't exist in engine for query SHOW FULL COLUMNS FROM `BzS4i0Qm_icl_strings` made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Autoregister_Save_Strings->shutdown, WPML_Autoregister_Save_Strings->persist\nPHP message: WordPress database error Table 'wesound.BzS4i0Qm_icl_strings' doesn't exist in engine for query INSERT IGNORE INTO BzS4i0Qm_icl_strings (`language`, `context`, `gettext_context`, `domain_name_context_md5`, `name`, `value`, `status`) VALUES ('en', 'default', '', '9f743e9d4b4fe7d3cc50d3222d6cd3c8', '4e98e60e38a29ab7bd94ea815c4f2ef2', 'Parent Category', 0),('en', 'default', '', 'fcfcd2be35b73a157a075fa15a31cc18', 'dc5b753561079ca416a04fa17e221bee', 'Parent Category:', 0),('en', 'default', '', '11520f77ec9ae1cc8fc1114f14581138', '3854516c160b786e4a58a349089ade9d', 'Edit Tag', 0),('en', 'default', '', '330d12ed03695f68dc5c840cd93f79a1', '176bf027c77f1139b35c26a2b0641497', 'Edit Category', 0),('en', 'default', '', '81809b4b8a63f9bb427f481adee951b4', '3ef43c95f7b82ae64a8407f95caeabe5', 'View Tag', 0),('en', 'default', '', 'f10d678299bf0be3f029234d66dd385d', 'a0925476f70856079fc6f34624318308', 'View Category', 0),('en', 'default', '', '7e30d063186dca5435f224b6a32f5828', '639aa9045afb08bc935d23192a984...\nPHP message: WordPress database error Table 'wesound.BzS4i0Qm_icl_strings' doesn't exist in engine for query INSERT IGNORE INTO BzS4i0Qm_icl_strings (`language`, `context`, `gettext_context`, `domain_name_context_md5`, `name`, `value`, `status`) VALUES ('en', 'default', '', '49183c7b900a162c6d2f31ff3a4dce90', '8d41dcf3c3971ffa0531b6e96ac2d1ac', 'HTTP error.', 0),('en', 'default', '', 'e7261d1cf87f29f6411ae72ae1fc3ca5', 'cde28f5998d2dd5da84a4ab21143bc67', 'Upload failed.', 0),('en', 'default', '', '1e39e715443537d3a810a0c419c0f973', '2812f6aa95814b2e90121ffabcfa86c7', 'Please try uploading this file with the %1$sbrowser uploader%2$s.', 0),('en', 'default', '', '53dc4403d523f0d65dca68da8a667e96', 'bf9e89898a40abef46220b2cd89fab84', '%s exceeds the maximum upload size for the multi-file uploader when used in your browser.', 0),('en', 'default', '', 'd28f2f36b7b65b10cb758adfdc70f8e9', '060dc976eff512760d472fbc3cc2f423', 'IO error.', 0),('en', 'default', '', 'def8fc038755e26eb0d5db4583aa83ab', '11b0e87d9dba6df...\nPHP message: WordPress datab', referer: hidden link

August 12, 2019 at 12:28 pm #4380709

Bruno Kos
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hi,

Thank you for contacting WPML support!

We may have a two related issues here we can resolve in one take, so let's do this:

Problem 1)
***********************

Can you tell me if you tried this and if works?
https://wpml.org/forums/topic/we-have-detected-a-problem-with-some-tables-in-the-database-52/#post-2907927

Also see this (for explanation as well):
https://wpml.org/forums/topic/message-we-have-detected-a-problem-with-some-tables-in-the-database/#post-2803566

As per above answer (2nd one), you could also check if there is a "%%sitename%% %%page%% %%sep%% %%sitedesc%%" text within string translation or remove it from String Translation table or by removing the empty value from your database table "wp_icl_strings".

Please make a full backup of your site before trying this or make these changes on a staging/development site!

You can use plugins such as UpdraftPlus WordPress Backup Plugin (https://wordpress.org/plugins/updraftplus/) or ask your host to perform a site backup.

***********************

Problem 2)
***********************
Please check this thread:
https://wpml.org/forums/topic/wordpress-database-error-table/#post-4217129

Let me know how it goes!

Regards,
Bruno Kos