Immich•2d ago

Change date bug?

Hi all Got a lot of pictures created the same day with an error in the date (my camera was wrong date). I've selected the pictures on immich, check "change date", and ask to add 12hours to all pictures. I got this error on web app : Failed to update assets (Immich Server Error) And on the logs (in other post.. too long)

9 Replies

Immich•2d ago

:wave: Hey @BRO_OuafnicO, 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.

BRO_OuafnicOOP•2d ago

Query failed : {
  durationMs: 3.5422980000148527,
  error: PostgresError: syntax error at or near ")"
      at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)
      at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6)
      at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9)
      at Socket.emit (node:events:518:28)
      at addChunk (node:internal/streams/readable:561:12)
      at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
      at Readable.push (node:internal/streams/readable:392:5)
      at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
      at TCP.callbackTrampoline (node:internal/async_hooks:130:17) {
    severity_local: 'ERROR',
    severity: 'ERROR',
    code: '42601',
    position: '117',
    file: 'scan.l',
    line: '1176',
    routine: 'scanner_yyerror'
  },
  sql: 'update "asset_exif" set "dateTimeOriginal" = "dateTimeOriginal" + $1::interval, "timeZone" = $2 where "assetId" in () returning "assetId", "dateTimeOriginal", "timeZone"',
  params: [ '720 minute', 'Europe/Paris' ]
}

Query failed : {
  durationMs: 3.5422980000148527,
  error: PostgresError: syntax error at or near ")"
      at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)
      at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6)
      at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9)
      at Socket.emit (node:events:518:28)
      at addChunk (node:internal/streams/readable:561:12)
      at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
      at Readable.push (node:internal/streams/readable:392:5)
      at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
      at TCP.callbackTrampoline (node:internal/async_hooks:130:17) {
    severity_local: 'ERROR',
    severity: 'ERROR',
    code: '42601',
    position: '117',
    file: 'scan.l',
    line: '1176',
    routine: 'scanner_yyerror'
  },
  sql: 'update "asset_exif" set "dateTimeOriginal" = "dateTimeOriginal" + $1::interval, "timeZone" = $2 where "assetId" in () returning "assetId", "dateTimeOriginal", "timeZone"',
  params: [ '720 minute', 'Europe/Paris' ]
}

[Nest] 23  - 11/20/2025, 11:50:52 AM   ERROR [Api:ErrorInterceptor~wxttledu] Unknown error: PostgresError: syntax error at or near ")"
PostgresError: syntax error at or near ")"
    at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)
    at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6)
    at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9)
    at Socket.emit (node:events:518:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
    at Readable.push (node:internal/streams/readable:392:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
    at TCP.callbackTrampoline (node:internal/async_hooks:130:17)

[Nest] 23  - 11/20/2025, 11:50:52 AM   ERROR [Api:ErrorInterceptor~wxttledu] Unknown error: PostgresError: syntax error at or near ")"
PostgresError: syntax error at or near ")"
    at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)
    at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6)
    at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9)
    at Socket.emit (node:events:518:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
    at Readable.push (node:internal/streams/readable:392:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
    at TCP.callbackTrampoline (node:internal/async_hooks:130:17)

Immich•2d ago

Successfully submitted, a tag has been added to inform contributors. :white_check_mark:

NoMachine•2d ago

what version are you on?

BRO_OuafnicOOP•2d ago

the latest actually : v2.3.1 Had the same bug with previous one

NoMachine•2d ago

you may just found a bug. mind to open a GH issue?

BRO_OuafnicOOP•2d ago

sure done

Sergey Katsubo•17h ago

Hey! I saw https://github.com/immich-app/immich/issues/24028 is already closed. But I have a question, if you don't mind. - Do the photos that you try updating datetime for belong to your account in Immich (your external library)? Or maybe they are shared by a partner (belong to their external library)? It seems there are actually 2 issues / causes. Context: When Immich updates datetime it first writes to the database, then to a sidecar (and later re-reads metadata from the original image and its sidecar if present). Therefore: even if the asset is readonly, this should not affect the SQL query sql: 'update "asset_exif" set "dateTimeOriginal" = ... The query failure is caused by another factor/issue. Details: Below is a trimmed version of DB queries and Immich logs for updating/offsetting datetime of a couple of assets in a readonly external library on my test instance

select "asset"."id" from "asset" where "asset"."id" in ($1, $2) and "asset"."ownerId" = $3 and "asset"."visibility" != $4
...
update "asset_exif" set "dateTimeOriginal" = "dateTimeOriginal" + $1::interval, "timeZone" = $2 where "assetId" in ($3, $4) returning "assetId", "dateTimeOriginal", "timeZone"
...
  DEBUG [Api:LoggingInterceptor~ie6r2su6] PUT /api/assets 204 20.23ms ::ffff:192.168.117.1
VERBOSE [Api:LoggingInterceptor~ie6r2su6] {"ids":["c7e941e0-5f39-40b2-b63c-ba05cd7fe473","15c1b2c0-a5f8-4c37-b590-a21d250cc304"],"dateTimeRelative":1,"timeZone":"Europe/Paris"}
...
   WARN [Microservices:MetadataRepository] Error writing exif data (/img/crop.jpg.xmp): Error: Error creating file: /img/crop.jpg.xmp

select "asset"."id" from "asset" where "asset"."id" in ($1, $2) and "asset"."ownerId" = $3 and "asset"."visibility" != $4
...
update "asset_exif" set "dateTimeOriginal" = "dateTimeOriginal" + $1::interval, "timeZone" = $2 where "assetId" in ($3, $4) returning "assetId", "dateTimeOriginal", "timeZone"
...
  DEBUG [Api:LoggingInterceptor~ie6r2su6] PUT /api/assets 204 20.23ms ::ffff:192.168.117.1
VERBOSE [Api:LoggingInterceptor~ie6r2su6] {"ids":["c7e941e0-5f39-40b2-b63c-ba05cd7fe473","15c1b2c0-a5f8-4c37-b590-a21d250cc304"],"dateTimeRelative":1,"timeZone":"Europe/Paris"}
...
   WARN [Microservices:MetadataRepository] Error writing exif data (/img/crop.jpg.xmp): Error: Error creating file: /img/crop.jpg.xmp

Have a look at the very first query: it filters assets by owner ID and "not locked" status.

Immich•17h ago

[Issue] Changing date on pictures does not work (immich-app/immich#24028)

Gaming

Programming

Change date bug?

Did you find this page helpful?