I have in summary 12 PDF files at above WP site. 11 of them are showing up correctly in media library, but one not: hidden link. The one not in media library is referenced correctly at the english version of the site's start page (hidden link) and I can see it also in the database. When I deactivate WPML I can see all PDFs correctly.
I tried to install Media Translation, because I thought if I could use WPML Translation Editor instead of WordPress editor for the start page (which has links to different PDF files in German and in English), this might solve the issue. But it did not. Moreover I could not "translate" the path to the PDF file in the english version, because it was not offered by the translation editor.
Thank you for contacting WPML support. While you are waiting for one of my colleagues to take this ticket and work on it, let me provide you with the first debugging steps or if I can help with the issue quickly.
I understand that PDF file appears in the Media Library when WPML is deactivated. This issue could happen if the media file does not have language information. To fix that, please try going to WPML → Support → troubleshooting and click "Set Language information". You can follow this quick GIF for help: hidden link.
My apologies for the delayed responses. Our support team is currently experiencing a high volume of requests.
Thank you for attempting the troubleshooting option.
I notice that you have access to the database and the ability to retrieve information. Would you kindly navigate to the "icl_translations" table and locate the "element_id" "18840"? It would be greatly appreciated if you could provide a screenshot of your findings.
Thank you. I checked the entries of all PDF files in this table and found out, that the element with id 18840, which is the one, I can't see in the media library, is the only one with language_code "en" - see scrennshot.
I don't know how this happened. And unfortunately, I can't change it in the database (duplicate entry '35264-de' for key trid_lang).
I have many more issues of this kind. I took the whole website over from another agency. All documents and media should be german by default and are translated to english. But there are many elements which are "english" by default, which causes a lot of troubles.
That explains why the media file does not appear in the Media Library. It should show if you switch the language using the admin bar language switcher (screenshot: hidden link). This happens when you upload the media (or create a post/page) in the secondary languages. And most probably, that is what happened with that media file.
I understand that you tried to change the language code directly in the database and received an error (duplicate entry '35264-de' for key trid_lang).
I would recommend re-uploading that file in the original language, which is German, and it will take the appropriate language information.
in fact the first issue is resolved now. Thanks to your help, I could find out that the duplicate entry of '35264-de' referred to an ID which did not exist in wp_posts. So I could delete it and change the other one to english and now I can see all documents in the media library.
The second problem is still open - let me know if I should open another ticket for that.
As mentioned above I have a page which should link to this PDF file, but only the english version of the page. The german version should link to the german PDF. I can manage this with WordPress Editor but not with WPML Translation Editor. It does not offer me the path of the PDF for translation.
