2025-10-19T03:08:08.691647849Z [migrations] started
2025-10-19T03:08:08.822193524Z [migrations] 01-nginx-site-confs-default: executing...
2025-10-19T03:08:09.342324942Z [migrations] 01-nginx-site-confs-default: succeeded
2025-10-19T03:08:09.416714194Z [migrations] 02-default-location: executing...
2025-10-19T03:08:09.690106469Z [migrations] 02-default-location: succeeded
2025-10-19T03:08:09.690725215Z [migrations] done
2025-10-19T03:08:10.105946993Z usermod: no changes
2025-10-19T03:08:10.147614485Z ───────────────────────────────────────
2025-10-19T03:08:10.147639174Z
2025-10-19T03:08:10.147648413Z ██╗ ███████╗██╗ ██████╗
2025-10-19T03:08:10.147657291Z ██║ ██╔════╝██║██╔═══██╗
2025-10-19T03:08:10.147665477Z ██║ ███████╗██║██║ ██║
2025-10-19T03:08:10.147673644Z ██║ ╚════██║██║██║ ██║
2025-10-19T03:08:10.147681700Z ███████╗███████║██║╚██████╔╝
2025-10-19T03:08:10.147690067Z ╚══════╝╚══════╝╚═╝ ╚═════╝
2025-10-19T03:08:10.147698213Z
2025-10-19T03:08:10.147706300Z Brought to you by linuxserver.io
2025-10-19T03:08:10.147714416Z ───────────────────────────────────────
2025-10-19T03:08:10.153155130Z
2025-10-19T03:08:10.153186874Z To support LSIO projects visit:
2025-10-19T03:08:10.153196674Z https://www.linuxserver.io/donate/
2025-10-19T03:08:10.153204960Z
2025-10-19T03:08:10.153212916Z ───────────────────────────────────────
2025-10-19T03:08:10.153222355Z GID/UID
2025-10-19T03:08:10.153389842Z ───────────────────────────────────────
2025-10-19T03:08:10.344588212Z
2025-10-19T03:08:10.344613864Z User UID: 911
2025-10-19T03:08:10.344623523Z User GID: 911
2025-10-19T03:08:10.344632231Z ───────────────────────────────────────
2025-10-19T03:08:10.381753850Z Linuxserver.io version: 0.0.9-ls167
2025-10-19T03:08:10.384914503Z Build-date: 2025-10-19T02:58:45+00:00
2025-10-19T03:08:10.384952500Z ───────────────────────────────────────
2025-10-19T03:08:10.384960406Z
2025-10-19T03:08:14.476983386Z Setting resolver to 8.8.8.8 8.8.4.4
2025-10-19T03:08:14.592389248Z Setting worker_processes to 64
2025-10-19T03:08:18.741618858Z generating self-signed keys in /config/keys, you can replace these with your own keys if required
2025-10-19T03:08:19.950637200Z .......+.+.....+++++++++++++++++++++++++++++++++++++++*.+.....+..........+.........+++++++++++++++++++++++++++++++++++++++*..............+.+..+...............+..................+.......+...............+..+.+..+...+............+....+...........+...+......+.+..+.......+...+..+...+.............+...+..+..........+........+......+...+.+.....+....+...+..+.......+...+.......................+............+......+....+...+........+.+......+...............+..+.+.....+.......+..+...+....+.....+....+............+.....+....+...+..+.........................+...+.....................+.....+.+...+...+.....+.......+..+.+..................+.........+..+...+.......+...+......+..+..........+.................+.+..+....+........+............+.+...+............+..+..........+......+......+........+...+...+..........+.....+.+........+.+..+.......+...+........+.+...+...+..............+.+..+.......+...+.....+...+...+..........+......+.....+...+......+.......+..+...+....+...+.....+.............+...+..+...+....+..+...................+..+.......+...+.........+...+.....+......+......+......+....+.....+...+......+....+.................+...+.+..+............+...+..................+....+...+..................+...........+.+..+......+......+.+...+.....+..........+...........+...................+..+.......+.....+......+.+......+...+......+........+.........................+...+...+..+.........+......+...+.......+............+..+....+.....+.......+..+......+.+.....+.+..............+....+.....+....+......+.........+..+....+.....+....+...+..+...+...+.+..............+.+.....+.............+...+.....+..........+..............+.+..+.+...............+..+....+.........+.....................+.........+......+........+...+.......+..+.+.....+............+............+...+......+.......+...+.....+....+...+..+......................+........+...+.............+..+.......+..+......+...............+....+......+..+...+....+...+...+.........+........+...+.........+......+...+.+.....+.........+.......+............+.....+.+.....+.+...........+...+.+.....+.+.........+...............+...........+...+.+...+..+.+...+..+.........+...+.......+...+.....+..........+...+...+..+.........+...................+....................+....+...+.....+...+......+..........+...............+...........+...+.+......+...+............+..+...+...+.+......+............+........+.........+.+...+........................+.....+.............+..+............+....+..+.......+..+.+..+................+.........+..+.+.........+...+..+.........+.+...+........+....+.....+.+.........+......+...+......+.....+.+.....+...+.......+...+..........................+..........+...++++++
2025-10-19T03:08:20.183701221Z .......+...+..+...+...+......+....+......+......+++++++++++++++++++++++++++++++++++++++*.....+......+.......+......+......+...........+...+......+.+..+++++++++++++++++++++++++++++++++++++++*..+........+....+...+..+................+..+..........+..+...+......+.+.....................+...+............+...+..+..........+........+..........+...............+..............+.+..+..........+...+..+.........................+.....+....+........+...+.............+.....+.........+..........+........+.......+...+.....+.......+............+.....+...+.+..+...+......+.+.....+.......+..+....+..+.......+..+.............+......+..+..................+....+...+........+.+.....+.+...+..+...+.......+.....+....+.....+....+...........+.++++++
2025-10-19T03:08:20.224812663Z -----
2025-10-19T03:08:25.510026375Z New container detected. Setting up app folder and fixing permissions.
2025-10-19T03:09:06.986235127Z query: SELECT * FROM "sqlite_master" WHERE "type" = 'table' AND "name" = 'migrations'
2025-10-19T03:09:07.150718180Z query: CREATE TABLE "migrations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "timestamp" bigint NOT NULL, "name" varchar NOT NULL)
2025-10-19T03:09:07.247579427Z query: SELECT * FROM "migrations" "migrations" ORDER BY "id" DESC
2025-10-19T03:09:07.259454446Z 0 migrations are already loaded in the database.
2025-10-19T03:09:07.259839982Z 3 migrations were found in the source code.
2025-10-19T03:09:07.260199336Z 3 migrations are new migrations that needs to be executed.
2025-10-19T03:09:07.271466109Z query: BEGIN TRANSACTION
2025-10-19T03:09:07.306216645Z query: SELECT COUNT(*) FROM users
2025-10-19T03:09:07.347735748Z query failed: SELECT COUNT(*) FROM users
2025-10-19T03:09:07.358788321Z error: Error: SQLITE_ERROR: no such table: users
2025-10-19T03:09:07.358836538Z --> in Database#all('SELECT COUNT(*) FROM users', undefined, [Function: handler])
2025-10-19T03:09:07.358846648Z at SqliteQueryRunner.<anonymous> (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:60:56)
2025-10-19T03:09:07.358855556Z at step (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:143:27)
2025-10-19T03:09:07.358863883Z at Object.next (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:124:57)
2025-10-19T03:09:07.358872219Z at /app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:117:75
2025-10-19T03:09:07.358880456Z at new Promise (<anonymous>)
2025-10-19T03:09:07.358889294Z at Object.__awaiter (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:113:16)
2025-10-19T03:09:07.358897651Z at execute (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:54:64)
2025-10-19T03:09:07.358905717Z at SqliteQueryRunner.<anonymous> (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:101:46)
2025-10-19T03:09:07.358914244Z at step (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:143:27) {
2025-10-19T03:09:07.358922461Z errno: 1,
2025-10-19T03:09:07.358930417Z code: 'SQLITE_ERROR',
2025-10-19T03:09:07.358938373Z __augmented: true
2025-10-19T03:09:07.358946299Z }
2025-10-19T03:09:07.392389211Z query: CREATE TABLE "users" ("id" varchar PRIMARY KEY NOT NULL, "email" varchar NOT NULL, "password" varchar NOT NULL, "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')))
2025-10-19T03:09:07.419694937Z query: CREATE UNIQUE INDEX "IDX_97672ac88f789774dd47f7c8be" ON "users" ("email")
2025-10-19T03:09:07.480192631Z query: CREATE TABLE "budget_months" ("id" varchar PRIMARY KEY NOT NULL, "budgetId" varchar NOT NULL, "month" varchar NOT NULL, "income" integer NOT NULL DEFAULT (0), "budgeted" integer NOT NULL DEFAULT (0), "activity" integer NOT NULL DEFAULT (0), "underfunded" integer NOT NULL DEFAULT (0), "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')))
2025-10-19T03:09:07.502461085Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-10-19T03:09:07.518259844Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-10-19T03:09:07.562065050Z query: CREATE TABLE "category_months" ("id" varchar PRIMARY KEY NOT NULL, "categoryId" varchar NOT NULL, "budgetMonthId" varchar NOT NULL, "month" varchar NOT NULL, "budgeted" integer NOT NULL DEFAULT (0), "activity" integer NOT NULL DEFAULT (0), "balance" integer NOT NULL DEFAULT (0), "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')))
2025-10-19T03:09:07.579780748Z query: CREATE INDEX "IDX_cba488e36ca6ff6eec83e91440" ON "category_months" ("categoryId")
2025-10-19T03:09:07.588095699Z query: CREATE INDEX "IDX_de0f1ed5fe7ad4f2254bb815be" ON "category_months" ("budgetMonthId")
2025-10-19T03:09:07.598966636Z query: CREATE INDEX "IDX_23f4c8894717fb764a2b88ff29" ON "category_months" ("month")
2025-10-19T03:09:07.642509403Z query: CREATE TABLE "categories" ("id" varchar PRIMARY KEY NOT NULL, "budgetId" varchar NOT NULL, "categoryGroupId" varchar NOT NULL, "trackingAccountId" varchar, "name" varchar NOT NULL, "inflow" boolean NOT NULL DEFAULT (0), "locked" boolean NOT NULL DEFAULT (0), "order" integer NOT NULL DEFAULT (0), "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')))
2025-10-19T03:09:07.657198498Z query: CREATE INDEX "IDX_e6d5be2f8c1fbd283150e043a0" ON "categories" ("budgetId")
2025-10-19T03:09:07.669536529Z query: CREATE UNIQUE INDEX "IDX_af173d6048d44da16b00e49e24" ON "categories" ("trackingAccountId")
2025-10-19T03:09:07.700752187Z query: CREATE TABLE "payees" ("id" varchar PRIMARY KEY NOT NULL, "budgetId" varchar NOT NULL, "transferAccountId" varchar, "name" varchar NOT NULL, "internal" boolean NOT NULL, "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')), CONSTRAINT "REL_f61fc1e67d3abfb79503cdd382" UNIQUE ("transferAccountId"))
2025-10-19T03:09:07.740640908Z query: CREATE TABLE "transactions" ("id" varchar PRIMARY KEY NOT NULL, "budgetId" varchar NOT NULL, "accountId" varchar NOT NULL, "payeeId" varchar NOT NULL, "transferAccountId" varchar, "transferTransactionId" varchar, "categoryId" varchar, "amount" integer NOT NULL DEFAULT (0), "date" datetime NOT NULL, "memo" varchar NOT NULL DEFAULT (''), "status" integer NOT NULL DEFAULT (0), "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')))
2025-10-19T03:09:07.771863580Z query: CREATE INDEX "IDX_7098ffeb5373b7d6344f4f1663" ON "transactions" ("transferTransactionId")
2025-10-19T03:09:07.817418078Z query: CREATE TABLE "accounts" ("id" varchar PRIMARY KEY NOT NULL, "budgetId" varchar NOT NULL, "transferPayeeId" varchar, "name" varchar NOT NULL, "type" integer NOT NULL, "balance" integer NOT NULL DEFAULT (0), "cleared" integer NOT NULL DEFAULT (0), "uncleared" integer NOT NULL DEFAULT (0), "order" integer NOT NULL DEFAULT (0), "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')), CONSTRAINT "REL_c2a8be4512a377b0a8614170e3" UNIQUE ("transferPayeeId"))
2025-10-19T03:09:07.843046587Z query: CREATE TABLE "budgets" ("id" varchar PRIMARY KEY NOT NULL, "userId" varchar NOT NULL, "name" varchar NOT NULL, "toBeBudgeted" integer NOT NULL DEFAULT (0), "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')))
2025-10-19T03:09:07.869429866Z query: CREATE TABLE "category_groups" ("id" varchar PRIMARY KEY NOT NULL, "budgetId" varchar NOT NULL, "name" varchar NOT NULL, "internal" boolean NOT NULL DEFAULT (0), "locked" boolean NOT NULL DEFAULT (0), "order" integer NOT NULL DEFAULT (0), "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')))
2025-10-19T03:09:07.876525061Z query: CREATE INDEX "IDX_0dcceebef7c019bc892be7b5d0" ON "category_groups" ("budgetId")
2025-10-19T03:09:07.885069534Z query: DROP INDEX "IDX_398c07457719d1899ba4f11914"
2025-10-19T03:09:07.902613877Z query: DROP INDEX "IDX_0c21df54422306fdf78621fc18"
2025-10-19T03:09:07.936756348Z query: CREATE TABLE "temporary_budget_months" ("id" varchar PRIMARY KEY NOT NULL, "budgetId" varchar NOT NULL, "month" varchar NOT NULL, "income" integer NOT NULL DEFAULT (0), "budgeted" integer NOT NULL DEFAULT (0), "activity" integer NOT NULL DEFAULT (0), "underfunded" integer NOT NULL DEFAULT (0), "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')), CONSTRAINT "FK_398c07457719d1899ba4f11914d" FOREIGN KEY ("budgetId") REFERENCES "budgets" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
2025-10-19T03:09:07.961302519Z query: INSERT INTO "temporary_budget_months"("id", "budgetId", "month", "income", "budgeted", "activity", "underfunded", "created", "updated") SELECT "id", "budgetId", "month", "income", "budgeted", "activity", "underfunded", "created", "updated" FROM "budget_months"
2025-10-19T03:09:07.978688062Z query: DROP TABLE "budget_months"
2025-10-19T03:09:07.989232411Z query: ALTER TABLE "temporary_budget_months" RENAME TO "budget_months"
2025-10-19T03:09:08.058196271Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-10-19T03:09:08.071148959Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-10-19T03:09:08.077059609Z query: DROP INDEX "IDX_cba488e36ca6ff6eec83e91440"
2025-10-19T03:09:08.082007361Z query: DROP INDEX "IDX_de0f1ed5fe7ad4f2254bb815be"
2025-10-19T03:09:08.086820201Z query: DROP INDEX "IDX_23f4c8894717fb764a2b88ff29"
2025-10-19T03:09:08.127104368Z query: CREATE TABLE "temporary_category_months" ("id" varchar PRIMARY KEY NOT NULL, "categoryId" varchar NOT NULL, "budgetMonthId" varchar NOT NULL, "month" varchar NOT NULL, "budgeted" integer NOT NULL DEFAULT (0), "activity" integer NOT NULL DEFAULT (0), "balance" integer NOT NULL DEFAULT (0), "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')), CONSTRAINT "FK_cba488e36ca6ff6eec83e914409" FOREIGN KEY ("categoryId") REFERENCES "categories" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT "FK_de0f1ed5fe7ad4f2254bb815bef" FOREIGN KEY ("budgetMonthId") REFERENCES "budget_months" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
2025-10-19T03:09:08.138535723Z query: INSERT INTO "temporary_category_months"("id", "categoryId", "budgetMonthId", "month", "budgeted", "activity", "balance", "created", "updated") SELECT "id", "categoryId", "budgetMonthId", "month", "budgeted", "activity", "balance", "created", "updated" FROM "category_months"
2025-10-19T03:09:08.142695518Z query: DROP TABLE "category_months"
2025-10-19T03:09:08.147813102Z query: ALTER TABLE "temporary_category_months" RENAME TO "category_months"
2025-10-19T03:09:08.181177717Z query: CREATE INDEX "IDX_cba488e36ca6ff6eec83e91440" ON "category_months" ("categoryId")
2025-10-19T03:09:08.196055962Z query: CREATE INDEX "IDX_de0f1ed5fe7ad4f2254bb815be" ON "category_months" ("budgetMonthId")
2025-10-19T03:09:08.201295271Z query: CREATE INDEX "IDX_23f4c8894717fb764a2b88ff29" ON "category_months" ("month")
2025-10-19T03:09:08.205477210Z query: DROP INDEX "IDX_e6d5be2f8c1fbd283150e043a0"
2025-10-19T03:09:08.209268403Z query: DROP INDEX "IDX_af173d6048d44da16b00e49e24"
2025-10-19T03:09:08.243147785Z query: CREATE TABLE "temporary_categories" ("id" varchar PRIMARY KEY NOT NULL, "budgetId" varchar NOT NULL, "categoryGroupId" varchar NOT NULL, "trackingAccountId" varchar, "name" varchar NOT NULL, "inflow" boolean NOT NULL DEFAULT (0), "locked" boolean NOT NULL DEFAULT (0), "order" integer NOT NULL DEFAULT (0), "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')), CONSTRAINT "FK_e6d5be2f8c1fbd283150e043a08" FOREIGN KEY ("budgetId") REFERENCES "budgets" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT "FK_d05bb3b46b9b190eb9c20ad3c21" FOREIGN KEY ("categoryGroupId") REFERENCES "category_groups" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
2025-10-19T03:09:08.256171697Z query: INSERT INTO "temporary_categories"("id", "budgetId", "categoryGroupId", "trackingAccountId", "name", "inflow", "locked", "order", "created", "updated") SELECT "id", "budgetId", "categoryGroupId", "trackingAccountId", "name", "inflow", "locked", "order", "created", "updated" FROM "categories"
2025-10-19T03:09:08.260151309Z query: DROP TABLE "categories"
2025-10-19T03:09:08.276090310Z query: ALTER TABLE "temporary_categories" RENAME TO "categories"
2025-10-19T03:09:08.308721629Z query: CREATE INDEX "IDX_e6d5be2f8c1fbd283150e043a0" ON "categories" ("budgetId")
2025-10-19T03:09:08.316612306Z query: CREATE UNIQUE INDEX "IDX_af173d6048d44da16b00e49e24" ON "categories" ("trackingAccountId")
2025-10-19T03:09:08.358843993Z query: CREATE TABLE "temporary_payees" ("id" varchar PRIMARY KEY NOT NULL, "budgetId" varchar NOT NULL, "transferAccountId" varchar, "name" varchar NOT NULL, "internal" boolean NOT NULL, "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')), CONSTRAINT "REL_f61fc1e67d3abfb79503cdd382" UNIQUE ("transferAccountId"), CONSTRAINT "FK_f61fc1e67d3abfb79503cdd3821" FOREIGN KEY ("transferAccountId") REFERENCES "accounts" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
2025-10-19T03:09:08.371626609Z query: INSERT INTO "temporary_payees"("id", "budgetId", "transferAccountId", "name", "internal", "created", "updated") SELECT "id", "budgetId", "transferAccountId", "name", "internal", "created", "updated" FROM "payees"
2025-10-19T03:09:08.375799781Z query: DROP TABLE "payees"
2025-10-19T03:09:08.381482803Z query: ALTER TABLE "temporary_payees" RENAME TO "payees"
2025-10-19T03:09:08.406637879Z query: DROP INDEX "IDX_7098ffeb5373b7d6344f4f1663"
2025-10-19T03:09:08.448194979Z query: CREATE TABLE "temporary_transactions" ("id" varchar PRIMARY KEY NOT NULL, "budgetId" varchar NOT NULL, "accountId" varchar NOT NULL, "payeeId" varchar NOT NULL, "transferAccountId" varchar, "transferTransactionId" varchar, "categoryId" varchar, "amount" integer NOT NULL DEFAULT (0), "date" datetime NOT NULL, "memo" varchar NOT NULL DEFAULT (''), "status" integer NOT NULL DEFAULT (0), "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')), CONSTRAINT "FK_9552f6354aafa8f1818aa571aaf" FOREIGN KEY ("budgetId") REFERENCES "budgets" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT "FK_26d8aec71ae9efbe468043cd2b9" FOREIGN KEY ("accountId") REFERENCES "accounts" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT "FK_44075a45926dfce0379d2c81c83" FOREIGN KEY ("payeeId") REFERENCES "payees" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT "FK_86e965e74f9cc66149cf6c90f64" FOREIGN KEY ("categoryId") REFERENCES "categories" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
2025-10-19T03:09:08.464600709Z query: INSERT INTO "temporary_transactions"("id", "budgetId", "accountId", "payeeId", "transferAccountId", "transferTransactionId", "categoryId", "amount", "date", "memo", "status", "created", "updated") SELECT "id", "budgetId", "accountId", "payeeId", "transferAccountId", "transferTransactionId", "categoryId", "amount", "date", "memo", "status", "created", "updated" FROM "transactions"
2025-10-19T03:09:08.469067613Z query: DROP TABLE "transactions"
2025-10-19T03:09:08.474166729Z query: ALTER TABLE "temporary_transactions" RENAME TO "transactions"
2025-10-19T03:09:08.505375444Z query: CREATE INDEX "IDX_7098ffeb5373b7d6344f4f1663" ON "transactions" ("transferTransactionId")
2025-10-19T03:09:08.539992771Z query: CREATE TABLE "temporary_accounts" ("id" varchar PRIMARY KEY NOT NULL, "budgetId" varchar NOT NULL, "transferPayeeId" varchar, "name" varchar NOT NULL, "type" integer NOT NULL, "balance" integer NOT NULL DEFAULT (0), "cleared" integer NOT NULL DEFAULT (0), "uncleared" integer NOT NULL DEFAULT (0), "order" integer NOT NULL DEFAULT (0), "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')), CONSTRAINT "REL_c2a8be4512a377b0a8614170e3" UNIQUE ("transferPayeeId"), CONSTRAINT "FK_81acfbf2205a3be5b1c41455329" FOREIGN KEY ("budgetId") REFERENCES "budgets" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT "FK_c2a8be4512a377b0a8614170e33" FOREIGN KEY ("transferPayeeId") REFERENCES "payees" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
2025-10-19T03:09:08.551788239Z query: INSERT INTO "temporary_accounts"("id", "budgetId", "transferPayeeId", "name", "type", "balance", "cleared", "uncleared", "order", "created", "updated") SELECT "id", "budgetId", "transferPayeeId", "name", "type", "balance", "cleared", "uncleared", "order", "created", "updated" FROM "accounts"
2025-10-19T03:09:08.555292655Z query: DROP TABLE "accounts"
2025-10-19T03:09:08.561332034Z query: ALTER TABLE "temporary_accounts" RENAME TO "accounts"
2025-10-19T03:09:08.605273795Z query: CREATE TABLE "temporary_budgets" ("id" varchar PRIMARY KEY NOT NULL, "userId" varchar NOT NULL, "name" varchar NOT NULL, "toBeBudgeted" integer NOT NULL DEFAULT (0), "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')), CONSTRAINT "FK_27e688ddf1ff3893b43065899f9" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
2025-10-19T03:09:08.613669128Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "toBeBudgeted", "created", "updated") SELECT "id", "userId", "name", "toBeBudgeted", "created", "updated" FROM "budgets"
2025-10-19T03:09:08.616999644Z query: DROP TABLE "budgets"
2025-10-19T03:09:08.624161423Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-10-19T03:09:08.654452339Z query: DROP INDEX "IDX_0dcceebef7c019bc892be7b5d0"
2025-10-19T03:09:08.685411842Z query: CREATE TABLE "temporary_category_groups" ("id" varchar PRIMARY KEY NOT NULL, "budgetId" varchar NOT NULL, "name" varchar NOT NULL, "internal" boolean NOT NULL DEFAULT (0), "locked" boolean NOT NULL DEFAULT (0), "order" integer NOT NULL DEFAULT (0), "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')), CONSTRAINT "FK_0dcceebef7c019bc892be7b5d0e" FOREIGN KEY ("budgetId") REFERENCES "budgets" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
2025-10-19T03:09:08.697654050Z query: INSERT INTO "temporary_category_groups"("id", "budgetId", "name", "internal", "locked", "order", "created", "updated") SELECT "id", "budgetId", "name", "internal", "locked", "order", "created", "updated" FROM "category_groups"
2025-10-19T03:09:08.702410637Z query: DROP TABLE "category_groups"
2025-10-19T03:09:08.709041377Z query: ALTER TABLE "temporary_category_groups" RENAME TO "category_groups"
2025-10-19T03:09:08.740995632Z query: CREATE INDEX "IDX_0dcceebef7c019bc892be7b5d0" ON "category_groups" ("budgetId")
2025-10-19T03:09:08.791155993Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1649259669912,"initial1649259669912"]
2025-10-19T03:09:08.802627179Z Migration initial1649259669912 has been executed successfully.
2025-10-19T03:09:08.819734151Z query: CREATE TABLE "temporary_budgets" ("id" varchar PRIMARY KEY NOT NULL, "userId" varchar NOT NULL, "name" varchar NOT NULL, "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')), CONSTRAINT "FK_27e688ddf1ff3893b43065899f9" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
2025-10-19T03:09:08.830036153Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "created", "updated") SELECT "id", "userId", "name", "created", "updated" FROM "budgets"
2025-10-19T03:09:08.834211590Z query: DROP TABLE "budgets"
2025-10-19T03:09:08.852492656Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-10-19T03:09:08.885595033Z query: DROP INDEX "IDX_0c21df54422306fdf78621fc18"
2025-10-19T03:09:08.889185361Z query: DROP INDEX "IDX_398c07457719d1899ba4f11914"
2025-10-19T03:09:08.921041329Z query: CREATE TABLE "temporary_budget_months" ("id" varchar PRIMARY KEY NOT NULL, "budgetId" varchar NOT NULL, "month" varchar NOT NULL, "income" integer NOT NULL DEFAULT (0), "budgeted" integer NOT NULL DEFAULT (0), "activity" integer NOT NULL DEFAULT (0), "underfunded" integer NOT NULL DEFAULT (0), "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')), "available" integer NOT NULL DEFAULT (0), CONSTRAINT "FK_398c07457719d1899ba4f11914d" FOREIGN KEY ("budgetId") REFERENCES "budgets" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
2025-10-19T03:09:08.932469618Z query: INSERT INTO "temporary_budget_months"("id", "budgetId", "month", "income", "budgeted", "activity", "underfunded", "created", "updated") SELECT "id", "budgetId", "month", "income", "budgeted", "activity", "underfunded", "created", "updated" FROM "budget_months"
2025-10-19T03:09:08.938524829Z query: DROP TABLE "budget_months"
2025-10-19T03:09:08.945030468Z query: ALTER TABLE "temporary_budget_months" RENAME TO "budget_months"
2025-10-19T03:09:08.980146749Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-10-19T03:09:08.985050603Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-10-19T03:09:09.001531405Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1649260258195,"budgetMonthAvailable1649260258195"]
2025-10-19T03:09:09.004711207Z Migration budgetMonthAvailable1649260258195 has been executed successfully.
2025-10-19T03:09:09.022810487Z query: CREATE TABLE "temporary_budgets" ("id" varchar PRIMARY KEY NOT NULL, "userId" varchar NOT NULL, "name" varchar NOT NULL, "created" datetime NOT NULL DEFAULT (datetime('now')), "updated" datetime NOT NULL DEFAULT (datetime('now')), "currency" varchar NOT NULL DEFAULT ('USD'), CONSTRAINT "FK_27e688ddf1ff3893b43065899f9" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION)
2025-10-19T03:09:09.031696287Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "created", "updated") SELECT "id", "userId", "name", "created", "updated" FROM "budgets"
2025-10-19T03:09:09.035179049Z query: DROP TABLE "budgets"
2025-10-19T03:09:09.040506987Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-10-19T03:09:09.072217942Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1650032177205,"addBudgetCurrency1650032177205"]
2025-10-19T03:09:09.074874320Z Migration addBudgetCurrency1650032177205 has been executed successfully.
2025-10-19T03:09:09.078561033Z query: COMMIT
2025-10-19T03:09:21.237781276Z [custom-init] No custom files found, skipping...
2025-10-19T03:09:25.522038096Z
2025-10-19T03:09:25.522078908Z > BudgE@0.0.8 start
2025-10-19T03:09:25.522089149Z > node build/src/server.js
2025-10-19T03:09:25.522097626Z
2025-10-19T03:09:37.525625305Z !!!WARNING!!! Running in development mode!
2025-10-19T03:09:38.484706504Z Server listening on: http://0.0.0.0:5000
2025-10-19T03:09:39.043924955Z Connection to localhost (127.0.0.1) 5000 port [tcp/*] succeeded!
2025-10-19T03:09:39.914590221Z [ls.io-init] done.
2025-10-19T03:09:41.712825613Z Error: You must be logged in to do that
2025-10-19T03:09:41.712864241Z at /app/www/public/backend/build/src/middleware/authentication.js:41:23
2025-10-19T03:09:41.712874412Z at Generator.next (<anonymous>)
2025-10-19T03:09:41.712883099Z at /app/www/public/backend/build/src/middleware/authentication.js:8:71
2025-10-19T03:09:41.712891316Z at new Promise (<anonymous>)
2025-10-19T03:09:41.712899572Z at __awaiter (/app/www/public/backend/build/src/middleware/authentication.js:4:12)
2025-10-19T03:09:41.712907739Z at expressAuthentication (/app/www/public/backend/build/src/middleware/authentication.js:22:12)
2025-10-19T03:09:41.712915955Z at /app/www/public/backend/build/routes.js:1245:97
2025-10-19T03:09:41.712923991Z at Generator.next (<anonymous>)
2025-10-19T03:09:41.712932088Z at /app/www/public/backend/build/routes.js:8:71
2025-10-19T03:09:41.712940475Z at new Promise (<anonymous>) {
2025-10-19T03:09:41.712948731Z status: 401
2025-10-19T03:09:41.712956687Z }