New install crash loop of perplexica:main container

[itsLeon]

Describe the bug
Compleet new install keeps crashing the perplexica:main container on windows with docker desktop.

The logs show the following:

2025-09-25 20:45:19 /home/perplexica/migrate.js:4236
2025-09-25 20:45:19       throw e;
2025-09-25 20:45:19       ^
2025-09-25 20:45:19 
2025-09-25 20:45:19 DrizzleError: Failed to run the query '
2025-09-25 20:45:19 
2025-09-25 20:45:19 INSERT INTO `__new_messages`("id", "type", "chatId", "createdAt", "messageId", "content", "sources") 
2025-09-25 20:45:19 SELECT 
2025-09-25 20:45:19     id,
2025-09-25 20:45:19     COALESCE(type, 'user') as type,
2025-09-25 20:45:19     chatId,
2025-09-25 20:45:19     CASE
2025-09-25 20:45:19         WHEN metadata IS NOT NULL AND instr(metadata, '\"createdAt\":\"') > 0 THEN
2025-09-25 20:45:19             substr(
2025-09-25 20:45:19                 metadata,
2025-09-25 20:45:19                 instr(metadata, '\"createdAt\":\"') + 14,
2025-09-25 20:45:19                 CASE
2025-09-25 20:45:19                     WHEN instr(substr(metadata, instr(metadata, '\"createdAt\":\"') + 14), '\"') > 0 THEN
2025-09-25 20:45:19                         instr(substr(metadata, instr(metadata, '\"createdAt\":\"') + 14), '\"') - 1
2025-09-25 20:45:19                     ELSE 24
2025-09-25 20:45:19                 END
2025-09-25 20:45:19             )
2025-09-25 20:45:19         ELSE CURRENT_TIMESTAMP
2025-09-25 20:45:19     END as createdAt,
2025-09-25 20:45:19     messageId,
2025-09-25 20:45:19     content,
2025-09-25 20:45:19     '[]' as sources
2025-09-25 20:45:19 FROM `messages`;
2025-09-25 20:45:19 '
2025-09-25 20:45:19     at BetterSQLiteSession.run (/home/perplexica/migrate.js:6100:13)
2025-09-25 20:45:19     at SQLiteSyncDialect.migrate (/home/perplexica/migrate.js:4226:21)
2025-09-25 20:45:19     ... 4 lines matching cause stack trace ...
2025-09-25 20:45:19     at Module._extensions..js (node:internal/modules/cjs/loader:1548:10)
2025-09-25 20:45:19     at Module.load (node:internal/modules/cjs/loader:1288:32)
2025-09-25 20:45:19     at Module._load (node:internal/modules/cjs/loader:1104:12)
2025-09-25 20:45:19     at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:174:12) {
2025-09-25 20:45:19   cause: SqliteError: no such column: metadata
2025-09-25 20:45:19       at Database.prepare (/home/perplexica/migrate.js:615:21)
2025-09-25 20:45:19       at BetterSQLiteSession.prepareQuery (/home/perplexica/migrate.js:6163:30)
2025-09-25 20:45:19       at BetterSQLiteSession.prepareOneTimeQuery (/home/perplexica/migrate.js:6093:17)
2025-09-25 20:45:19       at BetterSQLiteSession.run (/home/perplexica/migrate.js:6098:19)
2025-09-25 20:45:19       at SQLiteSyncDialect.migrate (/home/perplexica/migrate.js:4226:21)
2025-09-25 20:45:19       at migrate (/home/perplexica/migrate.js:6400:14)
2025-09-25 20:45:19       at /home/perplexica/migrate.js:6408:1
2025-09-25 20:45:19       at Object.<anonymous> (/home/perplexica/migrate.js:6411:12)
2025-09-25 20:45:19       at Module._compile (node:internal/modules/cjs/loader:1469:14)
2025-09-25 20:45:19       at Module._extensions..js (node:internal/modules/cjs/loader:1548:10) {
2025-09-25 20:45:19     code: 'SQLITE_ERROR'
2025-09-25 20:45:19   }
2025-09-25 20:45:19 }
2025-09-25 20:45:19 
2025-09-25 20:45:19 Node.js v20.18.0

[technicalskeptic]

seeing the same error myself. fresh install of everything tonight.

