Error while updating picture location - PostgresError: syntax error at or near "where"

[BernardoGiordano]

The bug

Same as title. The location still seems to be updated, but there may be inconsistencies between database and sidecar xmp data. See logs for details.

The OS that Immich Server is running on

Unraid OS

Version of Immich Server

v1.125.2

Version of Immich Mobile App

N/A

Platform with the issue

• Server
• Web
• Mobile

Your docker-compose.yml content

N/A

Your .env content

N/A

Reproduction steps

1. Set an asset location manually or through the API

Relevant log output

Query failed : {
  durationMs: 1.1097999997437,
  error: PostgresError: syntax error at or near "where"
      at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:788:26)
      at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:474:6)
      at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)
      at Socket.emit (node:events:524: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: '22',
    file: 'scan.l',
    line: '1176',
    routine: 'scanner_yyerror'
  },
  sql: 'update "assets" set  where "id" = any($1::uuid[])',
  params: [
    '{9a1b4dc4-1211-490a-b96a-011cfed79b39,595d911c-5ea0-48e7-8afa-7bba9ae0cd28,204199d6-0d61-45eb-a5e9-d36b0ded2bd2,7e26f888-8270-4273-af53-0c676bf339fb,999803c6-49bf-4a26-874e-8f660fa86b55,9768b463-6f75-42c1-8754-16e9eb9bc53d,228554fb-ce1b-482b-8ed7-bd3973b68279,8f5d76fc-2bbe-4be0-8350-341544fda4c7,9f41a5c4-9b10-4a84-8835-bdbcae9d56e3,d32c4e6f-bca2-42b6-bb73-67e4e69d5b6e,31737afc-d825-4518-84bf-0a53d0446d1c,e86f8b15-50d6-411b-8c08-3ac2088d8e8e,5b88d8ea-7b45-4f1f-bfa2-41c88eecbd50}'
  ]
}
[Nest] 16  - 01/25/2025, 11:00:37 AM   ERROR [Api:ErrorInterceptor~685szm6f] Unknown error: PostgresError: syntax error at or near "where"
PostgresError: syntax error at or near "where"
    at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:788:26)
    at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:474:6)
    at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)
    at Socket.emit (node:events:524: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)
Query failed : {
  durationMs: 1.1785310003906488,
  error: PostgresError: syntax error at or near "where"
      at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:788:26)
      at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:474:6)
      at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)
      at Socket.emit (node:events:524: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: '22',
    file: 'scan.l',
    line: '1176',
    routine: 'scanner_yyerror'
  },
  sql: 'update "assets" set  where "id" = any($1::uuid[])',
  params: [ '{8f5d76fc-2bbe-4be0-8350-341544fda4c7}' ]
}
[Nest] 16  - 01/25/2025, 11:03:42 AM   ERROR [Api:ErrorInterceptor~f09zb6rs] Unknown error: PostgresError: syntax error at or near "where"
PostgresError: syntax error at or near "where"
    at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:788:26)
    at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:474:6)
    at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)
    at Socket.emit (node:events:524: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)

Additional information

No response

[ingria]

Also the same error occurs while changing the photo date

[radiantwave]

V1.125.2 doesn't seem to extract location at all for my new uploads via share-to-immich.

[soner89]

I am still on 1.125.1 and I have the same error

[Dulanic]

Same errors, went to update all the images in a album and same error occured.

