Invalid date, failed to load assets
Hello uploaded my Google photos and I have about 166 photos out of 16999 that show invalid date and I get an error failed to load asset in tje ui.
They are just grey thumbnails that can't be clicked on or selected. How on earth can I fix or just remove these problem files.
Running in docker on unraid.
16 Replies
:wave: Hey @Exterma,
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.Hello, can you access the database and run the following query
Select a.id, a.”fileCreatedAt” from assets a where a.”fileCreatedAt” < “1900-01-01 00:00:00”
im not sure how to access database sorry im running in unraid tbh ive just deleted everything and starting again as i allowed immich go to upload google hpotos with missing json files maybe that caused it?
looks like i have 1273 fil;es with missing sidecar
Part of it, the other part is from the server, there is a problem with the database interpreting the date correctly but the timezone format is invalid in javascript
We will push out a fix later
so i should be able to upload images with missing json files and it be ok?
is it not possible to add a ui section that lists files with invalid data and allow you to edit or delete them from the ui to make it a bit more user friendly?
i also wonder why the android app only seems to show some of my pictures i would like to see all my photos on the server but it only seems to show up to 2021 when i have picture back to 2014 on the server.
im backing up my camera folder
Yeah the invalid date is causing issue with getting all assets on the mobile app
but wondered if immich can show "cloud" only files
This is planned
However this is fundamentally the issue with the server interpreting invalid date as literal invalid date without giving a fallback value
the server shows all the meta data no issues with those files i dont think
Yup, you can unselect all album for backup so your instance will show remote only file
seems to be mostly pictures i uploaded straight into the ui from onedrive so they are just .jpg files they show absolutly fine on the webui though
but if i select a folder it only shows pictures uploaded from that?
Correct
is there anyway to change that behaviour i want to upload from my camera folder but still see all photos on the server like google photos allows me to if you know what i mean?
what does the sync albums option mean in app please thanks for your help
There is not, we plan to rework this
Upload then auto addingg the newly upload asset to the corresponding album
Thanks for info
No problem