Hide Faces Feature
I accidentally hid some faces with the new Show & Hide faces feature and i want to get them back.
30 Replies
Do you have more than 500 faces ?
probably yea
Unfortunately for now, there’s not straightforward solution and you have to update manually your database
is there a fix in the foreseeable future
Of course !
It’s the number 4.a here
GitHub
[Feature] Facial Recognition Enhancements · immich-app immich · Dis...
(Parent discussion for FR enhancements) Summary: 1. Ability to show/hide faces (similar to google photos) (#3262) 2. Option to select an alternative person thumbnail (similar to google photos) (#30...
good to hear that thank you very much!
You’re welcome 😁
When does the bug get fixed?
🤷🏻♂️
Coult you show me were i find the instruction to manually edit the database
Do you have some experience with postgres and psql ?
yea a little
i think i already know enough. i used dbeaver software to edit databases.
Nice
Should be easy with dbeaver
Connect to your immich database, go to the "person" table
All the people you hid have the isHidden row set to
true
If you have set a name to the person you accidentally hid, it should be easy to findthanks. do you know what the credentials for the database are
If you didn't set a name, my recommendation would be to set
false to all isHidden entries
No, but you can find it in your .env file 😉
If you didn't change it, the username and password should be postgresstill cant connect, also treid the hostname from the .env file. any tipps
Yes don't use localhost
use directly your ip address
do you have any idea why i still doesnt work
Are you sure you used the correct password ?
yes i am
The issue still isnt resolved and i cant connect to the database could you take a look at that one more time?
Can you try to query your table in your Postgres docker ?
Normally the DB shouldnt be exposed to the outside by default
Probably the port isnt open, but you could temporarily change that
Can you explain how?
expose port 5432 on the postgres container in the docker-compose
like this?
environment:
POSTGRES_PASSWORD: ${DB_PASSWORD}
POSTGRES_USER: ${DB_USERNAME}
POSTGRES_DB: ${DB_DATABASE_NAME}
PG_DATA: /var/lib/postgresql/data
expose:
- "5432"
sorry the markdown editing kicks in
just use a raw block :')
should work, i would just use
should be the same though
thank you very much! mine didnt work but with your option it did