 frankC-20
|
I can give you the links to the installer and the archive file, but the reply fields is not private!!
Frank
|
 Andrey
WPML Supporter since 06/2013
Languages:
English (English )
Russian (Русский )
Timezone:
Europe/Kyiv (GMT+03:00)
|
Let me activate the private fields again.
|
 Andrey
WPML Supporter since 06/2013
Languages:
English (English )
Russian (Русский )
Timezone:
Europe/Kyiv (GMT+03:00)
|
Thank you for the provided details. We'll check, and I'll let you know as soon as I know more.
|
 Andrey
WPML Supporter since 06/2013
Languages:
English (English )
Russian (Русский )
Timezone:
Europe/Kyiv (GMT+03:00)
|
I appreciate your patience. We have tested your case and escalated it to our development team.
As a temporary workaround, we made the following changes on your staging site in /wp-content/plugins/woocommerce-multilingual/inc/translation-editor/class-wcml-synchronize-variations-data.php in line 219, the following function:
public function get_variation_id_by_lang( $lang, $original_variation_id ) {
return $this->wpdb->get_var(
$this->wpdb->prepare(
"SELECT post_id FROM {$this->wpdb->postmeta} AS pm
JOIN {$this->wpdb->prefix}icl_translations AS tr ON tr.element_id = pm.post_id
WHERE tr.element_type = 'post_product_variation'
AND tr.language_code = %s
AND pm.meta_key = '_wcml_duplicate_of_variation'
AND pm.meta_value = %d",
$lang,
$original_variation_id
)
);
}
is changed to
public function get_variation_id_by_lang( $lang, $original_variation_id ) {
return apply_filters( 'wpml_object_id', $original_variation_id, 'product_variation', false, $lang );
}
Could you increase the PHP memory limit, Max input vars, and Max execution time on your staging server and then try to update your product?
|
 frankC-20
|
Hi there, thank you. Below you'll see the server values indicated under Tools -> Site health / Info. Looking at the values, I'd say that PHP memory limit etc. are suffiencient. I tried to update the product Abiturzeugnis, but again I got an 504 Gateway Time-out. So why do you think that replacing that one function would solve the problem? BTW: When I run "Synchronize attributes and update product variations", the process is never completed and loops forever (I had it running over night ...). Please advise, Frank
Server architecture Linux 4.19.0-17-amd64 x86_64
Web server Apache
PHP version 7.4.33 (Supports 64bit values)
PHP SAPI cgi-fcgi
PHP max input variables 4000
PHP time limit 180
PHP memory limit 1024M
PHP memory limit (only for admin screens) 512M
Max input time 60
Upload ize 256M
PHP post 256M
cURL version 7.64.0 OpenSSL/1.1.1n
Is SUHOSIN installed? No
Is the Imagick library available? Yes
Are pretty permalinks supported? Yes
|
 Andrey
WPML Supporter since 06/2013
Languages:
English (English )
Russian (Русский )
Timezone:
Europe/Kyiv (GMT+03:00)
|
Your product has a large number of variations, totaling to 1440, which causes a delay in the time it takes to save. Even without WPML, it takes a considerable amount of time to save, thus by replacing the existing function, the time to save has been reduced to approximately 1.5 minutes in the local environment. However, the value of the maximum execution time exceeds the limit, which causes the saving\updating process to stop.
|
 frankC-20
|
When I deactivate "WPML Multilingual CMS", updating works like a charm in a few seconds. So please present a solution. Thx, Frank
|
 Andrey
WPML Supporter since 06/2013
Languages:
English (English )
Russian (Русский )
Timezone:
Europe/Kyiv (GMT+03:00)
|
I just retested and see that it saves in several seconds with all WPML plugins enabled. I have tested with product ID 7499 (the product that you provided as an example). Could you please test it again? Thank you.
|
 frankC-20
|
That is because I deleted a lot of variations of that product to see if updating works with less variations. If you try updating product 22606 for example, you'll get a timeout error with "WPML Multilingual CMS" activated. If you deactivate it, updating works perfectly. Frank
|
 Andrey
WPML Supporter since 06/2013
Languages:
English (English )
Russian (Русский )
Timezone:
Europe/Kyiv (GMT+03:00)
|
Please give me another example of such a product. I still encourage you to try to increase some parameters on the server I mentioned before in order to test this.
|
 frankC-20
|
You can also try product 10578: updating the product will give you a timeout error with "WPML Multilingual CMS" activated. If you deactivate it, updating works 100%.
|
 frankC-20
|
I've increased PHP max input vars from 4000 to 16000. Updating product 22606 now works after minutes of waiting, Updating product 10578 (has more variations) still doesn't work (504 Gateway Time-out). "WPML Multilingual CMS" is extremly slowing down the process. Please advise - Frank
|
 Andrey
WPML Supporter since 06/2013
Languages:
English (English )
Russian (Русский )
Timezone:
Europe/Kyiv (GMT+03:00)
|
Thank you for your feedback. I am going to consult our team. I'll keep you posted.
|
 Andrey
WPML Supporter since 06/2013
Languages:
English (English )
Russian (Русский )
Timezone:
Europe/Kyiv (GMT+03:00)
|
I appreciate your patience as we work to resolve your issue. Unfortunately, we do not have an immediate solution. However, we have already escalated your case to our development team. We cannot provide a timeframe for a resolution as it depends on several factors.
In the meantime, we recommend avoiding product variations if they are not in use. You can also try increasing other parameters on the server as a temporary workaround.
|
 frankC-20
|
Thank you! Yes, I'm deleting unused variations, however, there are only a few products where there unused variations to delete. For now, my temporary workaround is to deactivate "WPML Multilingual CMS" before updating my products and then to reactivate it afterwards - which is not acceptable of course. Looking forward to your solution. Frank
|