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.
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| 10:00 – 14:00 | 10:00 – 14:00 | 10:00 – 14:00 | 10:00 – 14:00 | 10:00 – 14:00 | - | - |
| 16:00 – 20:00 | 16:00 – 20:00 | 16:00 – 20:00 | 16:00 – 20:00 | 16:00 – 20:00 | - | - |
Supporter timezone: Asia/Jerusalem (GMT+03:00)
This topic contains 19 replies, has 4 voices.
Last updated by 2 years, 2 months ago.
Assisted by: Itamar.
 |
I have a store with ~4k woocommerce products, ukrainian and russian languages. Page before starting loading it can take up to 20s and sometimes ends in 503 error. When I disable wpml plugin then it loads fast, without 503 or any other problems. I have wp rocket pro, without it Initial response from server was 15s, now 4s. But I assume google pagespeed tracks only when page starts loading, and my pages starts loading after 10-20s. I also used wmpl troubleshooting page, it didn't help.  |
 WPML Supporter since 02/2018 Languages: English (English ) Spanish (Español ) Italian (Italiano ) Timezone: Europe/Rome (GMT+02:00) |
|
|
|
Here is doc with slow requests by query monitor for one page. It is max what I have seen (38). But even when it shows 4-5 slow request time before page starts loading may take 10s: hidden link debug.log has only one line:  |
|
|
Updated debug.log: Also I disabled Query monitor, but as I know it impacts only for logged-in users, and my website struggles for everyone. And today I see, I got too often 503, I am also not able to use wp all import.  |
 Supporter Timezone: Africa/Cairo (GMT+03:00) |
|
|
Supporter Timezone: Africa/Cairo (GMT+03:00) |
Hi Igor, Thank you for providing the login credentials. My findings so far: 1. There was an error PHP Fatal error: Uncaught InvalidArgumentException: element_id and type do not match for element_id:47960 the database contains post_product while this function was called with post_product_variation That I fixed according to the following errata page: https://wpml.org/errata/fatal-error-invalidargumentexception-element_id-and-type-do-not-match/ 2. WPML troubleshooting options have noticeably improved performance, as shown in the attached screenshots. 3. I have found duplicate database queries on all admin pages called by "WPML_Installation->refresh_active_lang_cache()". I have forwarded the matter of the duplicated queries to our second-tier support team and will inform you as soon as I receive an update from them.    |
|
|
Thanks. I am cleaning database, there were 1milliton rows in postmeta, now 250k, but speed the same, also I deleted 18000 orders. Now I want make some attributes not traslatable, if I uncheck this box, rows from icl_translate table automatically removed ? I have ~1900 terms in this taxonomy attribute.  |
|
Supporter Timezone: Africa/Cairo (GMT+03:00) |
|
|
|
Hi, thanks for support, but seems nothing changed. I tried update only prices for products and got 503. And walking through website sometimes leads to 503 also.  |
|
Supporter Timezone: Africa/Cairo (GMT+03:00) |
|
|
Supporter Timezone: Africa/Cairo (GMT+03:00) |
|
|
|
Hi, I don't want check without wpml, then I would need to restore db. My import is id=41, you can test it, it just simple, saves only 2 custom fields, and then I run code:
add_action( 'pmxi_saved_post', 'allmac_wp_import_products', 10, 3 );
function allmac_wp_import_products( $id, $xml, $update ) {
$import_id = ( isset( $_GET['id'] ) ? $_GET['id'] : ( isset( $_GET['import_id'] ) ? $_GET['import_id'] : 'new' ) );
if ( $import_id == 41 ) {
// import prices.
$product_trans_price = get_post_meta( $id, 'product_trans_reg_price', true );
$product_trans_sale_price = get_post_meta( $id, 'product_trans_sale_price', true );
$product_sku = get_post_meta( $id, '_sku', true );
global $wpdb;
$post_language_details = apply_filters( 'wpml_post_language_details', null, $id );
if ( $post_language_details['language_code'] === 'uk' ) {
$language_code = 'ru';
$query = "
SELECT p.ID
FROM {$wpdb->posts} AS p
INNER JOIN {$wpdb->prefix}icl_translations AS t
ON p.ID = t.element_id
INNER JOIN {$wpdb->postmeta} AS pm
ON p.ID = pm.post_id
WHERE p.post_type = 'product'
AND p.post_status = 'publish'
AND t.language_code = %s
AND pm.meta_key = '_sku'
AND pm.meta_value = %s
";
$prepared_query = $wpdb->prepare( $query, $language_code, $product_sku );
$results = $wpdb->get_row( $prepared_query, ARRAY_A );
if ( ! empty( $results ) ) {
$found_product_id = absint( $results['ID'] );
update_post_meta( $found_product_id, '_regular_price', $product_trans_price );
update_post_meta( $found_product_id, '_sale_price', $product_trans_sale_price );
$price = $product_trans_sale_price ? $product_trans_sale_price : $product_trans_price;
update_post_meta( $found_product_id, '_price', $price );
// update current lang product (uk).
update_post_meta( $id, '_regular_price', $product_trans_price );
update_post_meta( $id, '_sale_price', $product_trans_sale_price );
update_post_meta( $id, '_price', $price );
}
}
delete_post_meta( $id, 'product_trans_reg_price' );
delete_post_meta( $id, 'product_trans_sale_price' );
return;
}
}
That's because my default language is Ukrainian, but default language for products is russian, my import file is for ukrainian products.   |
 WPML Supporter since 02/2016 Languages: English (English ) Timezone: Asia/Jerusalem (GMT+03:00) |
|
|
WPML Supporter since 02/2016 Languages: English (English ) Timezone: Asia/Jerusalem (GMT+03:00) |
|
|
|
Hi, thanks. I have started rebuild whole site on test site, and it works ok, but I had to make some hacks to avoid registering wpml on test site, and now I got error on plugin page. When I migrate from test site to production site is there way to enter license key, because now I cant find it, it was only on wizard install step. I also then bring wp.options table from production site to test site and it still doesn't work. Where is license key stored or how I can solve this problem?  |
