Checkout not working
-
I have a very strange problem because at my client website checkout is not working just sometimes. The only error was: Gateway Timeout… No errors in debug.log & error.log. I figured out this may be problem with database, and after debugin using
define( ‘SAVEQUERIES’, true );
i finally found an error
[14-Dec-2022 17:30:27 UTC] WordPress database error Unknown column 'wpml_translations.language_code' in 'where clause' for query SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (8) ) AND 0 = 1 AND wp_term_relationships.term_taxonomy_id IN (28,29,30,141,313,314,398,399) ) AND ((wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'cwg_mailsent' OR wp_posts.post_status = 'cwg_mailnotsent' OR wp_posts.po> OR wp_posts.post_status = 'private'))) AND ( ( ( wpml_translations.language_code = 'pl' OR ( wpml_translations.language_code = 'pl' AND wp_posts.post_type IN ( 'e-landing-page','elementor_library' ) AND ( ( ( SELECT COUNT(element_id) FROM wp_icl_translations WHERE trid = wpml_translations.trid AND language_code = 'pl' ) = 0 ) OR ( ( SELECT COUNT(element_id) FROM wp_icl_translations t2 JOIN wp_posts p ON p.id = t2.element_id WHERE t2.trid = wpml_translations.trid AND t2.language_code = 'pl' AND ( p.post_status = 'publish' OR p.post_type='attachment' AND p.post_status = 'inherit' ) ) = 0 ) ) ) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','konte_size_guide','e-lan> SELECT wcpf_post_meta.post_id FROM wp_postmeta as wcpf_post_meta WHERE wcpf_post_meta.meta_key = '_stock_status' AND wcpf_post_meta.meta_value IN ('instock') ) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC, wp_posts.post_title ASC LIMIT 0, 1500 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_postsNow the checkout is started working, but still don’t know how to fix that, because few hours and it will not work again.
Anyone know how i can fix that problem and goodbay once for all checkout problem?
-
Hi @levskipg
Thanks for sending the System Status Report.
WC Version: 6.8.2As a first step, please update WooCommerce to the latest version by following our guide here: How To Update WooCommerce
If this did not resolve the issue, please try to disable the WPML String Translation: przez OnTheGoSystems – 3.2.3 plugin since the error message points to this plugin:
WordPress database error Unknown column 'wpml_translations.language_code'and see if this works?If so, since this is third-party plugin, it would be best to reach out to the developers for further assistance here.
https://wpml.org/forums/forum/english-support/
Thanks!
The topic ‘Checkout not working’ is closed to new replies.
