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 topic contains 12 replies, has 2 voices.

Last updated by Riffaz 2 months, 2 weeks ago.

Assigned support staff: Riffaz.

Author Posts
August 5, 2019 at 1:17 pm #4340815

vincentD-35

I am trying to: I work on WP dashboard, products, Elementor or WPML

Link to a page where the issue can be seen: only panel WPML but we have also the products that are not in stock should not appear and should give way to the products of stock, but in my shop in French only, I must have 12 products per page but for example I have only 10, there must be some to see 12

I expected to see: no deadlock and no error

Instead, I got: error DB MySLQ for panel admin

LOG
[Mon Aug 5 14:57:29 2019] [error] [pid 22120] mod_proxy_fcgi.c(860): [client 176.62.172.106:16078] AH01071: Got error 'PHP message: WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT IGNORE INTO krve_options ( `option_name`, `option_value`, `autoload` ) VALUES ('wpml.WPML_ST_DB_Cache.lock', '1565009847', 'no') /* LOCK */ made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, Elementor\\Plugin->init, do_action('elementor/init'), WP_Hook->do_action, WP_Hook->apply_filters, owpElementor\\owpElementorPlugin->init_panel_section, esc_html__, translate, apply_filters('gettext'), WP_Hook->apply_filters, icl_sw_filters_gettext, icl_translate, WPML_Register_String_Filter->translate_by_name_and_context, WPML_Displayed_String_Filter->get_translation, WPML_ST_DB_Cache->get_translation, WPML_ST_DB_Translation_Retrieve->get_translation, WPML_ST_DB_Translation_Retrieve->load, WPML\\Utilities\\Lock->create'

last error

[Mon Aug 05 15:09:07.404161 2019] [error] [pid 6805] mod_proxy_fcgi.c(860): [client 176.62.172.106:20788] AH01071: Got error 'PHP message: WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT IGNORE INTO krve_options ( `option_name`, `option_value`, `autoload` ) VALUES ('wpml.WPML_ST_DB_Cache.lock', '1565010544', 'no') /* LOCK */ made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Post_Types::register_taxonomies, register_taxonomy, do_action('registered_taxonomy'), WP_Hook->do_action, WP_Hook->apply_filters, WCML_WC_Strings->translate_attributes_label_in_wp_taxonomies, apply_filters('wpml_translate_single_string'), WP_Hook->apply_filters, wpml_translate_single_string_filter, icl_translate, WPML_Register_String_Filter->translate_by_name_and_context, WPML_Displayed_String_Filter->get_translation, WPML_ST_DB_Cache->get_translation, WPML_ST_DB_Translation_Retrieve->get_translation, WPML_ST_DB_Translation_Retrieve->load, WPML\\Utilities...'

August 6, 2019 at 5:17 am #4344211

Riffaz
Supporter

Languages: English (English )

Timezone: Asia/Colombo (GMT+05:30)

Hi,

Thank you for contacting WPML support.

Take a full backup of your site and database.
Go to WPML > Support > Troubleshooting
click on 'Recreate ST DB Cache tables'
Then check the issue.

Let me know how it goes, please.

Regards,
Riffaz.

August 6, 2019 at 2:51 pm #4348763

vincentD-35

Many thanks for your support

i executed this, and fast finished
my DB has
before +-840MB
after +- 770MB

problems still on the panel admin of wordpress (see picture french)

display symptoms of WooCommerce products are still affected (hide stockouts)

there must be 12 products shown but only 10 of them are on the first frontpage of woocommerce

last log's my IP 213.189.166.204

