Import Issue - Post Content Filtered in databse

[mikezielonka]

Bug Description

Followed a straightforward export/import process using WP All Export and Import to ensure the post content filtered column is migrated from staging to prod. see details here

To ensure valid json, I manually moved the post content filtered contents from staging to prod's DB after search and replacing the URLs.

Content is valid json and present in production DB

Expected Behaviour

Web Story should be editable in the WP web stories editor rather than showing a blank new story

Steps to Reproduce

Import staging sql into production and replace the root URL to use the production root. This method assumes some broken images but that can be resolved with my final export/import using the WP All Import/Export plugin

Screenshots

Additional Context

Editor Preview (post import)

Web Story Preview (post import)

• Plugin Version: 1.32.0
• WordPress Version: 6.2
• Operating System: macOS latest
• Browser: chrome latest

staging export.sql.zip

hamburger buns prod.sql.zip

[swissspidy]

Thanks fro the ZIP files, very helpful!

I was able to import them both on my testing site with no issues. The story shows fine both on the frontend and in the editor.

So... it must be something else 😕 At this point, have you tried doing this import on a completely clean new testing site? I wonder if any other plugins are getting in the way.

If that also doesn't work, I can try to assemble a development build for you with some extra debugging information to help pinpoint the issue.

[mikezielonka]

We have web stories on staging that didn't get migrated when we did a theme refresh. The team did the normal import/export from WP and then pinged me asking me to taking a deeper look. Then it hit me... I know the issue. :)

I'll set it up locally here and debug a bit more.

Any additional tooling tho would be excellent.

Perhaps a long term solution would be adding support to the core import/export to include the post_content_filtered column for stories?

[swissspidy]

Perhaps a long term solution would be adding support to the core import/export to include the post_content_filtered column for stories?

Unfortunately WordPress core has no way of adding this extra column to neither the import or the export. 😞 Otherwise we would have added this a long time ago.

[mikezielonka]

Perhaps a long term solution would be adding support to the core import/export to include the post_content_filtered column for stories?

Unfortunately WordPress core has no way of adding this extra column to neither the import or the export. 😞 Otherwise we would have added this a long time ago.

This plugin, Export media with selected content, has a clever work around as an example to include media when you export via core's exporter. Maybe some inspiration there.💡

[swissspidy]

Good thinking! Unfortunately that just changes which types of posts to include in the export, but does not add any additional fields (which we would need to do).

With https://core.trac.wordpress.org/ticket/34414 likely being a wontfix, a custom export/import solution as tracked in #4357, or a separate plugin like you are using is the way to go right now still