© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
ImmichI
Immich•7mo ago•
16 replies
Divak

Database Migrations Error

Hey there,

I'm trying to set up the postgres database but for some reason it is encountering a syntax error. I believe that there should be quotation marks around the word all. I also looked through the repo but I can't seem to find where this sql query is. Please let me know what other info I should include
Query failed : {
  durationMs: 2.0561109999998735,
  error: PostgresError: syntax error at or near "all"
      at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26)
      at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476: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) {
    severity_local: 'ERROR',
    severity: 'ERROR',
    code: '42601',
    position: '54',
    file: 'scan.l',
    line: '1245',
    routine: 'scanner_yyerror'
  },
  sql: 'alter database "immich" set log_statement to all;',
  params: []
}
Query failed : {
  durationMs: 2.0561109999998735,
  error: PostgresError: syntax error at or near "all"
      at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26)
      at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476: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) {
    severity_local: 'ERROR',
    severity: 'ERROR',
    code: '42601',
    position: '54',
    file: 'scan.l',
    line: '1245',
    routine: 'scanner_yyerror'
  },
  sql: 'alter database "immich" set log_statement to all;',
  params: []
}
ImmichJoin
A place to hang out, get support, discuss Immich, get announcements about releases and anything else going on.
36,590Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Postgres error during migrations
ImmichIImmich / help-desk-support
10mo ago
Error Database
ImmichIImmich / help-desk-support
7mo ago
Database Error & Redis Error
ImmichIImmich / help-desk-support
10mo ago
Migrations failed: Error: corrupted migrations: previously executed migration 1758705774125-CreateA
ImmichIImmich / help-desk-support
4mo ago