immich  |   durationMs: 0.8016919791698456,
immich  |   error: PostgresError: syntax error at or near "where"
immich  |       at ErrorResponse (/app/immich/server/node_modules/postgres/cjs/src/connection.js:788:26)
immich  |       at handle (/app/immich/server/node_modules/postgres/cjs/src/connection.js:474:6)
immich  |       at Socket.data (/app/immich/server/node_modules/postgres/cjs/src/connection.js:315:9)
immich  |       at Socket.emit (node:events:518:28)
immich  |       at addChunk (node:internal/streams/readable:561:12)
immich  |       at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
immich  |       at Readable.push (node:internal/streams/readable:392:5)
immich  |       at TCP.onStreamRead (node:internal/stream_base_commons:191:23)
immich  |       at TCP.callbackTrampoline (node:internal/async_hooks:130:17) {
immich  |     severity_local: 'ERROR',
immich  |     severity: 'ERROR',
immich  |     code: '42601',
immich  |     position: '22',
immich  |     file: 'scan.l',
immich  |     line: '1241',
immich  |     routine: 'scanner_yyerror'
immich  |   },
immich  |   sql: 'update "assets" set  where "id" = any($1::uuid[])',
immich  |   params: [
immich  |     '{244da278-eaaf-4f64-9702-961c0caa9a4d,3447b457-0c07-456d-9430-29a5a57d675b,d53f7b4d-c13b-46b0-9ad5-5e2848456ab9,f8683aed-7283-4557-a49f-dbbd000260c0,b0424929-e3dd-4b89-88dc-ce52221d8a51,e937fb2f-5f8f-4885-ac79-1742e9ad2452,b9cd7909-1e50-4c5a-a35f-591056beb49a,b31b492f-a47a-4d4f-bd3c-5a898852eee6,813873e3-34c0-4e50-a43c-7f6ed980cfcc,da5af21d-5680-41c3-8854-fad351621d84,e76620e4-05f3-430a-b4dd-9dcbb7b96931,9fd6b1bb-cc1e-4a4f-b719-586a47f7ef9d,bec8ce2c-a788-4cdf-8d10-34dcbf548660,34f02876-e455-4a47-9ec0-ef57547f3999,b9308431-d19b-4b90-a72e-ed6ffb57c992,7beca3eb-8668-4332-bed4-feb4dea3b6a1,3769c189-7f66-4691-9ba1-0bd311c9a2e8,5214a49a-44d0-4439-a50c-791103644813,546c3a12-409e-482e-821c-0e9dadbe5594,27e2436c-932d-4510-a0fa-9f92044417c3,a2f9e624-6d4a-4545-b8f3-5090257fd7da,8a51ef28-e0b2-4ca2-b0d0-2e0deb705793,4c921be6-4d79-4ec5-b3ce-584050d0ee6c,eb7c890a-5f6e-4ab1-8589-36cd301fa8ac,26f0db44-6059-40f6-bd68-ec225d7881a1,0fd6585b-2d0b-4fa1-9b8a-08db1f9802ab,a835d4b2-dfa9-4433-9c19-d638dee0b631,6454a988-faee-449b-8284-27024a4059e9,54972319-f017-40c2-9d68-84423338dfca,3d0b3e82-b08d-4c09-9e6b-4ef32fe99eff,6d0fee37-1e00-49f3-8ba4-98d86d0c9a9d,d4a3878a-ae85-4473-aaca-57a270e10cc6,92b1e9e0-a780-4ade-80b7-56522308a1c9,7083ab6c-fee8-434d-ab42-a5d4304e7dc0,af491800-ec49-45d7-99ba-6371eca9a080,2eba54f2-654e-4b4c-bd8a-674db3c96835,d66afafd-db2e-4702-be12-c6d4af55704d,72eb8634-f251-4241-858c-b9520bfa6aa9,b6760935-9a8c-425a-924b-0240a2a9ca25,c5f828e9-d6c3-4e82-8792-a19f10ded3e5,cdb4b499-8723-48bc-b7d2-8b78573036c8,beda0bcf-6704-4fe5-9534-dd98cd0ac898,2a089876-b596-47de-91ea-1be352311794,bd9ecbd7-b1f7-4b98-9b42-65c5e3af5f43,bc5cef7f-c913-42bc-9c02-eba49ba5575e,a4c0cc2e-621e-45df-9201-249bac75cf87,00ce13f9-c27f-45f1-9c4a-dbeaff39e425,9c52d243-d62d-49e8-ac98-92a909a94737,998bf98f-f7b9-4d76-b22c-0acd15367b39,b694cf43-7928-4ac0-a851-cdb2d9f39b8c,a1d64172-4d3e-429d-b135-41bbf4be16b1,cb1757b6-6bc2-4c74-a19e-a889eef5bcf2,7430ca69-8c2c-4b95-a19e-fb6ba068b010,e8d76ecf-a46e-4c92-b788-f2ab384c5634,bc278a24-e21f-42c7-8174-017011ab3f7e,62b4248d-4716-4aac-9725-14d007dec310,f7e3c630-0d23-4da8-b232-f0dfeb9cf2f5,883864e1-8368-4158-9e63-70216f7d3b56,ce4db8a0-cefe-47b4-824a-ffe569bf446c,bc53c004-d845-415d-adec-2ced4be0348c,f1a77f49-7227-4511-a9f4-942bff6543fc,5d3a45e0-31e5-4eaf-8caf-8257bf1066f3,3e857b0e-74ab-4d60-a07b-e2ace95b1c71,c9d9a0e3-2e2c-4801-913a-1de14dc80323,12c01e83-3097-4052-bb80-abe2330583cd,125e0a4d-f791-4b95-9d3c-1bfc49527d0c,89691159-cc6a-4eba-b120-a9edfe448560,91734874-c4b2-4f5b-b97b-48b07a6e79cb,7908e4ff-c9bb-4219-91de-78484072fca5,7180b8bc-3bf6-40c2-8272-e2ec21f32b3e,5fa81e59-e81d-48bf-ba83-a2bce6e05df3,a4284bcc-9a1e-4433-86ff-13da12427b2b,a199afaf-0ede-4271-b930-32456ded1816,3537e03f-08e5-4182-8ae0-e0d70ba441af,702d224b-c6f0-4992-9f2b-ef03e4500dd5,b115e4c1-018c-4dd7-a853-c30cabf3ba32,9fb05fd6-0c2e-4c97-837f-8d0907639639,303cbe42-2f77-447c-91fb-1ea57cd93a19,c78baa52-b9cd-4390-aefd-31712ac68a36,1db4c1be-b146-4138-962a-66727def0f4d,d187916a-cdfd-4c56-8854-ac0c1242bc40,c3694530-c382-4537-9f16-33d1b0631ea7,1e2f52ee-823a-4cd1-b2b5-5e04124fce9e,3fb01f43-ab8a-44a6-a545-2ab0b42181cf,57034708-9f5c-46bc-8866-e64656e1ca54,986a2283-b983-45dd-a123-95f0703b68a4,a3f16a3a-4261-4ae7-b904-5258feb737dd,477b86ed-5201-4460-ac7c-d4a0d396d35b,2178a5bc-c8d3-4c74-b202-63e8c46a4ca3,3ccce9f7-bb75-411e-bfa3-eaf52f83365b,088bf406-7d4c-4e75-b660-2d8bfa1a2c8c,2014402e-f89c-4e6e-95af-bde5b1db3e12,eb66fc46-22e0-4eb0-aa93-814207222106,35f0cd5e-bc10-4f2d-bae6-e4d7d4f5b8fb,9682c0ca-3ae9-4cb8-aaed-4e8f014732e0,0351fb6f-2f5d-4994-8da6-38ca6f931112,baeb36dd-0b5b-4c47-b556-a5371626d5ce,b6444c5a-d149-4fbe-b533-fa160dd0d2e8,4cc87ecc-6d20-4536-9e7f-4aee13ff8720,027a6f13-ba3a-4463-af18-7e4e268496a7,2dd1a8fa-d9af-41ca-9f97-72e06cb003fb,10f6d83d-f2e6-4db7-9bfa-cf5e12777b56,47677ed0-b3e4-4868-bdc1-f59857b9c313,dc35e4e3-1b78-418d-a011-959dc2971f48,d07a0de7-2f0d-46a2-b058-a2a7c661146d,5b294f34-6364-4ac1-9794-bece75958d68,e3696ad0-2fe0-4b92-8f1a-a90179b39995,77ea35a9-2d2c-4a80-9047-889bee549af6,924b93c5-1eb7-47f7-84b2-5a3584b5aedf,f63e601e-beaa-457e-95cb-aa13257fecf0,aca67d9f-2588-41e6-a99d-9af2d7007b37,0fde95bf-2c31-4fd7-a0a0-60bf93d49e9d,b40358ef-9347-4e01-b3b2-def964192ca4,dced5406-8098-4516-83f4-1c7197cc0a81,107ebb0c-5acd-4036-a08a-a844b781c317,73fadcd3-14c1-462b-8c0d-d8507ac156c8,32d42a16-2bc2-420b-a176-728401d04d62,bc42cff9-31b5-4b46-b489-7c5e0ea790e2,256a1d0b-48b0-4cb4-bcd8-8a1fe6c79447,42c9cf4b-155e-45ca-b974-be139bf314ef,8b4168a4-632a-4c06-ad46-44c86cd281af,bf8ddc88-3bc5-40b1-82f2-20e2510a548a,dc0a01f1-5c0f-41f5-aeac-cd39f2fdff20,12beb1fd-3773-464e-aefd-f5d8ca0d49c1,b2047011-47a4-4c1f-8c67-e0a318c463d7,ae0f7bd1-ddee-4f3a-a14c-85f84c10b56d,e10aded1-1380-4c35-a62d-d5b93a81c190,e2f0ea13-0673-4366-ab08-8a8987114051,eaa7b178-da49-47d3-8028-bdf43fe0aa38,b62a1546-a048-4bb9-bc25-66d3a5766241,b4272be8-25df-40e5-a3a6-eccdd9a50796,4c8b2a04-e8aa-4ff8-b226-aed1b43fb8d8,6de00a44-e51d-4d83-81d5-23d0f121d161,f16941d5-b47d-46d9-920b-51a40d367672,0a1fa7ce-9bc0-4254-906e-b2bb0bc8b7ea,09522756-fbd9-4193-8b8c-3eca0e555433,37067093-5250-4cba-adc1-930d19e0dd5d,a9ebf84b-f52a-4f95-a275-d6c5fe40e0cd,01672d10-c57b-4c77-a831-3611469c55a9,7700e3a6-eaad-4169-b96d-5f567de8abe7,e14a29ec-3004-4aab-81d7-06e84da16fcd,68829b9f-6b1a-488d-8a65-61fad3b822d2,ea2de267-05cb-457a-a223-3aa9971c24b5,4c77ee10-6c1b-474b-936a-b6415dc5f292,c59986d7-9a4a-4b2a-8e2a-ff7f7612cf21,aab07b8b-c649-45f2-ae10-7cefac25642b,71ab3ad1-826d-4ebe-8875-e780e3b29316,36f61ee6-db54-4d3c-aba7-73a9c79557a5,36fdc3e1-9ee6-44ce-8ad6-53d1f7a11ad1,78f9855d-dfe9-4217-b042-c9e35a4cf51a,834f9631-e8b5-45c6-a981-9a8cbd318144,3750cb06-78ab-4304-86e9-dc6133e64cb2,a6963474-5407-48bc-ac11-c608ef7294fd,ad69b04d-9b43-43b4-92be-0b4c6c24c008,81fadbc2-8d78-45d0-95b3-c6891a8145dc,948be7ac-1fb8-4265-879a-2b55bac3115d,f350d90c-5642-418a-98a6-eff4b8180414,16e7932e-aff8-43e6-8730-e034b4d7ed92,6d294f0c-70e3-43fd-86d7-c0ae3764d90c,1cbfb7a0-a6f8-4ddc-80cd-4493caffcd0a,11025339-c1a1-472a-a606-571564cd0353,f14973e6-96e5-4c9b-b98d-9b20cbcb72a5,c8f0e32c-6642-4a27-807f-b7b783e1af8b,757db463-431b-486a-8397-a08e5bfa5b9b,54a8de39-cc06-4fb3-90f7-ffa24aaafcb7,4be69fb0-2fa5-4d8a-94d6-7f004aeed637,51a64d92-39c1-48c0-80fe-5c80416b5fad,7c764dcd-b7a2-469b-aa82-b47d3606fa87,19593e7f-8978-4f46-95a7-d1ae98ccdd98,4192b4f9-7f30-491d-acb7-9d556b65211c,e0e8d10d-f53a-4023-b3f2-da0da828cdde,2e54dd21-6fc8-4558-9d02-1fe80be53a6e,be978a17-d534-4338-8d5a-554ace0777bf,e894325a-e2c0-4a0a-93b7-8f818a46fe7b,e4456700-fac9-435e-8fed-cb6e21be7416,155a75d5-097d-4903-9c3f-29078fd74c5e,55731e28-55d3-4109-98ad-cdb577fd51f7,826005a3-2f83-4030-ae52-429714f0f707,f9239721-7af0-4394-8019-ff8d3cb63f79,829a4398-75a9-41ed-b147-8297d72f4bd9,7e127a51-eaa6-4025-9317-b5a8cc57bfc3,53db010b-77e1-4eb2-b46b-7377d3710826,b7dbf399-634e-488e-8086-d08437be93e1,b17fd75e-8d06-4ab8-916d-e78f35a5e715,4f1f9cd8-cdb9-4352-90eb-452e5966801d,9e470e8f-91da-467e-83b6-d238443a978f,abbd218e-7e62-4435-91a7-e626002a0800,80d9b347-fad9-4483-a290-7255d82c27a6,98e830fd-fab5-4006-9a91-7443bf9fbd89,49d3d9a3-21f5-452d-9737-aae557f41392,49a25cc3-d793-4371-8f76-18dafffd4530,1a3cf63b-36a5-493f-ab3e-088ca9589459,537eeb26-7890-454a-9a47-9565af1be764,3ec10bdc-fa5b-4310-bd5d-fa4f11796bc3,0ac718fd-38e5-47e7-900a-66300be80f70,dc64f8fc-94e0-4dde-a56d-b5b8beae367d,ec3b4fd3-e26e-410d-84eb-d545fd46626d,6e5ca23f-dba0-48fc-9c52-56475295fa87,b7d159ac-9f17-41e7-9e1e-ed0aded6efc8,686fc3fc-82e2-4a73-9a12-d43468ed8977,33a02d5b-6373-484e-b075-ec3d39448336,1e7d0a70-5312-4277-876e-fe2bcb7fb432,4856440a-d355-41f3-bad5-4c49a1114a14,086d6a8a-6e16-496a-b79e-1c7463b13c23,dc1f7d1e-e64e-40cb-a490-71fbfcb54b66,d858db78-b1b6-4158-9c93-412008256ba3,423fc292-35f2-491d-992b-24bb5e1963a6,425eadc3-66c3-480d-8172-aadc542f5910,0571c208-d0eb-4008-8f5e-b0195e1ccf9c,966382a9-e317-43c4-940f-1160ad7e60d1,647d85d4-96e2-40f5-9a7b-d22277e2bd71,b6a3b834-ace4-4f12-8bdd-b666652a1c9b,eccc677a-d34c-49f7-a014-9f2617ca77ca,372decb8-3de8-480c-b9c4-6d12151b60a7,12306200-dbf0-47b1-a7dd-d8fe8f721c43,ce76947d-e567-49a4-902e-5b872d16877f,5e0e87e6-a7bd-4270-bbd9-07b2ba350f03,966b4be6-0a58-4ba1-bf15-6f5325eeb5cf,0aa1c00b-95fa-458d-95e8-bdf6baeab3b2,18282f44-dbcb-445f-8a92-31833aead92a,dc7757c1-1e6b-4d88-adb3-3528d0fbb5f5,03fcdbd5-db93-40b1-b948-6b9dc706e34f,747a1a22-110d-4e19-bc15-30caaf1b64d7,c3efa30b-4537-4721-af57-3fa39b681f14,5e66ebe0-2a37-4cfa-997c-bc9017dd5709,11f50146-17ff-43c5-9513-9f56cc4859b8,07cb0f25-0d5b-400c-bc0a-56a3e0c68ee5,f3ef8b83-e974-4a1b-ad1b-7d9eaee09d25,43984b2e-bd3e-406c-a974-be489f8907d6,e5368c66-61b7-4a18-93bd-62a52de1533a,11a9b0fe-7f1d-4674-b738-167746d48667,139cf0e8-6a56-4dcf-a05b-37c907540b8b,b025e534-7f68-49e6-a422-5c1d1529181e,1169dfb7-9a6e-47ac-a136-5487aff5922e,6aee9ca5-3da4-4d98-9a36-8298fe40ad5e,c8b6d378-5bad-48c0-adbd-73e98e62afe9,a5d1d6be-f7b2-4e4a-8781-00c14412f9dd,9156889f-9b8a-4149-aa2c-5bf933187cd2,8c8d450c-4f39-4b44-9879-63f93bf51805,6f2770a7-1c99-437b-9ff2-b36f34c512f6,2964419f-266c-4929-ad41-e1428ad02cc4,e854e46b-415f-4b37-b69f-9bdcf27c9679,5f943f4b-ccd5-4697-b1cd-0e5c8f68cb8c,5f1d72df-cfa5-4685-b6d5-f2e5b0b7930a,8b8b67bd-914d-4cb6-8541-e7e265d7bfe0,96e841ff-a82f-49bd-893b-daa7baf27123,c735c871-678c-40ff-b7ca-af6814cdf945,f884c16e-0b6b-4e39-bc25-9123eb2b940d,6d172650-110b-4622-9821-9526e0e07dc0,5f964ff3-72f1-4254-ba7b-135d5f5aefc8,00fec9d1-7440-40fa-977e-77e0e31ae5a5,643166c0-2f96-4be7-9686-554dc40281c6,a5c33d51-9ac6-423a-9eee-b7e8923973c2,cfa77356-b21f-46d3-9d8f-81f0b60cd81c,f0d2b653-88c2-4d1a-8508-0e376837ef4b,c81e9fc8-5314-408b-9b05-84f1222e2974,c3158638-661f-4a01-ae23-1349235ce884,62db386d-fbe8-4286-b8e5-f9894aa0ece5,b33e7106-be72-4417-aa94-3f1e9e5480be,8c00a877-17c4-4c32-9769-38dd3898910c,6a46bb59-083c-493b-b7dd-df8b1c822201,50ecd206-a475-4ca0-8290-f3532e2e5cfe,74515a5f-80e6-4f5c-b3ce-92a9052d64a8,63119444-33ee-4c96-82ea-b86b6472e6d5,cf7074d8-68a1-413d-aee1-37edfc0bfe97,4472a974-fc2f-4e1b-8f8e-e63f36991c2f,1179e8bd-d742-4579-ba8b-e681b60780c2,ab71df0f-1c33-4e16-98f6-426a6e033419,8362b7df-02c7-4544-9b98-aab63e40d0ad,d4a908ea-382a-4264-94c4-037ebc966cf4,e983a83f-'... 2729 more characters
immich  |   ]
immich  | }
immich  | [Nest] 177  - 01/26/2025, 3:20:57 PM   ERROR [Api:ErrorInterceptor~9a5rvf7d] Unknown error: PostgresError: syntax error at or near "where"
immich  | PostgresError: syntax error at or near "where"
immich  |     at ErrorResponse (/app/immich/server/node_modules/postgres/cjs/src/connection.js:788:26)
immich  |     at handle (/app/immich/server/node_modules/postgres/cjs/src/connection.js:474:6)
immich  |     at Socket.data (/app/immich/server/node_modules/postgres/cjs/src/connection.js:315:9)
immich  |     at Socket.emit (node:events:518:28)
immich  |     at addChunk (node:internal/streams/readable:561:12)
immich  |     at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
immich  |     at Readable.push (node:internal/streams/readable:392:5)
immich  |     at TCP.onStreamRead (node:internal/stream_base_commons:191:23)
immich  |     at TCP.callbackTrampoline (node:internal/async_hooks:130:17)

With this said, after checking the photos, the location is now set, so it doesn't seem to be the location update that fails.