Hi Andreas, thank you for picking up this thread. I look forward to a rapid resolution as this WPML media library issue is now impacting our roll-out.
I showed you in my previous message that /wp-content/languages folder is writable. You can see from the image I included that the folder is set to 755. I have included a similar image taken on a DEV copy of the site. Again, the languages folder is set correctly. I also confirm that /wp-content/languages/wpml is writable and is also set to 755. (see additional attached image).
With the file permissions set correctly, please could you investigate why it is not possible to remove the redundant media entries from the database?
If you need to take a copy of the site, please go ahead.
Kind regards,
Phil.
Languages: English (English )Spanish (Español )German (Deutsch )
Timezone: America/Lima (GMT-05:00)
Hello,
I would like to offer to take a copy of your site in order to test it on a virtual server.
I am requesting temporary access (wp-admin and FTP) to the website.
You can find the required fields below the comment section when you log in to leave the next reply. The information you provide is private, which means only you and I can see and access it.
IMPORTANT
Please be sure to make a backup copy of the website and database before allowing us access.
If you can't see the wp-admin / FTP fields, your post and website credentials are set as PUBLIC. DO NOT publish the data unless you see the required wp-admin / FTP fields.
I have to install a plugin called "All In One WP Migration" to make a copy of the website where I can investigate the issue further.
The private response form looks like this: hidden link
Next time you reply, click "I still need assistance."
Video: hidden link
Please note that we are obliged to request this information individually on each ticket. We may not access any access information not specifically submitted on this ticket in the private response form.
I suggest you keep working with Mihai on this matter, as he is already on it.
The error you get is:
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 8388608 bytes) in /var/www/clients/client1/web167/web/wp-includes/class-wpdb.php on line 2397
This means the 256M WP Memory Limit is not enough to run this script.
I may adjust the limit to 512M inside the wp-config.php file but you might possibly run into a similar error again, as there are too many media files, languages, and media translations, and the server can not process it.
Take note, that WPML does need to have one <srong>entry for each image in each language - those are not physical duplicates of files on the server - instead, WPML is simply building a connection between original content and translations on its own WPML database tables.
This means, your site has 44770 media items and 13 languages.
So in order to display those 44700 media items in all languages, it requires at least 582010 data entries, possibly more - as WPML needs to do this, in order to display those 44700 media items in all languages.
If you remove the wrong images from a second language in the media library then those images will not show up in the second language anymore.
WPML Media Translation usually is only necessary in order to upload alternative images in a second language - which means you want a physical alternative image in a specific language.
This is why I suggest, if it was the case, that you used WPML Media in order to upload alternative media files in a second language and you do not want to use those files anymore, then I would suggest manually cleaning up the media library.
When on the WordPress Media Library you can switch the language in the top admin bar to filter images per language.
