I'm trying to display content from my database in a repeater. I've already created a database, it is populated with some test data, added the repeater, connected the repeater to the database field I want to be displayed. However, when testing in preview or published, everything that I've connected just shows up blank. For example, if I want to display an image from the database in the repeater, all that displays is the background of where the image should be in both preview and published. I've followed all the steps in the following link: https://support.wix.com/en/article/displaying-database-content-in-a-repeater, yet still nothing shows. Database permissions are set to members only and I'm logged into the site.
As an aside, I can get data from the database to display in a gallery in the members area, so I know the database is working and can display data using other methods, but I can't solve this repeater issue. I'm presuming that this must be something incredibly simple that I'm missing here because I've been trying to get this working for hours with no luck. What am I doing wrong?
I figured it out with international Trading Commerce's post. From the site content manager, I selected Edit Settings on my collection. The under "What's this collection for?" I selected Custom Use. Then I "set custom permissions" as anyone for read and create and admin for changes and delete.
I'm having a similar problem, but mine displays in the preview but not on a live page after publishing. What gives?
I had the same problem. It is because most likely your database is set as "private data" therefore is not showing in your live page. You need to change the settings of the page as to "site data", this will solve your issue.
I was facing the same issue, But I simply took the repeater out from the grid and I worked for me. I don't know whether its a right way or not, but for time being you can try that.
Chris, reading your last posts I think I know your issue here.
I think that you are trying to connect your users input form and the repeater to the same dataset on your page.
Now yes in theory you are doing that with the form saving the users submission into your database and then the repeater showing the items in that database which you have in your site structure.
However, in practical terms you will need one dataset on your page for the form which would be form submission or write only for example.
Then you would need to add another dataset to your page and connect that to the same database, however this dataset would need to be read only so that it just displays items only.
@Yisrael (Wix) Please check to see if they are using the same dataset connection on their page.
With regards to your pic about your custom settings, if the repeater is for showing only, then why do you need the creating and updating sections to be member as well.
For that to happen, you would need to make the dataset read and write and not just read only.
The only one that should be changed from Admin if you are just displaying the images is the read top one.
I have just added a dataset with some tiger pics in and a repeater on a normal page and connected it all up and it works fine for me.
I have not changed the dataset settings itself, that is on Site Content still, you shouldn't need to change it to custom use if you are only displaying it to members when it is already on a members only page.
Check your dataset settings and make sure that it is set up with the right function of either read or read and write and not write.
https://support.wix.com/en/article/working-with-dataset-modes-and-collection-permissions
Hi, have you tried syncing sandbox to live?
On the Wix builder go to "content manager", then select your dataset.
After you finish adding content to the dataset, click on "Sync Sandbox to Live".
I hope this solves your problem.