I have a database collection for our online magazine, I've set up a dynamic page with a pro gallery to display all stories and an dynamic item page for the individual posts. Everything's been working absolutely fine for the past months until recently. The problem is that now all posts except one (the most recent) do not open to their assigned dynamite title page (post page), while in editor mode the system tells me there's no link to that post, and on the live site it doesn't click when hovering over posts to open the posts. If I try to insert a post's link directly into my google search bar I get a 404 Error page. Nothing has changed within the set up and I've tried everything or days to resolve this but could not. I also noticed that on my TITLE dynamic page, in Editor mode, I no longer see the 'Preview' dynamic bar where you'd scroll to preview different posts from the database, it's just not there, meaning that it only recognizes that one recent post and no other post, as if the collection were empty with only 1 post. The strange thing is that on the actual dynamic page where I have the pro gallery everything is read and displaying from the database, image, titles etc, they're just unclickable, though. I've synched the sandbox, copied all items to live, double checked the live database, seems normal as always, but resolved nothing.
Any help would be much appreciated. Best