Data disappearing

[PerpSearch]

I created a collection of items that included 10 data fields that included an image and a $ value. It took several hours to enter 328 records into the database. Occasionally I had to go back and enter some I skipped, but once done it felt pretty good to move from the spreadsheet to Koillection.

I know everything was entered after a while because I went back and checked for missing data points against my spreadsheet. A few hours later I happened to check and found 9 records that had data missing. There seemed to be no commonality in the records, but as I re-entered the data I was able to confirm that it was there before when I had assumed it was my oversight. It wasn't.

The log has 41 lines similar to the following:

[notice] Migration App\Migrations\Mysql\Version20230525100104 skipped during Execution. Reason: "Migration can only be executed safely on 'mysql' or 'mariadb'."

and one of these

[24-Mar-2024 19:22:36] NOTICE: PHP message: PHP Warning: Can't preload unlinked class Zenstruck\Foundry\Factory@anonymous: Unknown parent Zenstruck\Foundry\Factory in /var/www/koillection/vendor/zenstruck/foundry/src/functions.php on line 45

if that's of any help.

I'm running this in a docker container on a Synology DS723+ having used the tutorial provided here. I do like the program, but I worry about it's dependability now. I'm willing to provide the complete log(s) if it's be helpful.
Thanks.

[benjaminjonard]

Which version of Koillection do you use ?
Alse when you first added the missing data, did you apply a template or change the fields positions ?

The two logs messages can be safely ignored. I need to find a way to hide them as they appear for everyone and are irrelevant

[benjaminjonard]

Thanks, if you could also provide a screenshot of the "Mat shape" choice list that would be great. I'll try to reproduce the issue tomorrow

[benjaminjonard]

Ok I may have found it. Have you made any change in the choice list ? I changed one entry in my list and it disappeared from my item like you. (the good news would be that the data is still present in the database)

[PerpSearch]

Yes I have done that, perhaps a couple of times. I'm actually still experimenting with the program features and settings so yeah. The good news is that you've actually been able to replicate it resolve the issue or tell me what to do differently. Either way it's a win.
Cool.
Also, data loss is easily overcome by reentering it cuz there's not much there and I'm kind a done for a while, but a fix down the road would be great.

[benjaminjonard]

Yeah I fixed the issue, it will ship with the next release. Thank you very much for your help

[PerpSearch]

No, thank you for all you've done here. Later on we can talk about custom queries and reports ;) You have a link of some sort so I can buy you a coffee?

[benjaminjonard]

I haven't set up any links like that, but thanks for considering it, I appreciate it 👍

[PerpSearch]

I just updated to the new version and after I noticed 5 records out of 335 were missing data. The data fields that were zeroed out were all originally from a primary template. I've not noticed any commonality with the records that were affected as yet, but I'm certain they were there before. This is a small number of records, but I do back up the docker container twice a day to ensure I don't lose too much. Let me know what I can provide to help troubleshoot.

[benjaminjonard]

Well this is getting weird 😅 the last update had nothing to do with data fields.
Are those data fields choice lists again ?

[PerpSearch]

I see you did it and it looks great! I was just updating a few items and saw the update. Now I just have to change 6 fields in 330 records and find someone to share it with. Thanks again for dong this.