/home/perplexica/migrate.js:4236
app-1 | throw e;
app-1 | ^
app-1 |
app-1 | DrizzleError: Failed to run the query '
app-1 |
app-1 | INSERT INTO __new_messages("id", "type", "chatId", "createdAt", "messageId", "content", "sources")
app-1 | SELECT
app-1 | id,
app-1 | COALESCE(type, 'user') as type,
app-1 | chatId,
app-1 | CASE
app-1 | WHEN metadata IS NOT NULL AND instr(metadata, '"createdAt":"') > 0 THEN
app-1 | substr(
app-1 | metadata,
app-1 | instr(metadata, '"createdAt":"') + 14,
app-1 | CASE
app-1 | WHEN instr(substr(metadata, instr(metadata, '"createdAt":"') + 14), '"') > 0 THEN
app-1 | instr(substr(metadata, instr(metadata, '"createdAt":"') + 14), '"') - 1
app-1 | ELSE 24
app-1 | END
app-1 | )
app-1 | ELSE CURRENT_TIMESTAMP
app-1 | END as createdAt,
app-1 | messageId,
app-1 | content,
app-1 | '[]' as sources
app-1 | FROM messages;
app-1 | '
app-1 | at BetterSQLiteSession.run (/home/perplexica/migrate.js:6100:13)
app-1 | at SQLiteSyncDialect.migrate (/home/perplexica/migrate.js:4226:21)
app-1 | ... 4 lines matching cause stack trace ...
app-1 | at Module._extensions..js (node:internal/modules/cjs/loader:1548:10)
app-1 | at Module.load (node:internal/modules/cjs/loader:1288:32)
app-1 | at Module._load (node:internal/modules/cjs/loader:1104:12)
app-1 | at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:174:12) {
app-1 | cause: SqliteError: no such column: metadata
app-1 | at Database.prepare (/home/perplexica/migrate.js:615:21)
app-1 | at BetterSQLiteSession.prepareQuery (/home/perplexica/migrate.js:6163:30)
app-1 | at BetterSQLiteSession.prepareOneTimeQuery (/home/perplexica/migrate.js:6093:17)
app-1 | at BetterSQLiteSession.run (/home/perplexica/migrate.js:6098:19)
app-1 | at SQLiteSyncDialect.migrate (/home/perplexica/migrate.js:4226:21)
app-1 | at migrate (/home/perplexica/migrate.js:6400:14)
app-1 | at /home/perplexica/migrate.js:6408:1
app-1 | at Object. (/home/perplexica/migrate.js:6411:12)
app-1 | at Module._compile (node:internal/modules/cjs/loader:1469:14)
app-1 | at Module._extensions..js (node:internal/modules/cjs/loader:1548:10) {
app-1 | code: 'SQLITE_ERROR'
app-1 | }
app-1 | }
app-1 |
app-1 | Node.js v20.18.0
app-1 exited with code 1 (restarting)
app-1 | /home/perplexica/migrate.js:4236
app-1 | throw e;
app-1 | ^
app-1 |
app-1 | DrizzleError: Failed to run the query '
app-1 |
app-1 | INSERT INTO __new_messages("id", "type", "chatId", "createdAt", "messageId", "content", "sources")
app-1 | SELECT
app-1 | id,
app-1 | COALESCE(type, 'user') as type,
app-1 | chatId,
app-1 | CASE
app-1 | WHEN metadata IS NOT NULL AND instr(metadata, '"createdAt":"') > 0 THEN
app-1 | substr(
app-1 | metadata,
app-1 | instr(metadata, '"createdAt":"') + 14,
app-1 | CASE
app-1 | WHEN instr(substr(metadata, instr(metadata, '"createdAt":"') + 14), '"') > 0 THEN
app-1 | instr(substr(metadata, instr(metadata, '"createdAt":"') + 14), '"') - 1
app-1 | ELSE 24
app-1 | END
app-1 | )
app-1 | ELSE CURRENT_TIMESTAMP
app-1 | END as createdAt,
app-1 | messageId,
app-1 | content,
app-1 | '[]' as sources
app-1 | FROM messages;
app-1 | '
app-1 | at BetterSQLiteSession.run (/home/perplexica/migrate.js:6100:13)
app-1 | at SQLiteSyncDialect.migrate (/home/perplexica/migrate.js:4226:21)
app-1 | ... 4 lines matching cause stack trace ...
app-1 | at Module._extensions..js (node:internal/modules/cjs/loader:1548:10)
app-1 | at Module.load (node:internal/modules/cjs/loader:1288:32)
app-1 | at Module._load (node:internal/modules/cjs/loader:1104:12)
app-1 | at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:174:12) {
app-1 | cause: SqliteError: no such column: metadata
app-1 | at Database.prepare (/home/perplexica/migrate.js:615:21)
app-1 | at BetterSQLiteSession.prepareQuery (/home/perplexica/migrate.js:6163:30)
app-1 | at BetterSQLiteSession.prepareOneTimeQuery (/home/perplexica/migrate.js:6093:17)
app-1 | at BetterSQLiteSession.run (/home/perplexica/migrate.js:6098:19)
app-1 | at SQLiteSyncDialect.migrate (/home/perplexica/migrate.js:4226:21)
app-1 | at migrate (/home/perplexica/migrate.js:6400:14)
app-1 | at /home/perplexica/migrate.js:6408:1
app-1 | at Object. (/home/perplexica/migrate.js:6411:12)
app-1 | at Module._compile (node:internal/modules/cjs/loader:1469:14)
app-1 | at Module._extensions..js (node:internal/modules/cjs/loader:1548:10) {
app-1 | code: 'SQLITE_ERROR'
app-1 | }
app-1 | }
app-1 |
app-1 | Node.js v20.18.0

[ItzCrazyKns]

I've pushed a fix for this, can you please run docker compose pull then docker compose up -d and see if that fixes?

[itsLeon]

That does seem to fix it!