Relation error

[moraleseder1]

I am running immich and power tools on unraid. Immich runs fine, no issues, and power tools seems to as well; it can connect to immich but no information is displayed in the tabs. The logs for power tools display the following errors: error: relation "assets" does not exist, error: relation "albums" does not exist. Any suggestions?

[varun-raj]

Hi @moraleseder1, Mind sharing a screenshot of the logs?

Also possible to check if its pointing to the right db?

[moraleseder1]

From what I can tell, the connection to the database is correct. Here is what the logs show after I start navigating the different tabs.

▲ Next.js 14.2.5

• Local: http://1b1fe634c657:3000
• Network: http://172.17.0.39:3000
  ✓ Starting...
  ✓ Ready in 222ms
  error: relation "assets" does not exist
  at /app/node_modules/pg-pool/index.js:45:11
  at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
  at async file:///app/node_modules/drizzle-orm/node-postgres/session.js:47:22
  at async d (/app/.next/server/pages/api/analytics/exif/storage.js:1:1519)
  at async K (/app/node_modules/next/dist/compiled/next-server/pages-api.runtime.prod.js:20:16853)
  at async U.render (/app/node_modules/next/dist/compiled/next-server/pages-api.runtime.prod.js:20:17492)
  at async NextNodeServer.runApi (/app/node_modules/next/dist/server/next-server.js:600:9)
  at async NextNodeServer.handleCatchallRenderRequest (/app/node_modules/next/dist/server/next-server.js:269:37)
  at async NextNodeServer.handleRequestImpl (/app/node_modules/next/dist/server/base-server.js:816:17)
  at async invokeRender (/app/node_modules/next/dist/server/lib/router-server.js:174:21) {
  length: 105,
  severity: 'ERROR',
  code: '42P01',
  detail: undefined,
  hint: undefined,
  position: '58',
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'parse_relation.c',
  line: '1392',
  routine: 'parserOpenTable'
  }
  error: relation "assets" does not exist
  at /app/node_modules/pg-pool/index.js:45:11
  at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
  at async file:///app/node_modules/drizzle-orm/node-postgres/session.js:47:22
  at async m (/app/.next/server/pages/api/rewind/stats.js:1:1469)
  at async K (/app/node_modules/next/dist/compiled/next-server/pages-api.runtime.prod.js:20:16853)
  at async U.render (/app/node_modules/next/dist/compiled/next-server/pages-api.runtime.prod.js:20:17492)
  at async NextNodeServer.runApi (/app/node_modules/next/dist/server/next-server.js:600:9)
  at async NextNodeServer.handleCatchallRenderRequest (/app/node_modules/next/dist/server/next-server.js:269:37)
  at async NextNodeServer.handleRequestImpl (/app/node_modules/next/dist/server/base-server.js:816:17)
  at async invokeRender (/app/node_modules/next/dist/server/lib/router-server.js:174:21) {
  length: 105,
  severity: 'ERROR',
  code: '42P01',
  detail: undefined,
  hint: undefined,
  position: '25',
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'parse_relation.c',
  line: '1392',
  routine: 'parserOpenTable'
  }