A few things I'm stuck with

[Chibi_Chicken]

I would check the table prefix_settings and see if the theme is set to simple, also check that it is all lowercase and that the folder is lowercase as well.

Then check prefix_users and see what your theme is set at. The users setting for the theme will override the sites settings. So if the theme is working when you are logged in then you should see a difference in those two tables.