Please make sure to update to WPML 4.3.4 before reporting any issue

Hi, Amit here, I am the WPML Support Manager, our current ticket queue is high, update your WPML plugins and make sure you meet the minimal requirements for running WPML before reporting an issue please - many tickets are resolved doing that

Please look at our updated list of Known Issues and you can also use our support search to find helpful information and of course review our documentation before opening a ticket.

If you do need to open a ticket please make sure to provide us with all the needed information as described in this page

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 thread is resolved. Here is a description of the problem and solution.

Problem:
Cannot activate WPML and I am getting this error:

WPML is missing some records in the languages tables and it cannot fully work until this issue is fixed.

Please go to the Troubleshooting page and click on "Clear language information and repopulate languages" to fix this problem.

Solution:
Solution here: https://wpml.org/forums/topic/error-activating-wpml-multilingual-cms/#post-4030653

0% of people find this useful.

This topic contains 6 replies, has 2 voices.

Last updated by daneelM 4 months, 4 weeks ago.

Assigned support staff: Noman.

Author Posts
June 11, 2019 at 10:48 am #3994301

daneelM

Hello!
I am having a bit of bother activating WPML. I had it installed previously but decided to delete it and work on the translation later. I am now trying to set it up, however, I am worried that I may have messed something up initially and is causing trouble now.

I am getting the error:

WPML is missing some records in the languages tables and it cannot fully work until this issue is fixed.

Please go to the Troubleshooting page and click on "Clear language information and repopulate languages" to fix this problem.

