Issue removing language from database

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.

Tagged: Exception

This topic contains 13 replies, has 2 voices.

Last updated by Andrey 1 year, 7 months ago.

Assisted by: Andrey.

Author	Posts
October 23, 2023 at 3:40 pm #14640013
billT	Hello I'm trying to remove a language from my site and the database using this article https://wpml.org/documentation/getting-started-guide/language-setup/deleting-languages-and-plugin-data-by-doing-a-wpml-reset-on-your-site/. I'm having an issue in Step 1. When I click on the delete all data it seems to spin for a while but then it looks like nothing has changed. I have tried this for different languages with different sizes but they all do the same thing. Any suggestions on this would be appreciated. Thanks, Erik
October 23, 2023 at 9:17 pm #14641457
Andrey WPML Supporter since 06/2013 Languages: English (English ) Russian (Русский ) Timezone: Europe/Kyiv (GMT+03:00)	Thank you for contacting WPML support. Have you tried temporarily deactivating all plugins except WPML and attempting Step 1 again? Before proceeding with any updates, please remember to back up your database.
October 24, 2023 at 4:10 pm #14649575
billT	This didn't seem to help at all. I'm not sure if it's because of the size of the site. For example see the number of resources in the image below. This is one of our small sites but it has a lot of media files associated.
October 24, 2023 at 7:47 pm #14650647
Andrey WPML Supporter since 06/2013 Languages: English (English ) Russian (Русский ) Timezone: Europe/Kyiv (GMT+03:00)	Could you please activate the debug.log and see if there is anything there at the moment the process is stuck? You can do this by adding a few lines to the site’s wp-config.php file. With error log enabled, you will see what the actual problem is. To enable it, open your wp-config.php file and look for define(‘WP_DEBUG’, false);. Change it to: define('WP_DEBUG', true); In order to enable the error logging to a file on the server you need to add yet one more similar line: define( 'WP_DEBUG_LOG', true ); In this case, the errors will be saved to a debug.log log file inside the /wp-content/directory. https://wpml.org/documentation/support/debugging-wpml/
October 25, 2023 at 5:54 pm #14663967
billT	Here is the contents of the debug.log file when I tried to do the deletion of a language. There didn't seem to be anything different that went into the log when I clicked the delete button. Sorry I'm not sure how to add it into a preformatted code block. [25-Oct-2023 17:46:08 UTC] PHP Deprecated: mysqli_real_connect(): Passing null to parameter #5 ($database) of type ?string is deprecated in /nas/content/live/d2lweglotstg/wp-includes/class-wpdb.php on line 2035 [25-Oct-2023 17:46:08 UTC] PHP Deprecated: mysqli_real_connect(): Passing null to parameter #7 ($socket) of type ?string is deprecated in /nas/content/live/d2lweglotstg/wp-includes/class-wpdb.php on line 2035 [25-Oct-2023 17:46:11 UTC] PHP Deprecated: mysqli_real_connect(): Passing null to parameter #5 ($database) of type ?string is deprecated in /nas/content/live/d2lweglotstg/wp-includes/class-wpdb.php on line 2035 [25-Oct-2023 17:46:11 UTC] PHP Deprecated: mysqli_real_connect(): Passing null to parameter #7 ($socket) of type ?string is deprecated in /nas/content/live/d2lweglotstg/wp-includes/class-wpdb.php on line 2035 [25-Oct-2023 17:46:12 UTC] PHP Deprecated: mysqli_real_connect(): Passing null to parameter #5 ($database) of type ?string is deprecated in /nas/content/live/d2lweglotstg/wp-includes/class-wpdb.php on line 2035 [25-Oct-2023 17:46:12 UTC] PHP Deprecated: mysqli_real_connect(): Passing null to parameter #7 ($socket) of type ?string is deprecated in /nas/content/live/d2lweglotstg/wp-includes/class-wpdb.php on line 2035 [25-Oct-2023 17:46:12 UTC] PHP Deprecated: Creation of dynamic property Whip_RequirementsChecker::$configuration is deprecated in /nas/content/live/d2lweglotstg/wp-content/plugins/sitepress-multilingual-cms/vendor/yoast/whip/src/Whip_RequirementsChecker.php on line 37 [25-Oct-2023 17:46:12 UTC] PHP Deprecated: Creation of dynamic property Whip_RequirementsChecker::$messageManager is deprecated in /nas/content/live/d2lweglotstg/wp-content/plugins/sitepress-multilingual-cms/vendor/yoast/whip/src/Whip_RequirementsChecker.php on line 38 [25-Oct-2023 17:46:40 UTC] PHP Deprecated: mysqli_real_connect(): Passing null to parameter #5 ($database) of type ?string is deprecated in /nas/content/live/d2lweglotstg/wp-includes/class-wpdb.php on line 2035 [25-Oct-2023 17:46:40 UTC] PHP Deprecated: mysqli_real_connect(): Passing null to parameter #7 ($socket) of type ?string is deprecated in /nas/content/live/d2lweglotstg/wp-includes/class-wpdb.php on line 2035 [25-Oct-2023 17:47:07 UTC] PHP Deprecated: mysqli_real_connect(): Passing null to parameter #5 ($database) of type ?string is deprecated in /nas/content/live/d2lweglotstg/wp-includes/class-wpdb.php on line 2035 [25-Oct-2023 17:47:07 UTC] PHP Deprecated: mysqli_real_connect(): Passing null to parameter #7 ($socket) of type ?string is deprecated in /nas/content/live/d2lweglotstg/wp-includes/class-wpdb.php on line 2035 [25-Oct-2023 17:47:12 UTC] PHP Deprecated: mysqli_real_connect(): Passing null to parameter #5 ($database) of type ?string is deprecated in /nas/content/live/d2lweglotstg/wp-includes/class-wpdb.php on line 2035 [25-Oct-2023 17:47:12 UTC] PHP Deprecated: mysqli_real_connect(): Passing null to parameter #7 ($socket) of type ?string is deprecated in /nas/content/live/d2lweglotstg/wp-includes/class-wpdb.php on line 2035 [25-Oct-2023 17:47:41 UTC] PHP Deprecated: mysqli_real_connect(): Passing null to parameter #5 ($database) of type ?string is deprecated in /nas/content/live/d2lweglotstg/wp-includes/class-wpdb.php on line 2035 [25-Oct-2023 17:47:41 UTC] PHP Deprecated: mysqli_real_connect(): Passing null to parameter #7 ($socket) of type ?string is deprecated in /nas/content/live/d2lweglotstg/wp-includes/class-wpdb.php on line 2035 [25-Oct-2023 17:48:12 UTC] PHP Deprecated: mysqli_real_connect(): Passing null to parameter #5 ($database) of type ?string is deprecated in /nas/content/live/d2lweglotstg/wp-includes/class-wpdb.php on line 2035 [25-Oct-2023 17:48:12 UTC] PHP Deprecated: mysqli_real_connect(): Passing null to parameter #7 ($socket) of type ?string is deprecated in /nas/content/live/d2lweglotstg/wp-includes/class-wpdb.php on line 2035
October 25, 2023 at 9:14 pm #14664771
Andrey WPML Supporter since 06/2013 Languages: English (English ) Russian (Русский ) Timezone: Europe/Kyiv (GMT+03:00)	Thank you for sharing this information. There seem to be no fatal errors. 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. 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.
October 26, 2023 at 9:51 pm #14674571
Andrey WPML Supporter since 06/2013 Languages: English (English ) Russian (Русский ) Timezone: Europe/Kyiv (GMT+03:00)	Thank you. I will check and let you know as soon as I know more.
October 27, 2023 at 8:49 am #14676531
Andrey WPML Supporter since 06/2013 Languages: English (English ) Russian (Русский ) Timezone: Europe/Kyiv (GMT+03:00)	I noticed that there is a 502 Bad Gateway error during this process. Have you tried with any default theme? What are the results?
October 27, 2023 at 4:13 pm #14681335
billT	I haven't tried yet with a default theme, our custom post types are defined in our theme so I wasn't sure if I change it if the process would miss removing those custom posts from the DB. During this process when you got the 502 did it change the page and present the error or did you see it in a log somewhere? I haven't seen this behavior when I have tried the deletion.
October 30, 2023 at 2:34 pm #14692887
billT	I tried with a default theme but the delete seems like it is still not doing anything.
October 30, 2023 at 8:36 pm #14695013
Andrey WPML Supporter since 06/2013 Languages: English (English ) Russian (Русский ) Timezone: Europe/Kyiv (GMT+03:00)	I see the 502 Bad Gateway in the browser console when the process is stuck. I want to ask you about the possibility of replicating your site locally. For this, I'll need to install a "Duplicator" plugin on your site temporarily. This will allow me to create a copy of your site and your content. If you prefer to do it independently, you can provide me with the snapshot and send me the installer file and the zipped package you downloaded. Let me know how you feel about this.
October 31, 2023 at 2:07 pm #14700763
billT	Yes, you can do that.
November 1, 2023 at 7:36 pm #14710641
Andrey WPML Supporter since 06/2013 Languages: English (English ) Russian (Русский ) Timezone: Europe/Kyiv (GMT+03:00)	I have replicated your website on my local computer and successfully ran the option without any issues. The data was deleted within a few minutes of testing it with your theme. However, your site encountered a 502 Bad Gateway error during the process, and I don't have a clear understanding of why it's happening. To attempt to resolve this issue, I suggest disabling any cache on the server and increasing the WP memory limit. I would also suggest that you consult your host regarding the issue.
November 1, 2023 at 7:41 pm #14710759
Andrey WPML Supporter since 06/2013 Languages: English (English ) Russian (Русский ) Timezone: Europe/Kyiv (GMT+03:00)	I was able to complete the process on your website. It's likely that the server halted the process after reaching its limits. I clicked the button "Delete Dutch content from database" several times when it stopped. There are a few remaining items that should be removed manually.
November 2, 2023 at 5:22 pm #14720053
billT	Thanks I will check with WPEngine.