update on my previous post re database collection

I’ve set up a database which users of a site can upload text and images to.
Database seems to work ok and saves data etc.

Ive set up a dynamic item page to display the data uploaded by a site user.

Finally i’ve set up an index page with a table on it to display the list of things uploaded to the database so that a user could click on an item in the list and be taken to the dynamic page. In preview this works fine but when published the index table shows no data.
If I go to the wix dashboard and look at the live database it shows info uploaded by the user ok.

Anyone any ideas as to whats stopping the index table showing the data uploaded when the site is published.

Cheers

HI, please check collection permission or define site url to review.