[Tue Aug 06 14:42:03.287924 2019] [error] [pid 31051] mod_access_compat.c(353): [client 139.162.106.181:49446] AH01797: client denied by server configuration: /data/sites/web/watchpcicom/www/
[Tue Aug 06 14:53:16.566762 2019] [error] [pid 9161] mod_access_compat.c(353): [client 46.248.48.71:37999] AH01797: client denied by server configuration: /data/sites/web/watchpcicom/www/
[Tue Aug 06 15:19:19.212901 2019] [error] [pid 9161] mod_access_compat.c(353): [client 49.234.186.188:36570] AH01797: client denied by server configuration: /data/sites/web/watchpcicom/www/
[Tue Aug 06 15:49:39.973006 2019] [error] [pid 31051] mod_access_compat.c(353): [client 83.171.124.24:39807] AH01797: client denied by server configuration: /data/sites/web/watchpcicom/www/
[Tue Aug 06 16:43:16.862676 2019] [error] [pid 31051] mod_proxy_fcgi.c(860): [client 176.62.172.106:47740] AH01071: Got error 'PHP message: WordPress databasefout Deadlock found when trying to get lock; try restarting transaction bij query INSERT IGNORE INTO krve_options ( `option_name`, `option_value`, `autoload` ) VALUES ('wpml.WPML_ST_DB_Cache.lock', '1565102595', 'no') /* LOCK */ gemaakt door require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Post_Types::register_taxonomies, register_taxonomy, do_action('registered_taxonomy'), WP_Hook->do_action, WP_Hook->apply_filters, WCML_WC_Strings->translate_attributes_label_in_wp_taxonomies, apply_filters('wpml_translate_single_string'), WP_Hook->apply_filters, wpml_translate_single_string_filter, icl_translate, WPML_Register_String_Filter->translate_by_name_and_context, WPML_Displayed_String_Filter->get_translation, WPML_ST_DB_Cache->get_translation, WPML_ST_DB_Translation_Retrieve->get_translation, WPML_ST_DB_Translation_Retrieve->load, WPML\\Utilit...'
[Tue Aug 06 16:43:34.547261 2019] [error] [pid 2568] mod_proxy_fcgi.c(860): [client 213.189.166.204:61336] AH01071: Got error 'PHP message: Erreur de la base de donn\xc3\xa9es WordPress Deadlock found when trying to get lock; try restarting transaction pour la requ\xc3\xaate INSERT IGNORE INTO krve_options ( `option_name`, `option_value`, `autoload` ) VALUES ('wpml.WPML_ST_DB_Cache.lock', '1565102610', 'no') /* LOCK */ faite par require('wp-blog-header.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, XLWCTY_Core->xlwcty_register_classes, do_action('xlwcty_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, XLWCTY_Common::setup_global_options, XLWCTY_Data->setup_options, icl_t, icl_translate, WPML_Register_String_Filter->translate_by_name_and_context, WPML_Displayed_String_Filter->get_translation, WPML_ST_DB_Cache->get_translation, WPML_ST_DB_Translation_Retrieve->get_translation, WPML_ST_DB_Translation_Retrieve->load, WPML\\Utilities\\Lock->create'
[Tue Aug 06 16:43:51.158172 2019] [error] [pid 2568] mod_proxy_fcgi.c(980): (70007)The timeout specified has expired: [client 213.189.166.204:61052] AH01075: Error dispatching request to : (polling)
[Tue Aug 06 16:44:50.071426 2019] [error] [pid 2568] mod_proxy_fcgi.c(860): [client 176.62.172.106:55934] AH01071: Got error 'PHP message: WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT IGNORE INTO krve_options ( `option_name`, `option_value`, `autoload` ) VALUES ('wpml.WPML_ST_DB_Cache.lock', '1565102688', 'no') /* LOCK */ made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, wp_widgets_init, register_widget, WP_Widget_Factory->register, WP_Widget_Recent_Comments->__construct, is_active_widget, wp_get_sidebars_widgets, get_option, apply_filters('option_sidebars_widgets'), WP_Hook->apply_filters, WPML_Admin_Texts->icl_st_translate_admin_string, WPML_Admin_Texts->icl_st_translate_admin_string, WPML_Admin_Texts->icl_st_translate_admin_string, icl_t, icl_translate, WPML_Register_String_Filter->translate_by_name_and_context, WPML_Displayed_String_Filter->get_translation, WPML_ST_DB_Cache->get_translation, WPML_ST_DB_Translation_Retri...'
[Tue Aug 06 16:47:23.541288 2019] [error] [pid 31051] mod_proxy_fcgi.c(860): [client 176.62.172.106:3488] AH01071: Got error 'PHP message: Erreur de la base de donn\xc3\xa9es WordPress Deadlock found when trying to get lock; try restarting transaction pour la requ\xc3\xaate INSERT IGNORE INTO krve_options ( `option_name`, `option_value`, `autoload` ) VALUES ('wpml.WPML_ST_DB_Cache.lock', '1565102843', 'no') /* LOCK */ faite par require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/oceanwp/404.php'), get_footer, locate_template, load_template, require_once('/themes/oceanwp/footer.php'), do_action('ocean_before_footer'), WP_Hook->do_action, WP_Hook->apply_filters, Ocean_Footer_Callout->footer_callout, include('/plugins/ocean-footer-callout/template/footer-callout.php'), do_shortcode, preg_replace_callback, do_shortcode_tag, OceanWP_Library_Shortcode->library_shortcode, Elementor\\Frontend->get_builder_content_for_display, Elementor\\Frontend->get_builder_content, Elementor\\Core\\Base\\Document->print_elements_with_wrapper, Elementor\\Core\\Base\\Document->print_elements, Elementor\\Element_Base->print_elemen...'

