Why is my collection not loading?
The Collection may not load because some of its content is in a status other than published.
This query lets you examine your collection by listing its content. Update the nav_id value to the collection ID (available in the collection properties).
SELECT content_id,content_status,content_type,end_date,* FROM content WHERE content_id in (select content_id from nav_to_content_tbl WHERE nav_id = 4 AND content_language = 1033)