The existing glossary items is showing duplicate entries

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

Problem:
The client is experiencing duplicate entries of existing glossary items in WPML's Translation Management Tools Glossary.
Solution:
1. Ensure that all WPML plugins are updated to the latest version. For example, update to WPML 4.6.6 and WPML String Translation 3.2.8. Before updating, make sure to save a backup of the site and database.
2. If updating does not resolve the issue, we are ready to investigate further and would require temporary access to the client's test site's wp-admin and FTP. The client should ensure that a backup is in place before providing access.
3. Our development team is aware of the Glossary Duplicate Entries issue and is planning to implement a fix in the next version of our Automatic Translation Editor. This update is expected to be released in a couple of days, and we will confirm back once it is done.

If this solution doesn't look relevant, 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.

Tagged: ATE

This topic contains 14 replies, has 2 voices.

Last updated by Ilyes 1 year, 5 months ago.

Assisted by: Ilyes.

Author	Posts
September 5, 2023 at 1:18 pm #14344717
peterJ-48	Find the screenshot. Go to : " WPML -> Translation Management -> Tools -> Glossary " We get duplicate entries of existing glossary items. If we add new words to the glossary and they are only shown with one record, but all existing words in the glossary is still shown double. Can you help me, Why the existing glossary items is showing duplicate entries?
September 6, 2023 at 9:00 am #14349629
Ilyes Supporter Languages: French (Français ) Timezone: Pacific/Easter (GMT-06:00)	Hello, Thank you for contacting WPML support team, I have noticed that your WPML plugins are not updated to the newest version, Please save a backup of your site and database and update them (e.g WPML 4.6.6 and WPML string translation 3.2.8...) If that did not help, I would like to ask for temporary access to your test site’s wp-admin and FTP to investigate the issue further. Make sure to have a backup and if you do not see the form below, please do not enter your credentials as they will be publicly exposed: hidden link Best,
September 6, 2023 at 9:53 am #14350437
peterJ-48	Hi Ilyes, We will test the latest WPML version on a test site and get back to you, if we need more assistance.
September 8, 2023 at 11:14 am #14366201
peterJ-48	Hi Ilyes, We tested with updated WPML plugins but still we are getting "Existing glossary item is showing duplicate entries" issue.
September 8, 2023 at 11:28 am #14366273
Ilyes Supporter Languages: French (Français ) Timezone: Pacific/Easter (GMT-06:00)	Hello, I would like to ask for temporary access to your test site’s wp-admin and FTP to investigate the issue further. If necessary, I may need to replicate your site locally. To do this, I will temporarily install a plugin called “Duplicator” on your site, which will enable me to create a copy of your site and its content. Once the problem has been resolved, I will delete the local site. Please let me know if you agree to this. It is important to note that you should back up your site and database before proceeding, and you can use a plugin like Duplicator for this purpose. Here’s a link to the plugin: http://wordpress.org/plugins/duplicator/ If you do not see the form below, please do not enter your credentials as they will be publicly exposed: hidden link For your privacy and security, please ensure that you make your reply a private one. Best regards,
September 8, 2023 at 7:14 pm #14368347
Ilyes Supporter Languages: French (Français ) Timezone: Pacific/Easter (GMT-06:00)	Hello, After checking your site's moving history, Before anything, do you see those duplicates on your live site too? I found that hidden link was copied multiple times from two different links : hidden link hidden link I'm verifying with our systems team as one of the copies are flagged as "duplicated_copy" which could explain having a duplicate glossary, Long story short, I'm escalating this to our systems team as they might have a better idea on how to track and fix this, I will get back to you once I get any updates, Have a good weekend! 🙂
September 11, 2023 at 6:52 am #14372931
peterJ-48	Hi Ilyes, Do you see those duplicates on your live site too? Reply : Yes.
September 11, 2023 at 1:07 pm #14376571
peterJ-48	Hi Ilyes, We noticed, The more often we restore the database, the more often the data gets duplicated from the glossary items. We restored the database first-time, that time duplicate glossary items 2 times We restored the database second-time, that time duplicate glossary items 4 times, Now, restored the database third-time, we have duplicate glossary items 6 times.(Find the screenshot.) Did we do something wrong in restoring the database? Process - files/database from live to test site. - Export and import database from live to test site - Zip and unzip files from live to test site - Search and Replace Links - Change WPML and other plugin license key - Allow file permission using this command : sudo chown -R www-data:www-data /path/to/website
September 11, 2023 at 2:33 pm #14377317
Ilyes Supporter Languages: French (Français ) Timezone: Pacific/Easter (GMT-06:00)	Hello, That is an excellent lead, thank you for sharing more details, I have sent your reply to our systems team, I will get back to you once I get any updates, Thanks!
October 2, 2023 at 9:55 am #14496675
Ilyes Supporter Languages: French (Français ) Timezone: Pacific/Easter (GMT-06:00)	Hello, Thank you again for your patience, I have received an update from our development team, we are planning on implementing a fix for the Glossary Duplicate Entries issue in the next version of our Automatic Translation Editor, It is a matter of a couple of days until it gets updated, I will confirm back to you once done 🙂 May you have a great day,
October 2, 2023 at 10:20 am #14497013
peterJ-48	Hi Ilyes, Ok, I will wait for your reply, please reply as soon as possible. Thanks,
October 11, 2023 at 11:02 am #14558525
peterJ-48	Hi Ilyes, Any news? Has the issue been fixed?
October 11, 2023 at 11:54 am #14558969
Ilyes Supporter Languages: French (Français ) Timezone: Pacific/Easter (GMT-06:00)	Hello, I'm afraid I still cannot confirm when this change will be implemented, The last update I could see, is that this issue was already fixed and scheduled for publication with other patches soon, So it should be a matter of days, Thank you again for your patience!
November 1, 2023 at 2:08 pm #14708047
peterJ-48	Hi Ilyes, Any news? Has the issue been fixed? In case the issue is fixed, how do we then get rid of all the duplicate entries? The glossary is on your database with the ATE right?
November 1, 2023 at 7:06 pm #14710081
Ilyes Supporter Languages: French (Français ) Timezone: Pacific/Easter (GMT-06:00)	Hello, Thank you for the follow-up, I'm afraid this hasn't been implemented yet, I have left a message to our development team to get an ETA on this, I should get back to you later today or tomorrow morning with more information. We apologize for the inconvenience that this might have caused, and thank you again for your patience, Best,