This thread is resolved. Here is a description of the problem and solution.
Problem:
You are seeing 2164 posts incorrectly identified as imported by the WPML Import and Export plugin, which were not actually imported. This issue persists even after trying recommended troubleshooting steps such as clearing cache, synchronizing posts, and updating plugins.
Solution:
If you're experiencing this issue, we recommend taking the following steps:
1. Ensure you have a backup of your site for safety.
2. Use a script or SQL queries to delete specific post meta related to WPML import. Here are the SQL commands you can run:
DELETE FROM `wp_postmeta` WHERE `meta_key` = '_wpml_import_language_code';<br />DELETE FROM `wp_postmeta` WHERE `meta_key` = '_wpml_import_source_language_code';<br />DELETE FROM `wp_postmeta` WHERE `meta_key` = '_wpml_import_translation_group';<br />DELETE FROM `wp_postmeta` WHERE `meta_key` = '_wpml_import_after_process_post_status';
This solution might be irrelevant if it's outdated or not applicable to your case. We highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If the issue persists, please open a new support ticket at WPML support forum.
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: Exception
This topic contains 0 replies, has 0 voices.
Last updated by misoM 1 week, 2 days ago.
Assisted by: Dražen.
Author | Posts |
---|---|
January 17, 2025 at 7:21 am #16604484 | |
Dražen Supporter
Languages: English (English ) Timezone: Europe/Zagreb (GMT+01:00) |
Hello, 1) Okay, so we should concentrate on this and how to remove this part, you should not run until it is removed. The damage is that Google will not know what translation of what is, but will look of them as separate pages etc. Can you please provide DB access or FTP for staging so we can try the workaround also and adjust it if needed? 2) For WP All Import and WP All Export, you should follow next guides: - https://wpml.org/documentation/plugins-compatibility/export-multilingual-websites-using-wp-all-export-wpml/ And use WPML All Import add-on instead of WPML Export Import addon. Let me know. Thanks, |
January 17, 2025 at 8:27 am #16604712 | |
Dražen Supporter
Languages: English (English ) Timezone: Europe/Zagreb (GMT+01:00) |
Hello, yes, I will try the fix we suggested and if it doesn't work, get back to our 2nd tier to check further. I would need the Database access URL if you have one, or if not FTP access for the staging site, so I can try to access DB and apply the fix. Thanks, |
January 17, 2025 at 9:30 am #16604933 | |
Dražen Supporter
Languages: English (English ) Timezone: Europe/Zagreb (GMT+01:00) |
Hello, I tried but FTP is not working, either the credentials are not correct, or some port is needed or hosting is blocking my access. Can you please re-check, make sure it works, and let me know, then I can proceed. Regards, |
January 17, 2025 at 10:06 am #16605193 | |
misoM |
Hi. I think I had some security settings ON. Can you please check now with the same credentials. |
January 17, 2025 at 11:26 am #16605763 | |
Dražen Supporter
Languages: English (English ) Timezone: Europe/Zagreb (GMT+01:00) |
Hello, unfortunately, still the same, maybe some port is needed since it is an sFTP connection? Status: Access denied Error: Authentication failed. Error: Critical error: Could not connect to server Regards, |
January 17, 2025 at 12:09 pm #16606005 | |
misoM |
Sorry also SSH access have been disabled. Can you check now please. |
January 17, 2025 at 1:35 pm #16606320 | |
Dražen Supporter
Languages: English (English ) Timezone: Europe/Zagreb (GMT+01:00) |
Hello, thanks, I still get the same error, but I managed to access it from the WP dashboard now that SSH is disabled. Anyway, I ran the query we provided to you, and seems it works. The message in WPML Import Export is not there anymore, and it shows a regular start screen. Regards, |
January 17, 2025 at 1:57 pm #16606401 | |
misoM |
Hello. That sounds great, Can you by chance running this for me on the live site as well? |
January 17, 2025 at 2:11 pm #16606463 | |
misoM |
Hello. I made a backup and SSH allowed. |
January 17, 2025 at 3:19 pm #16607037 | |
Dražen Supporter
Languages: English (English ) Timezone: Europe/Zagreb (GMT+01:00) |
Hello, great, thanks. It is done, hope now it is all okay. Regards, |
January 17, 2025 at 5:16 pm #16607677 | |
misoM |
We solved the issue! Thanks a lot! Could you maybe share with me what was the problem so we understand if it happens again? Thanks |
January 20, 2025 at 6:50 am #16611789 | |
Dražen Supporter
Languages: English (English ) Timezone: Europe/Zagreb (GMT+01:00) |
Hello, great, glad to hear that. As fair as we can see post had data about import, which probably got there from the import process or similar, maybe in the past. So we run SQL queries to remove those from the DB. Regards, |
January 20, 2025 at 12:39 pm #16613357 | |
misoM |
Thanks for the great support Dražen. Best regards! |