WordPress imported pages not visible

Old thread, but I have the same problem today. And the theme is not syncing. I checked and the “site” folder is missing. Where can I send the wxr?

I’m testing with my main site and have a similar problem. I imported and the posts show up when I sync, but they aren’t in the posts section for editing.

They also aren’t tagged, but all the original site categories do show up as tags in the publii desktop app, but all with zero post counts.

I’ve just encountered the same problem. Here is how I managed to resolve it.
Here is how to get your post visible again.

First of all, you will need a SQLite Database editor like this one : https://sqlitebrowser.org/dl/.
Then :

• Open your Publii site directory
  For me : “Documents > Publii > Sites”
• Find the db.sqlite file into the “input” directory
• Edit the SQLite database with SQLiteBrowser
• Browse the “posts” table data and find the posts without title, slug or status
  • The wp_import tool did not save anything in these fields for blog posts of custom type “quote”
• For these records, you can
  • delete the rows
  • edit the rows and type in a title, a unique slug and define a status (published or draft)

Then you need publii to reload the database : this can be done by changing the site you are editing or by closing and reopening the ublii application.

And… voilà !

I hope this wil do the trick for you as well.
I think, wp_import does not handle WordPress custom post types.

I’m having the same problem, but I’ve looked at the SQLite db and just one post is missing a title; would that prevent all of them from appearing gin Publii’s posts section?

UPDATE: Yes, that was it. The post in error was also missing a pub date. Repairing this one row made all the posts appear.