I was using " Media Translation" option with these setting turned on, hidden link
I asked for the help with complete removal of WPML data from my site on that support ticket. They helped but they missed to give me solution to remove duplicate media due to WPML Media Translation setting. I found this later, and until i reply to that thread, it was closed.
In my media library i see multiple duplicate image listed of same image, using the same media path file. So i guess images are not duplicated, only-duplicate on Database entry, see hidden link
I found related article here, hidden link
But i need clear answer from you guys to remove those WPML duplicate image entry from my database, i will request you to reopen that ticket so that the person helped me can answer me better because they know my issue from beginning.
I've read the ticket in detail and have also discussed with George.
Since you've already applied several queries and 've reset/removed the tables relating WPML. Perhaps something may have not run correctly during that practice.
However, only viable option is to try the following plugins and see if these help you fix the problem:
Ooh, I have never seen such a bad plugin in my entire WordPress carrier 🙁
I invested more than 3000$ in your plugin and automatic translation, hoping this was the good solution for my site multilingual feature, but what i get:-
1) Poor support even after paying this much, gets reply in more than 15 or 20 hours even on serious issue, when you are loosing business
2) DB got bloated by WPML and due to that website crashed
3) Lost 15000$ of my website business due to site downtime
4) Always asked for help from day one, and i alway get reply like, checking, this is not our plugin fault, do this, do that, etc
Finally i got fed up and finally decided to get rid of your plugin, again here your plugin data reset didn't work, asked for manual cleaning, followed each and every step told by you. Still not able to remove all data like media duplicate. How could you guys make this type of shit plugin and wasting customer time and money?
Your plugin data reset doesn't work, WPML media plugin not works properly, already created ticket on all of the thing i am mentioning here, and you always gave excuses. So please don't tell this or that and first read my all ticket carefully.
How can you say this that "you've already applied several queries and 've reset/removed the tables relating WPML". All the query i ran is given by you, and you already knew that what i am asking, i.e. complete WMPL cleanup. I have never ran any query from my own. And i was hoping to complete WPML reset from your given query. So here its not my problem that i ran queries. I asked for your help in cleaning my site with WPML, and was expecting for complete cleanup, including media duplication.
And you are saying something may have not run correctly during that practice. Its clearly tells that you also have no believe in your plugin. Your plugin just doesn't work at any level.
Now in my media library, i have almost 1.9 lakhs media listed, most of them are duplicated by WPML due to that this data got huge. So you want me to go and try manual cleaning with media cleaner plugin? Do you think i have time for this SHIT done by your plugin even after paying 300$+?
Disgusting, please issue my all refund for Media translation as well as plugin cost. And don't say you don't come under our refund policy. Please understand my situation and then say anything regarding you cant issue refund, in the whole process i have lost my money, time , and business. I have no more trust in you guys 🙁
I am one of the support leaders in WPML, and my colleague asked me for help on this ticket, so let me jump in.
We understand your frustration and situation and are well aware of this from the last ticket. As you have seen in the last ticket we are doing our best and going out of scope to help out.
We will continue to do so, but would need your collaboration in keeping this ticket on topic, and on polite replies. Such replies are not helpful, as instead of moving forward with helping both you and our support are losing time, and this prolongs time to fix the actual issue. If the reply is not helpful as you have seen, our support will try and find another way/solution to help. A staging site would also really help.
So, let's continue helping out on this issue and I am sure we can find a solution as we did in the last ticket 🙂
1) I know you said it is not possible, but is there now a way you can provide a staging site where we can check out further this issue? It would really speed things up.
2) If not, please provide admin access, so we can have a quick glance at the issue. We will not run or do any actions, as we mentioned in the last ticket, since this is a production website.
After closing the ticket, credentials were removed for GDPR and security reasons.
3) Did you try to run the mentioned tools, there is a chance they can help. It is not a manual process, tools do the clean up automatically.
1) Your team analyzed the files from the production site or the backup drive file I shared? Since the drive file was taken before I proceeded with the WPML reset, the analyzed tables inside the data might differ. So is it safe to move further on the live site with these data if it is still not taken from the live site?
2) So the given compiled SQL will create a new table "to_delete" and fills it with the records from the given SQL query. So I assume that it copies the record from the original to "to_delete" so we can utilize this table in our delete process?
3) What do you mean by "It is assumed that you have not deployed the same database dump, so this is necessary.", BTW, I have never run the type of query you gave above. I think this is what you are trying to say here.
4) I am on AWS with very high spec, so please guide me on what setting to increase so there will be no timeout in the process.
5) You said, "DO NOTE! There are NO SAFEGUARDS!" what are you trying to say here? Does that mean this process can also delete the original image and have further issues with the image on our site?
Please consider following answers to your questions:
1) Yes, they analyzed and provided the solution based on the files you shared in the drive.
Although, it may be OK to try these queries on another database BUT this has to be carefully executed. As you noticed, that, the first query fetches records from "wp_icl_translations" into "to_delete" table and then rest of the queries are applied based on that (see #5 below for a related safety measure).
On the other hand, since you provided access to live site but mentioned not to do anything in there. Is this OK for you to share the DB backup for the production site?
However, please make sure to TAKE FULL BACKUP OF DB AND SITE before running the queries.
2) "to_delete" is a new table which doesn't exist already, but is a new table and is created by the SQL to get the records from "wp_icl_translations" table. This table is utilized in rest of the queries.
3) Means restored from backup.
4) You can check for the max_input_time, max_input_vars, memory_limit and max_execution_time. Please consult the PHP Manual (hidden link) and your service provider for possible configurations.
5) This means, the supplied CSV and SQL files contain the IDs based on the file you shared. So, if you try these in another environment or on another DB that could be problematic. Because, for example, you created a page and the page had ID 5 but in the other environment you ran the process for attachment duplication and the attachment was with ID 5 - then ID 5 will be deleted regardless of if it is an attachment or a page.
This is why it is highly advised to be careful running these queries, either on the same DB or on another one - ALWAYS TAKE FULL BACKUP OF THE DB AND SITE BEFOREHAND!!
Reference to #1 (above), if you would want to share the DB backup of production site, please let me know to enable private message for you.
I was finally bring your SQL file into a database. Looks like there are no icl tables (i.e. wp_icl_translations and etc) thus no translations.
As you have noted from previous messages, the select query runs on wp_icl_translations table to find out any translations and thus moving on to find and delete in other WP tables.
So I think this DB hasn't any problem like the one you mentioned. However, if you still think it has, I'll advise to restore the file you provide me into another DB and try the queries on that for the cleanup.
