Settings page throws exception

[gerroon]

MultipleObjectsReturned at /settings/

get() returned more than one UserPreferenceModel -- it returned 2!

Request Method: GET
Request URL: http://192.168.1.100:8001/settings/
Django Version: 2.1.4
Exception Type: MultipleObjectsReturned
Exception Value:

get() returned more than one UserPreferenceModel -- it returned 2!

Exception Location: /media/VIDEO/ytsm/.env/lib/python3.7/site-packages/django/db/models/query.py in get, line 403
Python Executable: /media/VIDEO/ytsm/.env/bin/python3
Python Version: 3.7.2
Python Path:

['/media/VIDEO/ytsm/app',
'/usr/lib/python37.zip',
'/usr/lib/python3.7',
'/usr/lib/python3.7/lib-dynload',
'/media/VIDEO/ytsm/.env/lib/python3.7/site-packages']

Server time: Mon, 31 Dec 2018 02:59:50 +0000

[chibicitiberiu]

That's odd, it seems that the django_dynamic_preferences module messed up somehow and added 2 entries for the same preference for the same user. To fix this issue, you should manually edit the database using an SQLite editor tool. If it happens again, it might be a bug in django_dynamic_preferences, and we should discuss with them.

[gerroon]

thanks I will try it

[gerroon]

So what do I do witht he sql database editor to remove this error? I do not know what I am going to edit. I cant seem to save settings

[chibicitiberiu]

Sqlite editor, not just sql. Basically, look in the 'dynamic user preferences' table for a duplicated entry. If you have multiple users set up, you should have entries for each preference for each user. I can help you spot it, if you post a screen shot or a table dump.

…

On Mon, Dec 31, 2018, 21:48 gerroon ***@***.*** wrote: So what do I do witht he sql database editor to remove this error? I do not know what I am going to edit. I cant seem to save settings — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#55 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AE8dkQMF3L9ocYE44skriRATuLpXq-uAks5u-mocgaJpZM4ZlK1o> .

[gerroon]

See this

Not sure how I delete those, I do not see a delete button anywhere

[chibicitiberiu]

mark_deleted_as_watched and download_autogenerated_subtitles seem to be the problem. Make a backup of the database just in case, and delete the duplicates. See if you can access settings after that.

[gerroon]

ok initial test works after the edit