Missing Videos (maybe photos too) in Timeline - viewable still.

I am unable to click on or find several video files .mov in Immich. But when I went to upload them (thinking they were on the server), it find them as duplicate. I can open the duplicate and it will play the correct movie. However, I can't search for it or see it. In the library section of the GUI webpage, these files are also hidden. But if I view it via file explorer on the PC, they are findable there. Any ideas on a fix? TY
37 Replies
Immich
Immich3w ago
:wave: Hey @ike552552, Thanks for reaching out to us. Please carefully read this message and follow the recommended actions. This will help us be more effective in our support effort and leave more time for building Immich :immich:. References - Container Logs: docker compose logs docs - Container Status: docker ps -a docs - Reverse Proxy: https://immich.app/docs/administration/reverse-proxy - Code Formatting https://support.discord.com/hc/en-us/articles/210298617-Markdown-Text-101-Chat-Formatting-Bold-Italic-Underline#h_01GY0DAKGXDEHE263BCAYEGFJA Checklist I have... 1. :ballot_box_with_check: verified I'm on the latest release(note that mobile app releases may take some time). 2. :ballot_box_with_check: read applicable release notes. 3. :ballot_box_with_check: reviewed the FAQs for known issues. 4. :ballot_box_with_check: reviewed Github for known issues. 5. :ballot_box_with_check: tried accessing Immich via local ip (without a custom reverse proxy). 6. :ballot_box_with_check: uploaded the relevant information (see below). 7. :ballot_box_with_check: tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable (an item can be marked as "complete" by reacting with the appropriate number) Information In order to be able to effectively help you, we need you to provide clear information to show what the problem is. The exact details needed vary per case, but here is a list of things to consider: - Your docker-compose.yml and .env files. - Logs from all the containers and their status (see above). - All the troubleshooting steps you've tried so far. - Any recent changes you've made to Immich or your system. - Details about your system (both software/OS and hardware). - Details about your storage (filesystems, type of disks, output of commands like fdisk -l and df -h). - The version of the Immich server, mobile app, and other relevant pieces. - Any other information that you think might be relevant. Please paste files and logs with proper code formatting, and especially avoid blurry screenshots. Without the right information we can't work out what the problem is. Help us help you ;) If this ticket can be closed you can use the /close command, and re-open it later if needed.
userless
userless3w ago
Hello. Can you check if the missing assets are visible in the Folder View? https://docs.immich.app/features/folder-view/
ike552552
ike552552OP3w ago
They are not.
userless
userless3w ago
Understood. Since my issue had different symptoms, my solution won't work in your case. I'd recommend taking your problem to a GPT chat (that's how I solved my own issue), as proper diagnosis will require console access and admin rights to the web application. However, this approach requires some specific knowledge: • Database Fundamentals: Understanding what database tables, columns, and records are. • Data Relationships: Knowing how data in one table can be linked to another. • System Investigation: The ability to explore and describe this structure - like finding and listing table names or checking specific records. Your goal would be to have GPT help you formulate the right questions and queries, such as: 'How can I find which database table stores the asset metadata?' or 'What SQL query would list all assets not assigned to any folder?'
Mraedis
Mraedis3w ago
Are they archived @ike552552 ?
ike552552
ike552552OP3w ago
Sorry for the delay. Mraedis, they are not archived. When I use the folder view they do not show. Just when I get a link to them when I try to re upload them. Its then that the system recognizes it as a duplicate and shows me a link to the file.
Mraedis
Mraedis3w ago
Are you running the storage templating @ike552552 If yes, run the migration job first
ike552552
ike552552OP3w ago
Yes. And I will do. You mean just manually run the jobs, right?
Mraedis
Mraedis3w ago
Yes the storage migration one @ike552552 It's definitely weird because it's hitting the dupe check so it can't be a shared asset
ike552552
ike552552OP3w ago
That didn't fix it. In fact I blieve this issue has been around for a while I just hadn't noticed. Some of my favorite videos I assume I lost. They were just not showing in Immich.
Mraedis
Mraedis3w ago
If you navigate to one, what does it say the date is?
ike552552
ike552552OP3w ago
Like I said, I can only have it play in Immich if I click the duplicate link when I try to re-upload it. I will see.
ike552552
ike552552OP3w ago
No description
ike552552
ike552552OP3w ago
I wanna say I used takeout helper and the immich mover thingy to import all of them into Immich. I am actually not sure If I've ever seen these files on immich. When I click the link show on timeline - it obivously doens't take me there. Would there be a log somewhere for that event that would help?
Mraedis
Mraedis3w ago
docker compose logs would show anything relevant about duplicates Does it show a storage location? It should if it's your own asset
ike552552
ike552552OP3w ago
I'm not sure what you mean. Neither files i can see on Immich or the videos we are discussing have a path in the information section in Immich. Not showing in the folder within immich either. If it helps, I have this installed as a LXC dockge using TTeck scripts.
Mraedis
Mraedis3w ago
No description
Mraedis
Mraedis3w ago
this shows the location on disk
ike552552
ike552552OP3w ago
lmao kk lemme check sorry Yes, It says it has the location,. And if you click the link to location -poof. It aint there. admin/2021/2021-12-03/IMG_0914+1.mov
Mraedis
Mraedis3w ago
If you ls -la /path/on/host/admin/2021/2021-12-03/IMG_0914* does it show multiples?
ike552552
ike552552OP3w ago
I am not sure where to send this command given my setup. I am running on an LXC which is installed via TTeck Scripts. If i look for the files in the console of the LXC, I can't find that directory. So I am goofing up something. Yes, and xmp and a .mov file.
ike552552
ike552552OP3w ago
Pastebin
root@dockge:/opt/dockge# ls -la /mnt/PD1/library/admin/2021/2021-12...
Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.
Mraedis
Mraedis3w ago
Are you uploading folders or individual movies? Just thinking now that maybe the duplicate was not inside of immich at that time @Sergey Katsubo do you know whether the DB has upload date stored somewhere?
Sergey Katsubo
"asset.createdAt" - timestamp of upload to the server If photo view has url like https://my.immich.app/photos/LONG-UUID-HERE then try opening its metadata directly in browser as https://my.immich.app/api/assets/LONG-UUID-HERE (replace photos with api/assets in the url)
Mraedis
Mraedis3w ago
stupid me trying to use psql queries for this 😛
Sergey Katsubo
To me it resembles behavior of trashed assets: - not displayed in Timeline or in Folder View - reported as duplicate nonetheless - can be viewed directly - from the duplicate error message/link (or from Trash) @ike552552 I'd suggest these steps: 1. Check trash If it's not there, then 2. 2. As described above, modify its URL to be like https://my.immich.app/api/assets/LONG-ID-HERE, then copy its content (JSON) and post it here. You can remove sensitive info such as email.
ike552552
ike552552OP2w ago
Thank you guys for following up. I lost a little hope and got busy. id "84289fb3-e829-40ac-b663-6301348f3220" createdAt "2024-12-18T15:48:12.613Z" deviceAssetId "IMG_0914.MOV-205667223" ownerId "~" owner
id "~" email "~" name "~" profileImagePath "" avatarColor "blue" profileChangedAt "2024-12-18T12:01:47.08743+00:00" deviceId "~" libraryId null type "VIDEO" originalPath "/usr/src/app/upload/library/admin/2021/2021-12-03/IMG_0914+1.mov" originalFileName "IMG_0914.MOV" originalMimeType "video/quicktime" thumbhash "oAgKJASY6If3d4hHOEmIcIEINw==" fileCreatedAt "2021-12-03T08:09:24.000Z" fileModifiedAt "2021-12-03T08:09:24.000Z" localDateTime "2021-12-03T08:09:24.000Z" updatedAt "2025-11-06T19:29:54.526Z" isFavorite false isArchived false isTrashed false visibility "hidden" duration "00:00:21.278" exifInfo
make "Apple" model "iPhone 11" exifImageWidth 3840 exifImageHeight 2160 fileSizeInByte 205667223 orientation "6" dateTimeOriginal "2021-12-03T08:09:24+00:00" modifyDate "2021-12-03T08:09:24+00:00" timeZone "UTC+3" lensModel null fNumber null focalLength null iso null exposureTime null latitude null longitude null city null state null country null description "" projectionType null rating null livePhotoVideoId null tags [] people [] unassignedFaces [] checksum "~" stack null isOffline false hasMetadata true duplicateId null resized true So i do notice it says "visibility hidden". I believe this article was uploaded in mass directly using the upload feature on the GUI. I probably "selected all" items within a folder. id "" createdAt "2024-12-18T15:34:31.342Z" deviceAssetId "IMG_0398.MOV-151249240" ownerId "" owner
id "" email "" name "" profileImagePath "" avatarColor "blue" profileChangedAt "2024-12-18T12:01:47.08743+00:00" deviceId "" libraryId null type "VIDEO" originalPath "/usr/src/app/upload/library/admin/2021/2021-12-03/IMG_0398+1.mov" originalFileName "IMG_0398.MOV" originalMimeType "video/quicktime" thumbhash null fileCreatedAt "2021-12-03T11:30:01.000Z" fileModifiedAt "2021-12-03T11:30:01.000Z" localDateTime "2021-12-03T11:30:01.000Z" updatedAt "2025-10-01T01:43:01.130Z" isFavorite false isArchived false isTrashed false visibility "hidden" duration "00:00:16.425" exifInfo
make "Apple" model "iPhone 11" exifImageWidth 3840 exifImageHeight 2160 fileSizeInByte 151249240 orientation "1" dateTimeOriginal "2021-12-03T11:30:01+00:00" modifyDate "2021-12-03T11:30:01+00:00" timeZone "Asia/Riyadh" lensModel null fNumber null focalLength null iso null exposureTime null latitude -2.5058 longitude 34.8518 city null state null country "United Republic of Tanzania" description "" projectionType null rating null livePhotoVideoId null tags [] people [] unassignedFaces [] checksum "`" stack null isOffline false hasMetadata true duplicateId null resized true Similar asset with different updatedAT value.
Sergey Katsubo
Thank you. visibility: hidden is valuable observation. Usually the video part of live photos has "hidden" status because the photo+video parts are handled as a single entity. Such videos typically has short duration like 2 seconds. But two examples above are much longer: 15-20 sec. Have you ever been using immich-go to upload your files? If so then you may want to have a look at https://github.com/immich-app/immich/issues/14107, last comment summaries that long discussion.
Immich
Immich2w ago
[Issue] Certain videos are missing from the timeline, despite successful upload (immich-app/immich#14107)
Sergey Katsubo
If you can access the database then please run the following query to see which long videos (4 sec or more) are linked as live photo video parts
SELECT a.id img, a."originalFileName" img_name, v.id vid, v."originalFileName" vid_name, v.visibility vid_vis, v.duration FROM asset a JOIN asset v ON a."livePhotoVideoId" = v.id WHERE v.duration > '00:00:04';
SELECT a.id img, a."originalFileName" img_name, v.id vid, v."originalFileName" vid_name, v.visibility vid_vis, v.duration FROM asset a JOIN asset v ON a."livePhotoVideoId" = v.id WHERE v.duration > '00:00:04';
Example output on my test instance (I queried for shorter duration of 2 sec because I have only proper/short live video parts)
immich=# SELECT a.id img, a."originalFileName" img_name, v.id vid, v."originalFileName" vid_name, v.visibility vid_vis, v.duration FROM asset a JOIN asset v ON a."livePhotoVideoId" = v.id WHERE v.duration > '00:00:02';
img | img_name | vid | vid_name | vid_vis | duration
--------------------------------------+----------------------------------------+--------------------------------------+----------------------------------------+---------+--------------
7b1c1581-e31e-4843-be5e-421221031108 | IMG_3919.heic | 00599cf3-cfe5-48da-b99a-48c7f7355553 | IMG_3919.mov | hidden | 00:00:02.293
c653c695-8529-4db5-b1fc-de757a15e6e5 | IMG_3982.heic | 0dc8280e-51b3-4ede-a07a-3d5a9ec5f89f | IMG_3982.mov | hidden | 00:00:02.153
d24dd6bd-1b22-4955-89eb-a015f81a58b6 | Motion Apple iPhone 15 - photo.HEIC | 7027fbd5-e9a0-4f33-9cbb-
immich=# SELECT a.id img, a."originalFileName" img_name, v.id vid, v."originalFileName" vid_name, v.visibility vid_vis, v.duration FROM asset a JOIN asset v ON a."livePhotoVideoId" = v.id WHERE v.duration > '00:00:02';
img | img_name | vid | vid_name | vid_vis | duration
--------------------------------------+----------------------------------------+--------------------------------------+----------------------------------------+---------+--------------
7b1c1581-e31e-4843-be5e-421221031108 | IMG_3919.heic | 00599cf3-cfe5-48da-b99a-48c7f7355553 | IMG_3919.mov | hidden | 00:00:02.293
c653c695-8529-4db5-b1fc-de757a15e6e5 | IMG_3982.heic | 0dc8280e-51b3-4ede-a07a-3d5a9ec5f89f | IMG_3982.mov | hidden | 00:00:02.153
d24dd6bd-1b22-4955-89eb-a015f81a58b6 | Motion Apple iPhone 15 - photo.HEIC | 7027fbd5-e9a0-4f33-9cbb-
To open the database from command line / terminal https://docs.immich.app/guides/database-queries/
docker exec -ti immich_postgres psql -U postgres -Ppager=no -d immich
docker exec -ti immich_postgres psql -U postgres -Ppager=no -d immich
You can also try this workaround https://github.com/immich-app/immich/issues/14107#issuecomment-2478086822
Immich
Immich2w ago
[Issue] Certain videos are missing from the timeline, despite successful upload (immich-app/immich#14107)
ike552552
ike552552OP2w ago
I did use immich-go. This sounds like my issue. But you are correct my concern is for videos that are longer duration. On a seperate note - often when I hover over what was a "live" photo, immich shows a completely unrelated video. 876 rows following those instructions. 1250 rows if i run it as 2seconds So your suggesting these files have been marked by immich go as "live" and there the video has been "hidden" per say from view.
Sergey Katsubo
yes
ike552552
ike552552OP2w ago
anyway to clean this up for a big list? will close ticket after reply
Sergey Katsubo
I'm not an expert in live photos, so take the following with the grain of salt. AFAICT several issues may arise due to immich-go auto-linking similarly looking photo and video files. Let's look at all possible combinations: 1. Orig photo IS NOT live photo + orig mov IS NOT live video 2. Orig photo IS live photo + orig mov is NOT live video The cases (1) and (2) are covered by the sql query above WHERE v.duration > '00:00:04'. 3. Orig photo IS NOT live photo + orig mov IS live video 4. Orig photo IS live photo + orig mov IS live video, but they belong to different live photo pairs 5. Orig photo IS live photo + orig mov IS live video and they are actually the parts of the same live photo (good, non-issue). The cases (3) and (4) cover your another issue:
On a seperate note - often when I hover over what was a "live" photo, immich shows a completely unrelated video.
Therefore the safest option - if you still have originals somewhere (or you can copy them from the Immich storage/disk) - is to purge them from Immich and re-upload (with auto-linking disabled in immich-go). Immich will correctly link them based on a special ID in metadata: ContentIdentifier (CID) metadata field which is set by iOS. Alternatively, we can probably develop an SQL query to "unlink" those files. Then, upon re-running the metadata extraction job, Immich hopefully can link them properly. This is just a brainstorming idea (manipulating the database in such a manual way is not officially supported).
ike552552
ike552552OP2w ago
THank you very much! Very helpful.
Immich
Immich2w ago
This thread has been closed. To re-open, use the button below.

Did you find this page helpful?