PostgresError: column assets.isVisible does not exist
Tried to restore a backup I had after I accidently deleted my cluster.
started the server and getting this :
gunzip --stdout "/mnt/ssd/immich/data/backups/immich-db-backup-1751853600088.sql.gz" | sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g" | k exec -ti immich-postgresql-0 -- psql --dbname=immich --username=immichgunzip --stdout "/mnt/ssd/immich/data/backups/immich-db-backup-1751853600088.sql.gz" | sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g" | k exec -ti immich-postgresql-0 -- psql --dbname=immich --username=immichstarted the server and getting this :
sql: `with "assets" as (select date_trunc($1, "localDateTime" at time zone 'UTC') at time zone 'UTC' as "timeBucket" from "assets" left join "asset_stack" on "asset_stack"."id" = "assets"."stackId" and "asset_stack"."primaryAssetId" = "assets"."id" where "assets"."deletedAt" is null and "assets"."isVisible" = $2 and "assets"."fileCreatedAt" is not null and "assets"."fileModifiedAt" is not null and "assets"."localDateTime" is not null and ("assets"."stackId" is null or "asset_stack" is not null) and "assets"."ownerId" = any($3::uuid[]) and "assets"."isArchived" = $4) select "timeBucket", count(*) as "count" from "assets" group by "timeBucket" order by "timeBucket" desc`,
params: [ 'MONTH', true, '{514ba18c-fe2f-487a-ad54-4a701506b5ad}', false ]
}
[Nest] 17 - 07/09/2025, 5:47:00 PM ERROR [Api:ErrorInterceptor~k7r992zj] Unknown error: PostgresError: column assets.isVisible does not exist
PostgresError: column assets.isVisible does not exist
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: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)sql: `with "assets" as (select date_trunc($1, "localDateTime" at time zone 'UTC') at time zone 'UTC' as "timeBucket" from "assets" left join "asset_stack" on "asset_stack"."id" = "assets"."stackId" and "asset_stack"."primaryAssetId" = "assets"."id" where "assets"."deletedAt" is null and "assets"."isVisible" = $2 and "assets"."fileCreatedAt" is not null and "assets"."fileModifiedAt" is not null and "assets"."localDateTime" is not null and ("assets"."stackId" is null or "asset_stack" is not null) and "assets"."ownerId" = any($3::uuid[]) and "assets"."isArchived" = $4) select "timeBucket", count(*) as "count" from "assets" group by "timeBucket" order by "timeBucket" desc`,
params: [ 'MONTH', true, '{514ba18c-fe2f-487a-ad54-4a701506b5ad}', false ]
}
[Nest] 17 - 07/09/2025, 5:47:00 PM ERROR [Api:ErrorInterceptor~k7r992zj] Unknown error: PostgresError: column assets.isVisible does not exist
PostgresError: column assets.isVisible does not exist
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: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)