I am trying to: I want to use WPML but as soon as I activate the plugin I am getting database error - Deadlock error stated below.
Error - WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT IGNORE INTO wpvj_icl_translations (`element_type`, `element_id`, `trid`, `language_code`)
SELECT CONCAT('post_' , p.post_type) as element_type, p.ID as element_id, 1409827657 + p.ID as trid, 'en' as language_code
FROM wpvj_posts p
LEFT OUTER JOIN wpvj_icl_translations t
ON t.element_id = p.ID AND t.element_type = CONCAT('post_', p.post_type)
WHERE p.post_type = 'attachment' AND t.translation_id IS NULL
LIMIT 500 made by require('_controller_v3_/core/controller.php'), require('wp-admin/index.php'), require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->init, do_action('wpml_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Upgrade_Loader->wpml_upgrade, WPML_Upgrade->run, WPML_Upgrade->run_admin, WPML_Upgrade->run_commands, WPML_Upgrade->run_command, WPML_Upgrade->maybe_run_admin, WPML_Upgrade_Run_All->run_admin, WPML_Upgrade_Media_Without_Language->run, WPML_Initialize_Language_For_Post_Type->run
Link to a page where the issue can be seen: As soon as you turn on WPML from plugins page
I expected to see: WPML gets activated withthout any issues
Instead, I got: PHP database error and plugin not activating
Hello There,
Thanks for reaching out to WPML Support. I will try my best to assist you in this matter.
First of all, I'm very sorry for the unusual experience. The Deadlock error happens mostly after migrating the site from a local environment to the production environment.
In order to solve the issue, Please create a full website backup and then-
- Download the latest version of WPML from https://wpml.org/account/downloads/;
- Disable and delete WPML Multilingual CMS from your site;
- Upload the freshly downloaded WPML plugin from Plugins → Add New → Upload Plugin and activate the plugin with license;
Please do the same for the "WPML String Translation" plugin, too.
I hope it will help. Let me know if further assistance is required in this case. I will be happy to assist you.
Hi, I deleted WPML and string translation and then added the lastest WPML again. But the issue still persists - as soon as I activate WPML - Its loads for 4-5 minutes and the fails and php logs shows deadlock error.
Also, this started to happen after I performed a full WPML reset from support -> troubleshooting -> reset and deactivate WPML.
Let me know, what should I do next to solve the issue asap.
Also, one more thing - wpml is disabled and still there are a lot of duplicate categories for post shows up - those categories were made before reset by taxanomy translation and now all of the categories are showing up.
Please help and get the issue resolved asap.
New threads created by Prosenjit Barman and linked to this one are listed below:
Hello There,
I hope this message finds you well. I'm very sorry for the delay in getting back to you.
As the issue with Deadlock didn't get solved even after reinstalling the WPML plugin, then a closer inspection of your site is required. I would like to request temporary access (wp-admin and FTP) to your site to take a better look at the issue. It would be better to have a testing site where the issue is replicated.
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.
Maybe I'll need to replicate your site locally. For this, I’ll need to temporarily install a plugin called “Duplicator” or "All in One WP Migration" on your site. This will allow me to create a copy of your site and your content. Once the problem is resolved I will delete the local site. Let me know if this is ok with you.
IMPORTANT
-Please make a backup of site files and database before providing us access.
-If you do not see the wp-admin/FTP fields this means your post & website login details will be made PUBLIC. DO NOT post your website details unless you see the required wp-admin/FTP fields. If you do not, please ask me to enable the private box. The private box looks like this: hidden link
Please note that to maintain clarity and organization, it is important to keep discussions focused on one issue per thread. For that reason, the query about duplicate categories has been split into another thread. A response will be sent to that query very soon.
Hello There,
I hope you're doing fine. Thanks for sharing the credentials.
I'm happy to inform you that the WPML Plugin on your site is now activated and the Deadlock error is no longer appearing.
While trying to activate the WPML plugin by keeping other plugins activate, I encounter an error from Cloudflare after a few minutes. Once I tried to activate the WPML plugin by keeping other plugins deactivated on your site, I found the Deadlock error(hidden link).
As the first step of resolving the Deadlock error, I cleared the WPML cache by visiting the "WPML > Support > Troubleshooting" page. This action resulted in the immediate disappearance of the Deadlock error. However, while activating the plugins one at a time, I observed that previously activated plugins were now showing as deactivated, and the Deadlock error was once again visible on the site. This type of issue usually arises due to caching.
I noticed that the "CDN-Cache" was added to your site as a must-use plugin, and I suspected that it might be causing the issue. Once I disabled the plugin from the file, everything began to display correctly. As a result, no error notices were visible on the dashboard, all plugins were activated properly. Also, I haven't found any signs of the WPML in the debug log.
It's possible that the caching plugin cached a SQL query related to the WordPress Posts and attempted to execute it while activating WPML.
However, Please check now and let me know if you can access the features of WPML. I also have kept the Debug mode enabled so that you can verify if any deadlock error is appearing or not. As the caching plugin is a must-use plugin, it got activated after some time but be assured that it is not showing any error on the site.
If you need further assistance in this matter, please let me. I will be happy to assist you.
