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.

This topic contains 3 replies, has 2 voices.

Last updated by shaneB-8 3 years, 11 months ago.

Assigned support staff: Bobby.

Author Posts
December 12, 2017 at 3:26 pm #1455770

shaneB-8

I am trying to: Run my website but receive massive amount of errors in my apache logs pertaining to :

WordPress database error Table 'wp_icl_string_pages' doesn't exist for query \n\t\t\t\t\tSELECT DISTINCT \n\t\t\t\t\t\ts.id,\n\t\t\t\t\t\ts.name,\n\t\t\t\t\t\ts.context,\n\t\t\t\t\t\tst.status,\n\t\t\t\t\t\ts.gettext_context, \n\t\t\t\t\t\tst.value AS tra,\n\t\t\t\t\t\tst.mo_string AS mo_string,\n\t\t\t\t\t\ts.value AS orig\n\t\t\t\t\tFROM wp_icl_string_pages sp\n\t\t\t\t\tINNER JOIN wp_icl_string_urls su\n\t\t\t\t\t\tON su.id = sp.url_id\n\t\t\t\t\tINNER JOIN wp_icl_strings s\n\t\t\t\t\t\tON s.id = sp.string_id\n\t\t\t\t\tLEFT JOIN wp_icl_string_translations st\n\t\t\t\t\t\tON s.id=st.string_id\n\t\t\t\t\t\t\tAND st.language=su.language\n\t\t\t\t\t\t\tAND s.language!=su.language\n\t\t\t\t\tWHERE (su.language='en' and su.url='/') or (su.language='en' and su.url IS NULL)\n\t\t\t\t\t made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_DB_Cache->shutdown, WPML_ST_Page_Translations_Cached_Persist->store_new_translations, WPML_ST_Page_Translations_Persist->get_translations_for_page

I expected to see: Happiness and no errors

As well, I noticed in other log messages that I should add an install function in my functions.php which I do but this did not resolve my problem.

December 13, 2017 at 8:35 am #1456380

Bobby
Supporter

Languages: English (English )

Timezone: America/Los_Angeles (GMT-08:00)

Hello,

If possible please go to your database and share with me a screenshot of your icl_ database tables.

Are you referring to the following errata ?
https://wpml.org/errata/missing-_icl_strings-_icl_string_translations-data-tables/

December 13, 2017 at 1:17 pm #1456736

shaneB-8

Here ya go there is no table identified by that name which is odd.

Selection_004.png
December 13, 2017 at 5:30 pm #1457108

Bobby
Supporter

Languages: English (English )

Timezone: America/Los_Angeles (GMT-08:00)

If you go to WPML->Support->Troubleshooting -> can you see the button to "Recreate ST DB cache tables" [screenshot]

if you see it please click it and then check the DB again for the missing table.

If not then i would like to take a closer look if possible

**Before we proceed I recommend to please take FULL BACKUP of your database and your website.**
I often use the Duplicator plugin for this purpose See: http://wordpress.org/plugins/duplicator/

I would like to request temporary access (wp-admin and FTP) to your site to fix the issue.
(preferably to a test site where the problem has been replicated if possible)

You will find the needed fields for this below the comment area when you log in to leave your next reply.
The information you will enter is private which means only you and I can see and have access to it.

Screen Shot 2017-12-13 at 7.29.27 PM.png