PiGallery2

--------------------------------------------------------------------------------- **Describe the bug** I'm trying to create a user that only has access to two folders, and I'm doing so via the `Allow query` option in the user details, specifying the query like this: `directory:Games or directory:Shows`. Upon trying to log in with that user, the images don't load, and I can see a SQL error saying that the column "directory.path" doesn't exist. I'm using mysql, but that happens with sqlite too. The query works as normal in the query input box at the top of the page. **Screenshots (optional)** shot of the user configuration: <img width="793" height="653" alt="Image" src="https://github

Fix for issue https://github.com/bpatrik/pigallery2/issues/1128 Replaces non-zeropadded hours (regardless of - or +) with zero-padded hours. Also adds a unit test on a file with the same metadata as provided in the pixel-photo by @tropicalsriracha in [this comment](https://github.com/bpatrik/pigallery2/issues/1128#issuecomment-3866367788)

**Note:** Please always try reproducing the issue on the `:edge` build. There is a chance that it was already fixed. If it's an UI issue, you can try reporducing it on the [demo page](https://pigallery2.onrender.com/). ---------------------------------------------------------------------------------- **Describe the bug** Attempt to install any of the extensions made available in the UI fails with the following errors: ``` {"log":"1/27/2026, 8:22:59 PM[\u001b[35mSILLY\u001b[0m][ExtensionManager] Downloading extension from https://github.com/bpatrik/pigallery2-sample-extension/archive/refs/heads/main.zip to /app/data/config/extensions/sample-extension.zip\n","stream":"stdout","time":"2026

### Discussed in https://github.com/bpatrik/pigallery2/discussions/852 <div type='discussions-op-text'> ^{Originally posted by **gerroon** March 10, 2024} Hi I have folders with folders with thousands of files in them. When I do ungroup directory flattening, I small number of files shown as result. Say 80 files out of 20k or sometimes flattening shows none. It seems to me that it is not recursing deep into folders. Now I set my max media search result to 4000, so it cant be that. This used to work but I do not remember at what point this has changed. I use docker :latest on Linux. So here is a folder without flattening, this folder probably has o

If you have any symlinks in the photos directory (Images folder) you get the following error in the UI: ``` Unknown indexing error for: ./ "[object Object]" ``` Errors from the logs (from docker logs, I'm using the docker image): ``` 1/23/2019, 12:19:26 AM[WARN] Handled error: ErrorDTO { code: 7, message: 'Error during listing the directory', details: { error: 'Error: ENOENT: no such file or directory, stat \'/pigallery2-release/demo/images/convert_video_to_MP4.sh\'' } } { error: 'Error: ENOENT: no such file or directory, stat \'/pigallery2-release/demo/images/convert_video_to_MP4.sh\'' } 1/23/2019, 12:19:26 AM[WARN] Handled error: ErrorDTO { code: 7,

**Is your feature request related to a problem? Please describe.** I'm looking for a setting if it exists, if not then a feature request or instructions on how to enable video playing on hover. **Describe the solution you'd like** Have the video play while hovering the thumbnail in gallery view. **Describe alternatives you've considered** (optional) Immich is the closest thing off the top of my head that I know does this and its very useful and smooth.

### Discussed in https://github.com/bpatrik/pigallery2/discussions/1100 <div type='discussions-op-text'> ^{Originally posted by **barncrow** December 19, 2025} As in the screenshot below, tags that consist of only numbers are being displayed twice in the info panel. I've checked the metadata (in Digikam, which I also use to write the tags) and see no indication that these tags are being written twice. Has anyone else seen this? Any ideas how to trouble-shoot? <img width="318" height="253" alt="image" src="https://github.com/user-attachments/assets/c0825475-306d-40ab-9d65-647e773149ff" /> </div>

I self host a bunch of services including pigallery2, and utilise Authelia for SSO. Is there any intention of integrating with something like Authelia? Authelia provides authentication services for services, and only after authentication will it allow requests through to back end web services. This stops the 'double login' when a user has to login pass Authelia, then a login for pigallery2. I know you can turn off authentication to pigallery2 but you need this for album sharing. Would a possible solution be to allow Authelia to pass the user via a header of 'Remote-User' - if this matches a registered pigallery2 user, assume this is 'authenticated'? This will possible also allow other si

Hello Is it possible to add DNG support? Each DNG has embedded preview, so I think, it will be not very resource "hungry" for RPI to show this preview without real-time rendering :) Thanks for your wonderful app!