💜Clari Posts - Answer Overflow

💜Clari

Explore posts from servers

•Created by 💜Clari on 3/28/2025 in #help-desk-support

Account-Based Permissions Query

I have a bit of a weird question here. So I am trying to use Immich with my team, but I need to avoid creating accounts as much as possible, because if people have to have their own accounts, they won't want to manage it (plus we still have to share albums individually) So anyways, my ideal setup looks something like this: - I can log into the admin account where I can do everything as normal - My team members can log into a secondary account. This account needs to have full view access to albums and photos (currently achieving this with a "guest" account that I've shared the password for). It also needs to be able to upload images or create albums, but not modify or delete images/albums. Is there any way at all to achieve this? Kind of a very particular question but just thought I'd put it out there

15 replies

IImmich

•Created by 💜Clari on 12/18/2024 in #help-desk-support

Sync only certain albums

I want everything in my Camera album to back up to Immich, but without adding to a Camera album. However, I want my Screenshots album to also back up, but all of those pics should be added to a Screenshots album; since I don't usually want to keep most of my screenshots, this would make it a bit easier to keep track of those for when I get around to pruning them. If I enable the Sync albums option in the phone app settings, it'll add the Camera items to Camera, which I'd like to avoid. Is there a way to accomplish this?

6 replies

PPrisma

•Created by 💜Clari on 7/31/2024 in #help-and-questions

Removing enum value fails on foreign key

I'm getting the below error when i try to remove an enum value from the database

Error: P3006

Migration `20240731215417_drop_rqi_enum_val` failed to apply cleanly to the shadow database. 
Error:
db error: ERROR: foreign key constraint "Notification_certificationType_profileId_fkey" cannot be implemented
DETAIL: Key columns "certificationType" and "code" are of incompatible types: "CertificationType" and "CertificationType_new".
   0: sql_schema_connector::validate_migrations
           with namespaces=None
             at schema-engine/connectors/sql-schema-connector/src/lib.rs:312
   1: schema_core::state::DevDiagnostic
             at schema-engine/core/src/state.rs:270

Error: P3006

Migration `20240731215417_drop_rqi_enum_val` failed to apply cleanly to the shadow database. 
Error:
db error: ERROR: foreign key constraint "Notification_certificationType_profileId_fkey" cannot be implemented
DETAIL: Key columns "certificationType" and "code" are of incompatible types: "CertificationType" and "CertificationType_new".
   0: sql_schema_connector::validate_migrations
           with namespaces=None
             at schema-engine/connectors/sql-schema-connector/src/lib.rs:312
   1: schema_core::state::DevDiagnostic
             at schema-engine/core/src/state.rs:270

5 replies

PPrisma

•Created by 💜Clari on 4/23/2024 in #help-and-questions

offset-based pagination in a field with a relation

            let item = await prisma.item.findFirstOrThrow({
                where: {
                    id: req.params.id
                },
                include: {
                    updates: {
                        skip: +req.params.page * pageSize || 0,
                        take: pageSize
                    }
                }
            });

            let item = await prisma.item.findFirstOrThrow({
                where: {
                    id: req.params.id
                },
                include: {
                    updates: {
                        skip: +req.params.page * pageSize || 0,
                        take: pageSize
                    }
                }
            });

Essentially, I have a schema with updates ItemUpdate[], and I need to fetch its updates, but i want to paginate it. i know i can just do prisma.itemUpdates.fetchMany, but I want to be able to return a 404 when the item ID is not found - and it's possible for the item to exist without any updates - and i can't check that if i'm simply using a where { itemId } in an itemUpdates call so, is this valid? ^^^

1 replies

Gaming

Programming