Skip Navigation

This thread is resolved. Here is a description of the problem and solution.

Problem:
The client was experiencing an issue where the WooCommerce variation table was not displaying correctly on their website. The error log indicated a problem with a SQL query related to string translations.
Solution:
We identified that the issue was due to incorrect translation formatting of the string

%1$s – %2$s

. The incorrect format

%1$1 - %2$2

was causing the display issue. To resolve this, we:
1. Navigated to WPML --> String Translation.
2. Searched for the string

%1$s – %2$s

.
3. Updated the translation to the correct format

%1$s – %2$s

.
After making these changes, the WooCommerce variation table displayed correctly, as verified on this test page: https://zahitrade.com/ar/product/a-test-attribute/.

Please note that this solution might be outdated or not applicable to your specific case. If you're still experiencing issues, we highly recommend checking the related known issues, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If the problem persists, please open a new support ticket.

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 7 replies, has 0 voices.

Last updated by khaleda-3 3 weeks, 6 days 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.