so, i have a wordpress installation that uses just pages, no posts. its configured to have a page shown at the root.
all my pages have disappeared, in the sense that they don't show up and even the edit-pages admin page says there are no pages.
the good thing is that the pages exist in the DB, and that in the edit-pages admin page the right 'count' of pages is show, despite the next line says 'no pages found'.
i've tried to look through the source code and found the actual SQL that runs to fetch the pages from the DB (SELECT * FROM <DB_NAME>.wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_order, post_title ASC) and it works when i try to run it through the database. i even counted the number of rows (i injected code into wordpress) and see that it gets the right number of pages back.
i made sure there are no plugins filtering anything out from this query.