August 6, 2019 at 10:47 pm #4350725

vincentD-35

my host has disabled a parameter of the firewall 'wordpress brute force protection', I think no more problem connection error but the display of products still relevant and it's still slow, like the list of wp-admin commands, perhaps I still need to recreate the ST of the DB?

last error log's

[Wed Aug 07 00:57:37.528003 2019] [error] [pid 24210] mod_proxy_fcgi.c(980): (70007)The timeout specified has expired: [client 213.189.166.204:64779] AH01075: Error dispatching request to : (polling)
[Wed Aug 07 00:57:37.528017 2019] [error] [pid 24210] mod_proxy_fcgi.c(980): (70007)The timeout specified has expired: [client 213.189.166.204:64779] AH01075: Error dispatching request to : (polling)
[Wed Aug 07 00:57:37.536931 2019] [error] [pid 24210] mod_proxy_fcgi.c(980): (70007)The timeout specified has expired: [client 213.189.166.204:64779] AH01075: Error dispatching request to : (polling)
[Wed Aug 07 00:57:37.544786 2019] [error] [pid 24210] mod_proxy_fcgi.c(980): (70007)The timeout specified has expired: [client 213.189.166.204:64779] AH01075: Error dispatching request to : (polling)
[Wed Aug 07 00:57:37.550132 2019] [error] [pid 24210] mod_proxy_fcgi.c(980): (70007)The timeout specified has expired: [client 213.189.166.204:64779] AH01075: Error dispatching request to : (polling)

August 7, 2019 at 10:25 am #4353731

Riffaz
Supporter

Languages: English (English )

Timezone: Asia/Colombo (GMT+05:30)

Hi,

This time out error does not come from WPML.
If you disable WPML do you see this error?

Regards,

August 7, 2019 at 10:34 am #4353847

vincentD-35

I have already tried to disable all WPML plugins, I have no more error and I have 12 products per page but it is the products that are duplicated in all languages

with WPML active :

