This thread is resolved. Here is a description of the problem and solution.
Problem: You are trying to access the Translation Management Dashboard to manage translations for various post types, but the page is continuously loading with an error message stating 'MariaDB can only access 61 joint tables'. Solution: This issue is likely related to a known problem with WPML where too many database tables are being accessed simultaneously. We recommend checking the WPML errata page for this specific issue at https://wpml.org/errata/errata-wpml-4-7-1-wordpress-database-error-too-many-tables/. Please ensure that you have updated to the latest version of WPML, as version 4.7.2 addresses this issue. If the problem persists after updating, or if this solution does not apply to your case because it might be outdated, 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 you need further assistance, 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.
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.
Manage Cookie Consent
We use cookies to optimize our website and services. Your consent allows us to process data such as browsing behavior. Not consenting may affect some features.
Functional
Always active
Required for our website to operate and communicate correctly.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
We use these to analyze the statistics of our site. Collected information is completely anonymous.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
These cookies track your browsing to provide ads relevant to you.