Bug - Settings table not being populated correctly

[aptalca]

Hi,

I just created a container via compose, using PUID/PGID 1000 and using socket proxy via DOCKER_HOST.

Despite some error messages in the log about not being able to load /root/.docker/config.json due to permissions (expected and not needed) and the deprecated http2 directive, it starts and seems to run fine.

I am able to set update check frequency for all detected containers individually and in bulk.

However, any change I make on the Settings page, does not seem to save. I get the popup saying the save was successful, but on page refresh, all changes are reverted. I tried different settings, one at a time, to no avail.

i tried to look through the various logs but didn't see any errors.

Please let me know what other information you need to troubleshoot.

Thanks

[nzxl101]

Might be another case of database creation failing
Try deleting the database/dockwatch.db file and refresh page, it should auto-generate back with the correct permissions and data

[austinwbest]

A copy of the broken db might be helpful to try and see which field(s) are causing the problem when it tries to save

[aptalca]

Thanks, that was it. I stopped the container, deleted the db, restarted and all is well.

I can share a copy of the old db but I need to figure out what to sanitize first.

[austinwbest]

Thanks, that was it. I stopped the container, deleted the db, restarted and all is well.

I can share a copy of the old db but I need to figure out what to sanitize first.

the db its self, only dockwatch apikeys i think would be in there in the servers table iirc

[aptalca]

A copy of the broken db might be helpful to try and see which field(s) are causing the problem when it tries to save

Here's the original db where the settings didn't save:
https://drive.proton.me/urls/9B15DZR3AC#5sDpzOtRTPKQ
(shared on proton as github only allows certain file types for upload)