I can see previews on Drafts, but published pages return 404

I cannot for the life of me figure out this problem and it's ruined my website if i can't get it to work again. I honestly don't know what i did, but the only thing i can think of is that the plugin i ran seconds before all of this stuff started happening did something to my database. I used the "better delete revision" plugin to try and trim my database and suddenly I can't see any of my published posts anymore. All of them still exist and the content is still there when i go to edit them on the dashboard, but they won't show up on the website. It just returns a 404 page.

I made backups of both my database and exported the posts. So i have them just in case something else happens. The weird thing is that I can still see the "previews" of drafts, but I can't see regular posts.

I also just installed 3.1 and was playing around with the post formats code addition.

add_theme_support( 'post-formats', array( 'aside', 'chat', 'gallery', 'image', 'link', 'quote', 'status', 'video', 'audio' ) );