Home›Support›English Support›[Resolved] Export plugin found 2164 imported posts (which actually were not imported)
[Resolved] Export plugin found 2164 imported posts (which actually were not imported)
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.
Background of the issue:
We have not yet imported any posts on the website, but on this page we see that WPML Import and Export plugin found 2164 imported posts (which actually were not imported). We have a script that lists all posts and their _wpml_import_language_code, _wpml_import_source_language_code, _wpml_import_translation_group meta values. For many posts, this information is missing. However, in the WP backend, they are indicated as correctly translated versions. URL: hidden link
Symptoms:
WPML Import and Export plugin incorrectly identifies 2164 posts as imported, which were not imported. Running operations on these posts may result in lost connections between post translations.
I tried already, based on the recommendations by WPLM support> 1. Take a backup of your site first for safety reasons.
2. Try to delete the recently imported posts if possible.
3. Update WPML plugins to the latest version.
4. Go to WPML >> Support >> Troubleshooting page and press the below buttons:
- Clear the cache in WPML
- Synchronize posts taxonomies
- Remove ghost entries from the translation tables
- Synchronize local job ids with ATE jobs
- Synchronize translators and translation managers with ATE
- Assign translation status to duplicated content
- Fix post type assignment for translations
- Set language information
5. Try to import the post again and see if this resolves the issue.
But the issue of 2164 imported posts is still there.
Questions:
How can we get rid of 2164 or now 2177 imported posts we see in the WPML Export and Import
We would need to have a further look and check with disabling other plugins/themes. If possible, please create a staging site and share access with us so we can take a look.
I am trying to access the staging site, but it requires Website protection details, I tried a few of what you shared above but it seems it doesn't work. Can you please recheck and share it with me or disable it for staging?
thanks for getting back, I have run WPML Troubleshooting tools (Set language information) and then run the Import/export tool, probably message was probably there since some data was missing for posts.
After running it, the message is gone and the tool seems to work fine now. Can you please check the staging, if everything is okay and if it has not caused any issues with the post connection?
our 2nd tier checked and we checked the database for _wpml_import_language_code. The query returned 2,177 rows, exactly the number shown on the backend.
This meta-key should not exist in the post-meta table if the import process hasn't been executed. Did you maybe add it somehow or import was indeed done at some point in the past?
Hello. No we just perform first test import of 1 article or so. We noticed however some fake RU casino posts - which means we were hacked at some point - we manually deleted those posts - if this can maybe be connected or done through the import? Can you check some examples of those - In any way since we haven't perform any imports if we just delete those in a way everything else stays the same on the site we are probably good.
Hello,
We also tried every proposal and we always get the same after we run exporter - the articles looks like they loose the translations - but checking further, the actual websites look like staying live, just translations are not seen as standard with pens marking the translation is active on another language - you will understand what I mean by checking this video walkthrough. It's just we need to be 100% sure we haven't actually lost the articles if we don't revert now. What do you think ? hidden link
I am sorry but I am not sure I understand completely the topic and your last reply, let's try to clear things up.
1) I am trying to solve the issue you mentioned first (How can we get rid of 2164 or now 2177 imported posts we see in the WPML Export and Import), and for that was our last suggested fix.
If you now check WPML Import Export screen, do you still get this message, or this is solved?
2) Why are you running an exporter now, and which exporter are you running, I see you have different plugins?
You should have prepared sheets to import/export before doing any action and follow our docs for each. I think this should be another topic and not related to the first main issue topic you mentioned and we are solving.
3) It seems like you have articles in all languages, just they are not connected as translations to each other.
Hello,
Thanks for getting back. Let me answer by your numbers>
1.) We could not get rid of the attempt to run through 2177 posts - but the only "damage" we see is the disconnect of the translations - now we are figuring out if this is really a damage in some way or no crucial impact.
2.) We use WPML Import and Export - per my understanding to move articles, uploaded by All Import plugin which imports them into draft versions - into the articles from draft to published and with language information - here the msg of 2177 posts came up all the time. Now we went trough that but we lost the language connections again.
3.) You see any issue with that going forward?
Thanks