[error] [pid 24412] mod_proxy_fcgi.c(860): [client 212.224.224.40:9145] AH01071: Got error 'PHP message: Erreur de la base de donn\xc3\xa9es WordPress Deadlock found when trying to get lock; try restarting transaction pour la requ\xc3\xaate INSERT IGNORE INTO krve_options ( `option_name`, `option_value`, `autoload` ) VALUES ('wpml.WPML_ST_DB_Cache.lock', '1565166259', 'no') /* LOCK */ faite par 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, wc_sku_generator, WC_SKU_Generator::instance, WC_SKU_Generator->__construct, WC_SKU_Generator->install, WC_SKU_Generator->get_settings, __, translate, apply_filters('gettext'), WP_Hook->apply_filters, icl_sw_filters_gettext, icl_translate, WPML_Register_String_Filter->translate_by_name_and_context, WPML_Displayed_String_Filter->get_translation, WPML_ST_DB_Cache->get_translation, WPML_ST_DB_Translation_Retrieve->get_translation, WPML_ST_DB_Translation_Retrieve->load, WPML\\Utilities\\Lock->createPHP message: Erreur de la base de donn\xc3\xa9es WordPress Deadlock found when trying to get lock; try restarting transaction pour la requ\xc3\xaate INSERT IGNORE INTO krve_options ( `option_name`, `option_value`, `autoload` ) VALUES ('wpml.WPML_ST_DB_Cache.lock', '1565166262', 'no') /* LOCK */ faite par require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, wp_widgets_init, register_widget, WP_Widget_Factory->register, WP_Widget_Recent_Comments->__construct, is_active_widget, wp_get_sidebars_widgets, get_option, apply_filters('option_sidebars_widgets'), WP_Hook->apply_filters, WPML_Admin_Texts->icl_st_translate_admin_string, WPML_Admin_Texts->icl_st_translate_admin_string, WPML_Admin_Texts->icl_st_translate_admin_string, icl_t, icl_translate, WPML_Register_String_Filter->translate_by_name_and_context, WPML_Displayed_String_Filter->get_translation, WPML_ST_DB_Cache->get_translation,...'

August 8, 2019 at 1:00 pm #4363113
vincentD-35

Any news ?

[08-Aug-2019 12:47:24 UTC] PHP Notice: Trying to get property 'ID' of non-object in /data/sites/web/watchpcicom/www/wp-includes/class-wp-query.php on line 3956
[08-Aug-2019 12:47:24 UTC] PHP Notice: Trying to get property 'post_title' of non-object in /data/sites/web/watchpcicom/www/wp-includes/class-wp-query.php on line 3958
[08-Aug-2019 12:47:24 UTC] PHP Notice: Trying to get property 'post_name' of non-object in /data/sites/web/watchpcicom/www/wp-includes/class-wp-query.php on line 3960
[08-Aug-2019 12:51:21 UTC] Erreur de la base de données WordPress Deadlock found when trying to get lock; try restarting transaction pour la requête INSERT IGNORE INTO krve_options ( `option_name`, `option_value`, `autoload` ) VALUES ('wpml.WPML_ST_DB_Cache.lock', '1565268681', 'no') /* LOCK */ faite par require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, wp_widgets_init, register_widget, WP_Widget_Factory->register, WP_Widget_Recent_Comments->__construct, is_active_widget, wp_get_sidebars_widgets, get_option, apply_filters('option_sidebars_widgets'), WP_Hook->apply_filters, WPML_Admin_Texts->icl_st_translate_admin_string, WPML_Admin_Texts->icl_st_translate_admin_string, WPML_Admin_Texts->icl_st_translate_admin_string, icl_t, icl_translate, WPML_Register_String_Filter->translate_by_name_and_context, WPML_Displayed_String_Filter->get_translation, WPML_ST_DB_Cache->get_translation, WPML_ST_DB_Translation_Retrieve->get_translation, WPML_ST_DB_Translation_Retrieve->load, WPML\Utilities\Lock->create
[08-Aug-2019 12:54:48 UTC] PHP Notice: Trying to get property 'ID' of non-object in /data/sites/web/watchpcicom/www/wp-includes/class-wp-query.php on line 3956
[08-Aug-2019 12:54:48 UTC] PHP Notice: Trying to get property 'post_title' of non-object in /data/sites/web/watchpcicom/www/wp-includes/class-wp-query.php on line 3958
[08-Aug-2019 12:54:48 UTC] PHP Notice: Trying to get property 'post_name' of non-object in /data/sites/web/watchpcicom/www/wp-includes/class-wp-query.php on line 3960
[08-Aug-2019 12:54:51 UTC] PHP Notice: get_woocommerce_term_meta est obsolète depuis la version 3.6 ! Utilisez get_term_meta à la place. in /data/sites/web/watchpcicom/www/wp-includes/functions.php on line 4435
[08-Aug-2019 12:56:22 UTC] PHP Notice: Trying to get property 'ID' of non-object in /data/sites/web/watchpcicom/www/wp-includes/class-wp-query.php on line 3956
[08-Aug-2019 12:56:22 UTC] PHP Notice: Trying to get property 'post_title' of non-object in /data/sites/web/watchpcicom/www/wp-includes/class-wp-query.php on line 3958
[08-Aug-2019 12:56:22 UTC] PHP Notice: Trying to get property 'post_name' of non-object in /data/sites/web/watchpcicom/www/wp-includes/class-wp-query.php on line 3960
[08-Aug-2019 12:56:47 UTC] PHP Notice: Trying to get property 'ID' of non-object in /data/sites/web/watchpcicom/www/wp-includes/class-wp-query.php on line 3956
[08-Aug-2019 12:56:47 UTC] PHP Notice: Trying to get property 'post_title' of non-object in /data/sites/web/watchpcicom/www/wp-includes/class-wp-query.php on line 3958
[08-Aug-2019 12:56:47 UTC] PHP Notice: Trying to get property 'post_name' of non-object in /data/sites/web/watchpcicom/www/wp-includes/class-wp-query.php on line 3960
[08-Aug-2019 12:57:16 UTC] PHP Notice: get_woocommerce_term_meta is deprecated since version 3.6! Use get_term_meta instead. in /data/sites/web/watchpcicom/www/wp-includes/functions.php on line 4435
[08-Aug-2019 12:57:34 UTC] PHP Notice: get_woocommerce_term_meta est obsolète depuis la version 3.6 ! Utilisez get_term_meta à la place. in /data/sites/web/watchpcicom/www/wp-includes/functions.php on line 4435
[08-Aug-2019 12:57:55 UTC] PHP Notice: get_woocommerce_term_meta is deprecated since version 3.6! Use get_term_meta instead. in /data/sites/web/watchpcicom/www/wp-includes/functions.php on line 4435

