[Closed] Media is duplicated when WPML is enabled

The main issue can be seen here: hidden link

as you can see you are using over 90M of memory and only have 40M available plus you need a minimum of 128M (in your case more than that, since you're already using amost 100M) n order to meet our minimum requirements so let's start with that:

Please add the following code in your wp-config.php file, right after the database information lines of code:

define('WP_MEMORY_LIMIT','256M');

2) ❌ Before proceeding please make a full website backup! ❌
Go to WPML -> Support -> Troubleshooting
Press the following buttons:
• "Clear the cache in WPML"
• "Remove ghost entries from the translation tables"
• "Fix element_type collation"
• "Set language information"
• "Fix post type assignment for translations"

------------------------

I don't think that will fix the problem of the images but it will prevent other to duplicate like that.

However it also seems you have reset WPML before and that would actually explain why the content is showing duplicated as you see it right now as well, could it be that you did so?

However there's a way to fix this if you have access to your database.

You can use this query to delete all the duplicated queries: https://wpml.org/forums/topic/image-duplication-2/#post-10188479

In your case, the query would be:

DELETE FROM `wpue_posts` WHERE `post_name` LIKE '%-3%' AND `post_type` LIKE 'attachment'

and you'd have to run this query a few times changing %-3%

with:

- %-1%
- %-2%
- %-4%
- %-5%

And so on until you see that the query is not being applied to any element anymore.

Regards.

if you lost attachments tell me that the attachments were the ones that you chose as the "main" image for said attachments and not the actual original image, which at the same time tells me those images existed there before since it's impossible those images are added to content otherwise.

However, i see that the duplicated image is not there already so i'm not entirely sure what else i can do here to help you, maybe i'm not understanding your new request?

Let me, however explain in detail how the query above i gave you works.

When you create an image, WordPress assigns it a slug as it would with a post (because an image is actually a post TYPE for WordPress so they have the same structure).
that slug will be unique but if the image is duplicated it will attach a "-2" "-3", etc.

This means that if you have an image that was duplicated 4 times, their slugs would probably look like this:
this-is-an-image (original)
this-is-an-image-1 (duplicate 1)
this-is-an-image-2 (duplicate 2)
this-is-an-image-3 (duplicate 3)
this-is-an-image-4 (duplicate 4)

However if you have 2 images that have the same name, they would have a similar slug:

original-image (image one called "original image")
original-image-2 (another image called "original image")

There is no way to differentiate between the 2 images WordPress doesn't really "look" at the actual image, it only looks at the slugs and the query i sent you would end up deleting that image as well.

--------------------

If you see that there are images missing, try to upload them again and if they are not attached to a page, that's only because you attached a duplicate of an image and not the original one. it was removed so it's not attached anymore and in this case you can now attach the original one.

Regards.

I couldn't see the images because it seems lightshot is not working correctly, however:

1) It's normal that the images are not duplicated in the file directory because the "duplication" is just a database entry that makes WordPress believe there are images for each language

2) I checked your site and i don't see any duplicated image in one language and since i can't really see the screenshot, i'm a bit lost on what you mean here

3) I'm not sure where you're getting this or how but the images in the database should exist 1 for each language you have, again this is a database entry that allows the image to be available in the translated languages.

Regards.