wocommerce variation table not showing

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: WCML

This topic contains 7 replies, has 0 voices.

Last updated by khaleda-3 3 days, 14 hours ago.

Assisted by: Paola Mendiburu.

Author	Posts
May 9, 2025 at 7:18 am
khaleda-3	Background of the issue: I am trying to display a variation product menu on my WooCommerce site. The issue can be seen on this page: hidden link. The error log message I received is: ON strin' at line 6 for query SELECT COUNT( DISTINCT strings.id ) as count FROM Saq_icl_strings strings. Symptoms: The WooCommerce variation table is not showing as expected. Questions: Why is the WooCommerce variation table not displaying? What does the error message in the log mean?
May 9, 2025 at 9:03 am
May 9, 2025 at 9:04 am #17015375
Paola Mendiburu WPML Supporter since 11/2020 Languages: English (English ) Spanish (Español ) Italian (Italiano ) Timezone: Europe/Madrid (GMT+02:00)	Hi there! As Ftp credentials is not working. Do you give me permission to download a copy with Duplicator? That way I can do tests without affecting your site.
May 10, 2025 at 6:15 am #17018443
khaleda-3	Hello Paola, Yes, go ahead please.
May 12, 2025 at 8:33 am #17021503
Paola Mendiburu WPML Supporter since 11/2020 Languages: English (English ) Spanish (Español ) Italian (Italiano ) Timezone: Europe/Madrid (GMT+02:00)	I am having problems with the migration. I get that error: Chunk error, message: Data too long for column 'url' Could you please solve that issue on your database so I can continue with the migration? Change the column of url for long text.
May 12, 2025 at 8:03 pm #17024556
khaleda-3	Hello Paola, Sorry, but could you elaborate, please?
May 13, 2025 at 1:52 pm #17028137
khaleda-3	Hi, I have noticed that under WooCommerce settings > Products > Shop page, the page selection resets after a while. Thought this may have an affect on the variations issue.
May 14, 2025 at 10:05 am #17031408
Paola Mendiburu WPML Supporter since 11/2020 Languages: English (English ) Spanish (Español ) Italian (Italiano ) Timezone: Europe/Madrid (GMT+02:00)	Hi! I was able to do the migration and I found a soltion. The problem is related to the translation of the string %1$s – %2$s that the trasnaltion was %1$1 - %2$2 and that was causing the problem What I have done: I wen to WPML --> String translation, search for %1$s – %2$s and update the translation to %1$s – %2$s Now is working: hidden link hidden link
May 15, 2025 at 4:01 pm #17038009
khaleda-3	Hello Paola, Great! Odd that the string glitch would be stuck even after I took many remedies steps even as to delete the products, start a new one, delete and reinstall all WPML plugins. Glad you sort it out, of course. Many thanks for your support. Regards
May 15, 2025 at 4:03 pm #17038015
khaleda-3	Many thanks for Paola’s support.