New threads created by Riffaz and linked to this one are listed below:

https://wpml.org/forums/topic/php-notice-trying-to-get-property-id-of-non-object-in/

August 11, 2019 at 6:20 am #4376599

Riffaz
Supporter

Languages: English (English )

Timezone: Asia/Colombo (GMT+05:30)

Hi,

Our developers are looking into this.
Please be patient till we get back to you again.
I am letting know you the status of this.

Regards,

September 5, 2019 at 11:39 pm #4522135

vincentD-35

hello any news ?

September 6, 2019 at 2:11 am #4522453

vincentD-35

help,

when I edit a page, I have the title twice, I have information about my products, and I have content from a block that does not belong to the page and that is in another language, more possible to do the translations correctly

I have done the TC recreation, fix everything that can be seen in the troubleshooting, uninstall and reinstall WPML, nothing makes it

September 6, 2019 at 5:05 am #4523335

Riffaz
Supporter

Languages: English (English )

Timezone: Asia/Colombo (GMT+05:30)

Hi,

I just noticed you do not have the database deadlock error anymore, right?
Now you have only this when you enable the wpml : https://wpml.org/forums/topic/wordpress-database-error-deadlock-found-when-trying-to-get-lock-2/#post-4363113 , right?

Please follow https://wpml.org/forums/topic/php-notice-trying-to-get-property-id-of-non-object-in/

Regarding your other issue https://wpml.org/forums/topic/wordpress-database-error-deadlock-found-when-trying-to-get-lock-2/#post-4522453 please create a new ticket. You will get faster reply as I am off today and next two days.
And, this is a new issue which has nothing to do with your other issues.

I am off for next three days but I was handling your error related tickets and details. So I will check the error ticket for better understanding.

Regards,

September 6, 2019 at 10:14 am #4524717

vincentD-35

okay, I will create another ticket

September 8, 2019 at 2:15 pm #4531819

Riffaz
Supporter

Languages: English (English )

Timezone: Asia/Colombo (GMT+05:30)

Hi,

Thank you.
I am updating the status.

Regards,