Wix Table crashes with wrong data in database

Discussion Ask a question
,
1

Hi Wix team,

I have a database and a wix table where i show a tumbnail of an uploaded image in one column of the table. This thumbnail image link is added to the database programatically using a string operations and some times this string operation fails and adds wrong link to the database and instead of entering a image link it just enters the half link string of the uploaded image to the database and shows a broken image thumbnail in the database viewer. And this will crash the entire table and will effect all the other data entered to the table.

So the idea and my suggestion is that : If some exception or error happens in one raw of the database, the database and the table should be intelligent to handle the exception and only that raw should be crashed or displayed as error in the table and this should not effect the other rows on the table.

For example, pic 1 is the uploaded image by the user and i am doing string operations to remove the unwanted parts of the pic1 image link and copying it into the tableimage column for the thumbnail.

2

Hey,
Thanks for your suggestion.
In the meantime, you can achieve that yourself by adding a verification for the values in onDataChange() .

3

Hey,
Thanks for your quick reply. I will try to implement it on my website.

I have one more issue related to the database since 1 month and I haven’t got any positive solution from anyone till now.
You can follow my questions asked on this forum using this link:(just search for my username nithinpanand to find my posts on First and Third Post)

First Post : https://www.wix.com/code/home/forum/questions-answers/programmatically-change-the-read-write-access-of-a-dataset

Second Post: https://www.wix.com/code/home/forum/questions-answers/wix-database-new-command-not-working-with-slideshow-bug

Third post with a video of the issue : https://www.wix.com/code/home/forum/questions-answers/problem-with-the-permission-read-and-write

Please help me to solve this issue also. Thanks.

4

Hey Ohad,
Can you help me program the logic of verification of values? I am stuck without knowing what to do regarding my initial table related question.

And regarding my issue with database, it would be nice if you acknowledge if its a bug or at least say what i am doing wrong.

5

Hi,
You can try finding your answer at: