Mr Robot Comments - Answer Overflow

Topics

Mr Robot

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

Same goes for you!

60 replies

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

Yeah, no more errors and can log in. Thank you for the help!

60 replies

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

Nice all working now|

60 replies

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

Again happy to delete all

60 replies

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

immich=# select * from user_shared_album;
 id |               albumId                |             sharedUserId             
----+--------------------------------------+--------------------------------------
  1 | f02e6bf1-573b-4816-bfe7-15be73ce9c98 | 607abeb9-6886-4483-afb6-dac18098a155
  2 | ed1b3fce-2f10-4110-9cb6-f0b5d6119382 | dc4bf3ef-8b9a-4621-805f-9fcd154d4276
  3 | a00b56a9-7c6e-4ad0-994e-a043d9448d47 | 607abeb9-6886-4483-afb6-dac18098a155
  4 | a00b56a9-7c6e-4ad0-994e-a043d9448d47 | dc4bf3ef-8b9a-4621-805f-9fcd154d4276
  5 | a00b56a9-7c6e-4ad0-994e-a043d9448d47 | 4311fdcf-09ee-451c-84ea-bf3f5d9717c2
  6 | fcfec920-bf05-4032-b8da-3e544ada163a | 607abeb9-6886-4483-afb6-dac18098a155
  7 | fcfec920-bf05-4032-b8da-3e544ada163a | dc4bf3ef-8b9a-4621-805f-9fcd154d4276
  8 | fcfec920-bf05-4032-b8da-3e544ada163a | 4311fdcf-09ee-451c-84ea-bf3f5d9717c2
  9 | faae0d7a-fdf3-46b7-a786-8cb75ee95f42 | dc4bf3ef-8b9a-4621-805f-9fcd154d4276
 10 | faae0d7a-fdf3-46b7-a786-8cb75ee95f42 | 607abeb9-6886-4483-afb6-dac18098a155
 11 | faae0d7a-fdf3-46b7-a786-8cb75ee95f42 | 4311fdcf-09ee-451c-84ea-bf3f5d9717c2
(11 rows)

immich=#

immich=# select * from user_shared_album;
 id |               albumId                |             sharedUserId             
----+--------------------------------------+--------------------------------------
  1 | f02e6bf1-573b-4816-bfe7-15be73ce9c98 | 607abeb9-6886-4483-afb6-dac18098a155
  2 | ed1b3fce-2f10-4110-9cb6-f0b5d6119382 | dc4bf3ef-8b9a-4621-805f-9fcd154d4276
  3 | a00b56a9-7c6e-4ad0-994e-a043d9448d47 | 607abeb9-6886-4483-afb6-dac18098a155
  4 | a00b56a9-7c6e-4ad0-994e-a043d9448d47 | dc4bf3ef-8b9a-4621-805f-9fcd154d4276
  5 | a00b56a9-7c6e-4ad0-994e-a043d9448d47 | 4311fdcf-09ee-451c-84ea-bf3f5d9717c2
  6 | fcfec920-bf05-4032-b8da-3e544ada163a | 607abeb9-6886-4483-afb6-dac18098a155
  7 | fcfec920-bf05-4032-b8da-3e544ada163a | dc4bf3ef-8b9a-4621-805f-9fcd154d4276
  8 | fcfec920-bf05-4032-b8da-3e544ada163a | 4311fdcf-09ee-451c-84ea-bf3f5d9717c2
  9 | faae0d7a-fdf3-46b7-a786-8cb75ee95f42 | dc4bf3ef-8b9a-4621-805f-9fcd154d4276
 10 | faae0d7a-fdf3-46b7-a786-8cb75ee95f42 | 607abeb9-6886-4483-afb6-dac18098a155
 11 | faae0d7a-fdf3-46b7-a786-8cb75ee95f42 | 4311fdcf-09ee-451c-84ea-bf3f5d9717c2
(11 rows)

immich=#

60 replies

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

I have shared and album with them though

60 replies

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

immich=# DELETE
immich-# FROM users
immich-# WHERE id = '607abeb9-6886-4483-afb6-dac18098a155';
ERROR:  update or delete on table "users" violates foreign key constraint "FK_543c31211653e63e080ba882eb5" on table "user_shared_album"
DETAIL:  Key (id)=(607abeb9-6886-4483-afb6-dac18098a155) is still referenced from table "user_shared_album".
immich=#

immich=# DELETE
immich-# FROM users
immich-# WHERE id = '607abeb9-6886-4483-afb6-dac18098a155';
ERROR:  update or delete on table "users" violates foreign key constraint "FK_543c31211653e63e080ba882eb5" on table "user_shared_album"
DETAIL:  Key (id)=(607abeb9-6886-4483-afb6-dac18098a155) is still referenced from table "user_shared_album".
immich=#

60 replies

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

Lovely I'll do that now

60 replies

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

I can remove both and add back if need be

60 replies

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

Correct

60 replies

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

No description

60 replies

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

exactly that?

60 replies

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

the ones ending in 6 and 5

60 replies

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

I can see the one that says deleted at and is 2022-11-10

60 replies

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

No description

60 replies

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

and to drop by auth id?

60 replies

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

How do I list users?

60 replies

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

currently here

60 replies

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

No description

60 replies

•Created by Mr Robot on 12/22/2022 in #help-desk-support

Issue after docker update on Unraid

I'm in the databse I can see the tables but how do I see the users and remove the correct one?

60 replies