Firstly, I kept getting "cannot access this page" and used the solution here (https://wpml.org/forums/topic/wpml-sorry-you-are-not-allowed-to-access-this-page/) by adding this code snippet:

function wpmlsupp_1706_reset_wpml_capabilities() {
    if ( function_exists( 'icl_enable_capabilities' ) ) {
        icl_enable_capabilities();
    }
}
add_action( 'shutdown', 'wpmlsupp_1706_reset_wpml_capabilities' );

This got me through, and I used the "Clear language information and repopulate languages"
After trying this, it didn't seem to resolve anything (the error still appears at the top) and now the option does not appear in the Troubleshooting page. (Screenshot attached)

I then proceeded to use this solution (https://wpml.org/forums/topic/cannot-install-icl_languages-doesnt-exist-for-query/) and deleted the icl_sitepress_settings.
This started the WPML setup again but did not resolve the issue.

I have also tried the "reset" option and that doesn't solve the issue either.

And, have also tried Reset PRO translation configuration found here (https://wpml.org/forums/topic/how-to-reset-the-wpml-plugin/).

I noticed errors coming up on the frontend (Screenshot attached) and used the solution here (https://wpml.org/forums/topic/warning-illegal-offset-type-in-isset-or-empty-in-6/) by removing warnings.

Pretty much everything is a mess. Is there a way I can completely delete everything and start anew?

Any help or information would be much appreciated and don’t hesitate if you need more information.

Thanks,

Daneel

June 11, 2019 at 11:02 am #3994429

Noman
Supporter

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

Hi,

Thank you for contacting WPML Support.

1. I have noticed that your website’s WP Memory Limit is 40MB. The WP memory limit needs to be increased, it's different than php memory. PHP memory is fine but WordPress uses 40Mb as default in your site. Minimum requirements for WPML are 128Mb: https://wpml.org/home/minimum-requirements/

Please add this to the top of wp-config.php to increase WP memory:

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

=== Please backup your database and website ===

2. Please upgrade your server’s MySQL version to a higher level: https://wpml.org/home/minimum-requirements/
MySQL 5.5.5 version in your site, is lower than the required for WPML.

3. You are using an older version of WordPress on your site, please backup your site and update WordPress to it’s latest version 5.2.1.

4. If you have just installed plugin and configuring WPML first time on this site and do not have any translated data yet then you can fix this issue by removing WPML and all its data completely from database, To do so, please go to WPML >> Support >> Troubleshooting (the link is at the bottom of the support page). >> There, click on “Reset and deactivate WPML” >> then Delete the plugin.

- After deleting all WPML data and WPML related plugins then please install WPML plugins again and I hope now you will not face any issue.

This issue usually happens due to some corruption in the database, if you are installing WPML first time in this site and you see some database tables starting with <srtong>icl_</srtong> even after reset, please also delete those tables and try reinstalling WPML.

Here is doc for more details:
https://wpml.org/faq/how-wpml-reset-works/

5. Please delete all sort of caches on your site / server cache / plugin cache (WP Super Cache) / CDN cache (if any), clear browser cache and then check the page. I would suggest to disable WP Super Cache plugin temporary.

6. If still issue persists, please check for a possible theme and plugin conflict. To do that you can switch back to any default theme (e.g. Twenty Seventeen theme), Disable all plugins except WPML and see if this issue goes away with default theme and only WPML activated?

Thank you

June 12, 2019 at 12:34 pm #4004279

daneelM

Hello!

Thanks for the response.

I have carried out the steps:

- Increased memory limit
- My hosting is currently running 10.3.15-MariaDB (cannot change due to being on shared server)
- Upgraded WP
- Deactivated cache
- I "reset and deactivated" and deleted WPML and all related plugins.

However, I am still getting the same issue.

Upon re-uploading, installing and activating CMS I am presented with the same error. (screenshot attached). Upon "clear language and repopulate languages" it notifies as "done" however, the error persists.

Upon configuring WPML I noticed there are no flag icons for language selection and did not register any menus (for switcher). Carrying onward, it changed the homepage to the 404 page, the menu was broken and all my "pages" were non-existent. (screenshot attached)

I have reset, deactivated and deleted again and the site is back to normal.

I am using Oxygen therefore do not have a theme installed and have had WPML and all its components previously installed correctly on this before.

Any help would be greatly appreciated.

Thanks,

Daneel

June 12, 2019 at 4:03 pm #4005971

Noman
Supporter

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

Hi,

To further debug this issue, please provide temporary access (WP-Admin and FTP Login info) to your site (preferably staging site), so that I can look into your setup and debug the issue.

Your next answer will be private which means only you and I have access to it.

=== Please backup your database and website ===

✙ I would additionally need your permission to de-activate and re-activate Plugins and the Theme, and to change configurations on the site. This is also a reason the backup is really important.

Thank you

June 16, 2019 at 1:07 pm #4030529

Noman
Supporter

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

Hi,

Thanks for login details. My off days are Friday and Saturday and now I am available and working on this issue and will update you with findings soon.

Thank you

June 16, 2019 at 2:21 pm #4030653

Noman
Supporter

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

Hi,

I have followed the below steps in order to fix this issue.
- Enabled error reporting in your site by adding below code in wp-config.php file:

 // Enable WP_DEBUG mode
define( 'WP_DEBUG', true );

// Enable Debug logging to the /wp-content/debug.log file
define( 'WP_DEBUG_LOG', true );

// Disable display of errors and warnings 
define( 'WP_DEBUG_DISPLAY', false );
@ini_set( 'display_errors', 0 );

// Use dev versions of core JS and CSS files (only needed if you are modifying these core files)
define( 'SCRIPT_DEBUG', true );

- Went to WPML >> Support >> Troubleshooting (the link is at the bottom of the support page). >> There, clicked on “Reset and deactivate WPML” >> then Deleted the plugin.

- Activated WP default theme e.g. twentyseventeen.

- Then deactivated all plugins and installed/activated WPML plugins and finished configuration steps. I temporarily selected "English" as default and "French" as the secondary language to get this going for you. This can be changed by going to WPML >> Languages >> Site Languages. There are two buttons: "Change default language" and "Add/Remove languages".

- Then activated previous activated theme and plugins.

Now WPML working fine, could you please check and confirm?

Thank you

June 25, 2019 at 9:20 am #4082651

daneelM

My issue is resolved now. Thank you!