I have a vf page that displays queried results in a data table that works perfectly fine in my sandbox's force.com site. However, when I try to access it in production's force.com site it does not show the queried results at all only the column headers. I've ran debug logs and see the query being called but it retrieves no results.
It does show when Im accessing it in production not through the force.com site so I know there should be records returning. I've checked permissions for the force.com site profile and it has read access for all of the fields in the query.
Is there other reasons why I can't query the results? It doesn't make sense that it works in my sandbox but not in production even with the same permissions assigned to the force.com site user.
I don't think it is the profile's permission because I have another VF page that displays record details just fine.