I've just discovered a very annoying problem, I noticed guests or regular members cannot view anything on the site apart from the homepage. I'm currently working on so I checked it out and the page status isn't saving at all. I'll select Publish and go back to it and it's just blank, nothing is selected. As admin I can view them perfectly but if I logout then I cannot view the pages anymore, it just gives me a 404 error which is very irritating. As a guest or a member you can't even view the extra comments on a blog post. I have no idea what has happened but it worked fine.
I think it maybe a database error as I installed bbPress which completely destroyed my site in the process so I had to restore the database by manually adding myself as a member. I didn't check right after that however, I only found out a day after it happened and I've done a lot more modifications to it in the meantime but it being a database error seems more credible but I can't be completely sure. Everything else is working absolutely fine, yet the posts and pages just don't seem to be responding at all.
All I know is, guests and regular members can't view anything apart from the homepage; news with comments, custom pages, archives, links etc. And it has to be because my pages aren't saving their status and just remain... there. As mentioned, guests can view the homepage and the news can be read fine there. Once they click on the comments link it goes to the 404 error.
I really need some help on this as I'm not really a database expert and I've been using WordPress for a couple of days. I didn't want to post anything information about my site until requested, so if you need to see what I've done in my database or see the site itself then please give me your email address.
Thanks in advance,