Closed rickysarraf closed 3 years ago
Yes. I can confirm now that it happens when clicking Data Viz => Social Graph
Can you execute the bellow query on postgres?
with face as (
select photo_id, person_id, name
from api_face join api_person on api_person.id = person_id
where person_label_is_inferred = false
)
select f1.name, f2.name
from face f1 join face f2 using (photo_id)
where f1.person_id != f2.person_id
group by f1.name, f2.name
Can you execute the bellow query on postgres?
with face as ( select photo_id, person_id, name from api_face join api_person on api_person.id = person_id where person_label_is_inferred = false ) select f1.name, f2.name from face f1 join face f2 using (photo_id) where f1.person_id != f2.person_id group by f1.name, f2.name
I hope this is what you expected me to execute.
root@dd0ef23a8d0f:/# psql librephotos docker -c 'with face as ( select photo_id, person_id, name from api_face join api_person on api_person.id = person_id where person_label_is_inferred = false ) select f1.name, f2.name from face f1 join face f2 using (photo_id) where f1.person_id != f2.person_id group by f1.name, f2.name'
name | name
------+------
(0 rows)
Great, there is no data. (you have not photo with 2 faces) i will fix this case with a PR. thanks
Perfect. I just started evaluating this software today. I'm glad I could be of help. :pray:
🐛 Bug Report
What Operating system and version is LibrePhotos running on:
Debian Unstable
What architecture is LibrePhotos running on:
x64
How is LibrePhotos installed:
Docker
If running via Docker or Kubernetes please list version including docker-compose:
3.8
Are you running LibrePhotos on a virtual machine if so please list:
No
How is you picture library mounted on the host (or in the virtual machine):
Local file system BTRFS
Description of issue:
Exception seen when doing some random operation on the UI
How can we reproduce it:
I think it triggered when clicking feature Social Graph