How did you fix this exactly @brian?
I have the same problem.
My TOS page I created is showing in the Datastore but not in Browse existing pages.
Not sure when this happened as it was showing.
Check in the jr_jrpage_item_key table, and look for the "key" called page_location - it should be set to "1" if the page shows on a profile, or "0" if the page shows on the site. In this instance all the pages that were supposed to show on the site had a value of "Show Page on Main Site" instead of "0" (in other words they had the text
of the select item instead of it's value). So first up, just change those entries to 0.
Then, go into the jr_jrcore_form table and find the entry for jrPage -> page_location (in the "module" and "name" columns) and make sure the "options" column is set to:
["Page is visible on Main Site","Page is visible on Profile"]
anything else is wrong.
I'm not sure how it was setup wrong, but I suspect a very early version of the module was using the wrong data structure for the options array.
Hope this helps!
Founder and Lead Developer - Jamroom
updated by @brian: 03/18/14 06:04:30AM