[Waiting for user confirmation] Cannot access Translation Dashboard
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.
Background of the issue:
I am trying to access the Translation Management Dashboard to see all the types of posts (Products, Posts, etc) that I can translate. Here is the link to the page where the issue can be seen: hidden link
Symptoms:
I got a constantly loading page with the error message: 'MariaDB can only access 61 joint tables'.
Questions:
Why is the Translation Management Dashboard not loading?
How can I resolve the 'MariaDB can only access 61 joint tables' error?
While one of my teammates handles your ticket, I will provide you with initial debugging steps.
Please update your WPML plugin and add-ons to the latest version, 4.7.2, to benefit from the latest bug fixes and improvements. This may not necessarily resolve your problem; however, we need to work on the newest code available to troubleshoot the issue best.
You can check the latest released versions under "My Account -> Downloads" on this site. Instructions to update can be found here: http://wpml.org/faq/install-wpml/
If you do not see the updates, you might need to click the Check for updates button in the Plugins → Add New Plugin → Commercial tab.
Please remember to backup your database before you proceed.
Let us know if the issue persists after an update has been done.
Could you please test if the user role does not have the capabilities to access the Translation Management page? To so please try to follow the below steps:
1. Take a backup of your site first.
2. Add the below code in functions.php file:
function add_wpml_manage_translations_cap() {
$role = get_role('administrator');
if ($role) {
$role->add_cap('manage_translations');
}
}
add_action('init', 'add_wpml_manage_translations_cap');
3. Visit the frontend once so that it will trigger this code.
4. Please reload the backend and see if the issue is solved.
5. Now, you can remove the code which is added in step #2.
However, the latest version, 4.7.2, should already resolve it. Therefore, there is no need to use the code I shared before. Please make sure to perform the updates.
I need to request temporary access (wp-admin and FTP) to your site—preferably to a test site where the problem has been replicated if possible—in order to be of better help. When you log in to leave your next reply, you will find the needed fields below the comment area. The information you will enter is private, meaning only you and I can see and access it.
I have reviewed the site, but I cannot identify the obvious cause of the issue. There is a 500 error present, and I'm not sure if it is related to the error you mentioned.
Could you please install the Adminer plugin to check your database?
If I need to debug the problem further, I would like to ask if you could replicate your site locally. I will need to temporarily install either the "Duplicator" or "All In One Migration" plugin on your site. This will allow me to create a copy of your site and its content. If you prefer to handle this independently, you can create a snapshot and send me the zipped package you downloaded.
I have marked the following message as private; please also include the FTP details.
