Please make sure to update to WPML 4.3.6 and check our list of Known Issues before reporting

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 thread is resolved. Here is a description of the problem and solution.

Problem: Database Error on wp_icl_string_urls

Solution: Upgrading to WPML 3.5.2 fixed the issue

Relevant Documentation:

This topic contains 14 replies, has 3 voices.

Last updated by Bigul 3 years, 4 months ago.

Assigned support staff: Bigul.

Author Posts
September 8, 2016 at 11:15 am #1068186

FilippoZ1

Hello,
string translation feature has stopped working after latest update.
Strings are detected, but when I click on "translate" nothing happens.

I have a website with Woocommerce Multilingual.

URL of (my) website where problem appears: fortunatiantonio.it

I can see this error in debug log, repeated infinitely:

[08-Sep-2016 10:45:05 UTC] WordPress errore sul database Duplicate entry 'it-' for key 'string_string_lang_url' per la query INSERT INTO `wp_icl_string_urls` (`language`, `url`) VALUES ('it', '') fatta da shutdown_action_hook, do_action('shutdown'), call_user_func_array, WPML_ST_DB_Cache->shutdown, WPML_ST_Page_Translations_Persist->store_new_translations, WPML_ST_Page_Translations_Persist->fetch_or_create_url_id

September 8, 2016 at 9:56 pm #1069600

FilippoZ1

I deleted the empty entry as I read in this thread https://wpml.org/forums/topic/database-error-duplicate-entry-wp_icl_string_urls/
but the empty row keeps coming back, and the error with it.

September 9, 2016 at 7:41 am #1070161

Shekhar Bhandari
Supporter

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hi there,

Thank you for contacting WPML support.

To debug the issue quickly, I need to request temporary access (wp-admin and FTP) to your site in order to be of better help. You will find the needed fields for this below the comment area when you log in to leave your next reply. hidden link

These info is private, and available to you and supporters only. Read more about this: https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/

Note that:

#1
Backup (both files and database) your site before giving us your credentials. You can use a plugin for this if you like. I often use the Duplicator plugin for this purpose.
See: http://wordpress.org/plugins/duplicator/

Duplicator instruction
hidden link

#2
It would be better if you give me the test site rather than the live site.

#3
If the issues needs some changes in the plugins updates/disabling we will install a plugin called “duplicator” and replicate the site in our local server for testing.

I look forward to your reply.

Thanks

September 13, 2016 at 2:52 pm #1077718

FilippoZ1

I tried to make a Duplicator Copy but package creation process is failing.
Anyway i gave you access to a staging copy of the website, so feel free to make all the attempts you need.

PS: if you will process any email notification please change the recipient (both wp and woocommerce)

Thanks for your assistance.

September 14, 2016 at 12:09 pm #1079467

Shekhar Bhandari
Supporter

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hi there,

The login details is not working, could you please check it again?

I look forward to your reply.

Thanks

September 14, 2016 at 1:58 pm #1079707

FilippoZ1

Wich ones?

September 14, 2016 at 3:21 pm #1080004

Shekhar Bhandari
Supporter

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

The wp-login details is not working, could you please check it.

September 14, 2016 at 4:05 pm #1080113

FilippoZ1

you're right,
I've pasted twice the htacess pw.
the wp login pass is the following one

Sorry if I asked, but i didn't notice I could see the previous private message

September 16, 2016 at 3:25 pm #1083862

Shekhar Bhandari
Supporter

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hi there,

I have deleted the private details from the reply. Unfortunately, it's still not working, could you please check this again? Before sending please check it in another browser? Have you have enabled any IP restrictions in your site?

I look forward to your reply.

Thanks

September 16, 2016 at 4:31 pm #1084057

FilippoZ1

Ok I made another admin username for you: WPML
the pw is the same I pasted before

September 17, 2016 at 8:14 am #1084706

Shekhar Bhandari
Supporter

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Unfortunately it's still not working, I checked with our colleagues and it's still not working, instead of wp-login details could you please share me the duplicator packages.

You can use a plugin like Duplicator and send me the archive and installer file, See more about Duplicator plugin here: http://wordpress.org/plugins/duplicator/

Duplicator instruction
hidden link

Note: Please upload the file in google drive or Dropbox and share it with me.

I look forward to your reply.

Thanks

September 19, 2016 at 8:14 am #1086848

FilippoZ1

Hello Shekar,
as I told you i a previous message Duplicator encounters some errors and can't finish the package process. Otherwise I would give you the package without any troubles.

I edited the credentials in previous private message. I tried them all and they are working.
there's no filter on IP, can you please try again?

September 21, 2016 at 5:46 am #1091272

Bigul
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Hi ,

I am Bigul from WPML support team. Shekar is on leave. So I am take caring this ticket. Hope it will be okay for you.

We have released the latest version of WPML(3.5.2) yesterday. It having fixes for similar issues. Please take a full site backup, then upgrade to latest version and confirm the error is fixed or not.

--
With Regards

Bigul

September 21, 2016 at 6:36 am #1091330

FilippoZ1

Hello Bigul,
thanks for answering.

Actually we did solve yesterday by using beta versions:

- WPML Multilingual CMS 3.5.2-b.3
- WPML String Translation 2.4.2-b.3
- WPML Translation Management 2.2.3-b.3
- WPML Media 2.1.23-b.2

Do the final 3.5.2 include the fix we are using with our beta versions?

September 21, 2016 at 7:20 am #1091494

Bigul
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Hi ,

Glad to know the issue is fixed for you. Yes, 3.5.2 final release will include all the fixes we have added in the beta. Please upgrade to the 3.5.2 original release after a full site backup.

--
With Regards

Bigul