2025-07-27T03:33:07.434012285Z [migrations] started
2025-07-27T03:33:07.439919719Z [migrations] 01-nginx-site-confs-default: executing...
2025-07-27T03:33:07.452239227Z [migrations] 01-nginx-site-confs-default: succeeded
2025-07-27T03:33:07.456371668Z [migrations] 02-default-location: executing...
2025-07-27T03:33:07.463204887Z [migrations] 02-default-location: succeeded
2025-07-27T03:33:07.463235909Z [migrations] done
2025-07-27T03:33:07.474692840Z usermod: no changes
2025-07-27T03:33:07.477633240Z ───────────────────────────────────────
2025-07-27T03:33:07.477643251Z
2025-07-27T03:33:07.477647239Z ██╗ ███████╗██╗ ██████╗
2025-07-27T03:33:07.477651056Z ██║ ██╔════╝██║██╔═══██╗
2025-07-27T03:33:07.477654774Z ██║ ███████╗██║██║ ██║
2025-07-27T03:33:07.477658461Z ██║ ╚════██║██║██║ ██║
2025-07-27T03:33:07.477662099Z ███████╗███████║██║╚██████╔╝
2025-07-27T03:33:07.477665766Z ╚══════╝╚══════╝╚═╝ ╚═════╝
2025-07-27T03:33:07.477669453Z
2025-07-27T03:33:07.477672950Z Brought to you by linuxserver.io
2025-07-27T03:33:07.477676548Z ───────────────────────────────────────
2025-07-27T03:33:07.478129760Z
2025-07-27T03:33:07.478135372Z To support LSIO projects visit:
2025-07-27T03:33:07.478139199Z https://www.linuxserver.io/donate/
2025-07-27T03:33:07.478142957Z
2025-07-27T03:33:07.478146544Z ───────────────────────────────────────
2025-07-27T03:33:07.478150572Z GID/UID
2025-07-27T03:33:07.478154139Z ───────────────────────────────────────
2025-07-27T03:33:07.483032302Z
2025-07-27T03:33:07.483049978Z User UID: 911
2025-07-27T03:33:07.483054006Z User GID: 911
2025-07-27T03:33:07.483057723Z ───────────────────────────────────────
2025-07-27T03:33:07.484728688Z Linuxserver.io version: 0.0.9-ls160
2025-07-27T03:33:07.484995646Z Build-date: 2025-07-27T03:23:50+00:00
2025-07-27T03:33:07.484999463Z ───────────────────────────────────────
2025-07-27T03:33:07.485003351Z
2025-07-27T03:33:07.559451872Z Setting resolver to 8.8.8.8 8.8.4.4
2025-07-27T03:33:07.568041157Z Setting worker_processes to 64
2025-07-27T03:33:07.591709026Z generating self-signed keys in /config/keys, you can replace these with your own keys if required
2025-07-27T03:33:07.605257728Z ...+++++++++++++++++++++++++++++++++++++++*.......+..+......+.+.....+.+.....+....+......+.....+.........+...+.+..+.........+......+...+.+........+.+.....+.+.....+.+..+.......+......+...+..+.........+.+.....+.........+.+...+.....+++++++++++++++++++++++++++++++++++++++*.....+..+......+.+........+.......+.....+.+.....++++++
2025-07-27T03:33:07.727510047Z ..+..+...................+...+.....+..........+...+...+.....+.+.....+...+......+.......+++++++++++++++++++++++++++++++++++++++*.......+....+......+...+...........+.........+.+.....+.......+..+...+.........+++++++++++++++++++++++++++++++++++++++*....+.............+..+..........+...+.....+..........+.....+...+....+......+......+.....+......+.......+...+...+......+...+.....+.+.....+......+.+............+...+.........+.....+....+.....+....+..+...+............+.........+.+.........+.....+.+.....+....+......+......+...............+.....+...+......+.................................+.......+........+...+.............+.....+......+....+......+.....+...+...+.............+..+...+....+..+.+...+..+....+...+...........+.......+..+..........+......+...........+...+.+..............+............+......+.......+.....+.+.........+......+..+...+.+......+..+......+.......+.................+...+....+...+.................+.+............+.....+.......+...+..+....+..+....+........+...+...................+.....+.............+..+.+.........+...........+........................+....+..+...+.+......+...+.........+...+..+.+...............+.........+..+......+...+.....................+.+..+.+.........+..+......+...+.......+...+.....+.+...+...+........+.......+.....+....+........+...+..........+...+.....+.......+..+.+.............................+.+......+.....+..........+...............+..............+....+...+...+.........+..+...+..................+.............+............+.........+......+.....+...+...............+.......+...+..+...+..........+.........+......+..+....+..............+.+...+..+.....................+............+...+....+...+......+.....+....+..+.+...+......+.....+...+.+............+..............+.+..+.+.....+.+......+..+.......+.....+.+........+.+..................+...+.................+...+.......+...+...+..+...+.+.....+...+............+....+...........+.+.....+..........+...+.....+....+...+..+............+..........+...+...+...+......+........+.+.................+...+....+...+..+..........+...+.....+..........+............................................+....+.....+.........+.+.....+.......+..+...+.........+.+...+.....+....+........+....+...+..+....+.....+.+...............+......+........+.........+...+....+...+..+.........+.+...........+.........+.+..................+..+....+........+.............+..+......+......+..........+........+.......+.....+......++++++
2025-07-27T03:33:07.730751925Z -----
2025-07-27T03:33:07.776475215Z New container detected. Setting up app folder and fixing permissions.
2025-07-27T03:33:25.055972803Z query: SELECT * FROM "sqlite_master" WHERE "type" = 'table' AND "name" = 'migrations'
2025-07-27T03:33:25.061644734Z query: CREATE TABLE "migrations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "timestamp" bigint NOT NULL, "name" varchar NOT NULL)
2025-07-27T03:33:25.119962113Z query: SELECT * FROM "migrations" "migrations" ORDER BY "id" DESC
2025-07-27T03:33:25.121167560Z 0 migrations are already loaded in the database.
2025-07-27T03:33:25.121202781Z 3 migrations were found in the source code.
2025-07-27T03:33:25.121214795Z 3 migrations are new migrations that needs to be executed.
2025-07-27T03:33:25.121901749Z query: BEGIN TRANSACTION
2025-07-27T03:33:25.124157962Z query: SELECT COUNT(*) FROM users
2025-07-27T03:33:25.126367601Z query failed: SELECT COUNT(*) FROM users
2025-07-27T03:33:25.128967456Z error: Error: SQLITE_ERROR: no such table: users
2025-07-27T03:33:25.128981334Z --> in Database#all('SELECT COUNT(*) FROM users', undefined, [Function: handler])
2025-07-27T03:33:25.128990633Z at SqliteQueryRunner.<anonymous> (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:60:56)
2025-07-27T03:33:25.128999441Z at step (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:143:27)
2025-07-27T03:33:25.129007697Z at Object.next (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:124:57)
2025-07-27T03:33:25.129016074Z at /app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:117:75
2025-07-27T03:33:25.129024201Z at new Promise (<anonymous>)
2025-07-27T03:33:25.129032487Z at Object.__awaiter (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:113:16)
2025-07-27T03:33:25.129040664Z at execute (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:54:64)
2025-07-27T03:33:25.129048991Z at SqliteQueryRunner.<anonymous> (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:101:46)
2025-07-27T03:33:25.129057528Z at step (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:143:27) {
2025-07-27T03:33:25.129065915Z errno: 1,
2025-07-27T03:33:25.129073750Z code: 'SQLITE_ERROR',
2025-07-27T03:33:25.129081737Z __augmented: true
2025-07-27T03:33:25.129089642Z }
2025-07-27T03:33:25.132622346Z 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-07-27T03:33:25.134213270Z query: CREATE UNIQUE INDEX "IDX_97672ac88f789774dd47f7c8be" ON "users" ("email")
2025-07-27T03:33:25.139497109Z 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-07-27T03:33:25.141220800Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-07-27T03:33:25.142559846Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-07-27T03:33:25.146904986Z 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-07-27T03:33:25.149462966Z query: CREATE INDEX "IDX_cba488e36ca6ff6eec83e91440" ON "category_months" ("categoryId")
2025-07-27T03:33:25.150542049Z query: CREATE INDEX "IDX_de0f1ed5fe7ad4f2254bb815be" ON "category_months" ("budgetMonthId")
2025-07-27T03:33:25.151570470Z query: CREATE INDEX "IDX_23f4c8894717fb764a2b88ff29" ON "category_months" ("month")
2025-07-27T03:33:25.155608682Z 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-07-27T03:33:25.156861274Z query: CREATE INDEX "IDX_e6d5be2f8c1fbd283150e043a0" ON "categories" ("budgetId")
2025-07-27T03:33:25.158370874Z query: CREATE UNIQUE INDEX "IDX_af173d6048d44da16b00e49e24" ON "categories" ("trackingAccountId")
2025-07-27T03:33:25.162127378Z 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-07-27T03:33:25.168349757Z 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-07-27T03:33:25.171281220Z query: CREATE INDEX "IDX_7098ffeb5373b7d6344f4f1663" ON "transactions" ("transferTransactionId")
2025-07-27T03:33:25.179186769Z 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-07-27T03:33:25.182636345Z 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-07-27T03:33:25.186256615Z 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-07-27T03:33:25.187328994Z query: CREATE INDEX "IDX_0dcceebef7c019bc892be7b5d0" ON "category_groups" ("budgetId")
2025-07-27T03:33:25.188621216Z query: DROP INDEX "IDX_398c07457719d1899ba4f11914"
2025-07-27T03:33:25.189532551Z query: DROP INDEX "IDX_0c21df54422306fdf78621fc18"
2025-07-27T03:33:25.194728514Z 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-07-27T03:33:25.197653804Z 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-07-27T03:33:25.198555230Z query: DROP TABLE "budget_months"
2025-07-27T03:33:25.199920749Z query: ALTER TABLE "temporary_budget_months" RENAME TO "budget_months"
2025-07-27T03:33:25.206912157Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-07-27T03:33:25.208541689Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-07-27T03:33:25.210117331Z query: DROP INDEX "IDX_cba488e36ca6ff6eec83e91440"
2025-07-27T03:33:25.211585527Z query: DROP INDEX "IDX_de0f1ed5fe7ad4f2254bb815be"
2025-07-27T03:33:25.212328524Z query: DROP INDEX "IDX_23f4c8894717fb764a2b88ff29"
2025-07-27T03:33:25.216188256Z 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-07-27T03:33:25.223662646Z 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-07-27T03:33:25.224253937Z query: DROP TABLE "category_months"
2025-07-27T03:33:25.225275504Z query: ALTER TABLE "temporary_category_months" RENAME TO "category_months"
2025-07-27T03:33:25.229292062Z query: CREATE INDEX "IDX_cba488e36ca6ff6eec83e91440" ON "category_months" ("categoryId")
2025-07-27T03:33:25.230158707Z query: CREATE INDEX "IDX_de0f1ed5fe7ad4f2254bb815be" ON "category_months" ("budgetMonthId")
2025-07-27T03:33:25.230908828Z query: CREATE INDEX "IDX_23f4c8894717fb764a2b88ff29" ON "category_months" ("month")
2025-07-27T03:33:25.231584508Z query: DROP INDEX "IDX_e6d5be2f8c1fbd283150e043a0"
2025-07-27T03:33:25.232287323Z query: DROP INDEX "IDX_af173d6048d44da16b00e49e24"
2025-07-27T03:33:25.237186949Z 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-07-27T03:33:25.238740126Z 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-07-27T03:33:25.239322259Z query: DROP TABLE "categories"
2025-07-27T03:33:25.240492455Z query: ALTER TABLE "temporary_categories" RENAME TO "categories"
2025-07-27T03:33:25.245134032Z query: CREATE INDEX "IDX_e6d5be2f8c1fbd283150e043a0" ON "categories" ("budgetId")
2025-07-27T03:33:25.245965756Z query: CREATE UNIQUE INDEX "IDX_af173d6048d44da16b00e49e24" ON "categories" ("trackingAccountId")
2025-07-27T03:33:25.249400763Z 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-07-27T03:33:25.250599527Z query: INSERT INTO "temporary_payees"("id", "budgetId", "transferAccountId", "name", "internal", "created", "updated") SELECT "id", "budgetId", "transferAccountId", "name", "internal", "created", "updated" FROM "payees"
2025-07-27T03:33:25.251190006Z query: DROP TABLE "payees"
2025-07-27T03:33:25.252602300Z query: ALTER TABLE "temporary_payees" RENAME TO "payees"
2025-07-27T03:33:25.257162132Z query: DROP INDEX "IDX_7098ffeb5373b7d6344f4f1663"
2025-07-27T03:33:25.262583047Z 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-07-27T03:33:25.264812356Z 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-07-27T03:33:25.265625764Z query: DROP TABLE "transactions"
2025-07-27T03:33:25.266888106Z query: ALTER TABLE "temporary_transactions" RENAME TO "transactions"
2025-07-27T03:33:25.271332636Z query: CREATE INDEX "IDX_7098ffeb5373b7d6344f4f1663" ON "transactions" ("transferTransactionId")
2025-07-27T03:33:25.276283695Z 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-07-27T03:33:25.277551879Z 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-07-27T03:33:25.278042357Z query: DROP TABLE "accounts"
2025-07-27T03:33:25.279254968Z query: ALTER TABLE "temporary_accounts" RENAME TO "accounts"
2025-07-27T03:33:25.284169114Z 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-07-27T03:33:25.285325141Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "toBeBudgeted", "created", "updated") SELECT "id", "userId", "name", "toBeBudgeted", "created", "updated" FROM "budgets"
2025-07-27T03:33:25.285803815Z query: DROP TABLE "budgets"
2025-07-27T03:33:25.287011196Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-07-27T03:33:25.290475772Z query: DROP INDEX "IDX_0dcceebef7c019bc892be7b5d0"
2025-07-27T03:33:25.292956568Z 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-07-27T03:33:25.294144059Z 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-07-27T03:33:25.294656661Z query: DROP TABLE "category_groups"
2025-07-27T03:33:25.295657096Z query: ALTER TABLE "temporary_category_groups" RENAME TO "category_groups"
2025-07-27T03:33:25.299239770Z query: CREATE INDEX "IDX_0dcceebef7c019bc892be7b5d0" ON "category_groups" ("budgetId")
2025-07-27T03:33:25.304485142Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1649259669912,"initial1649259669912"]
2025-07-27T03:33:25.305153618Z Migration initial1649259669912 has been executed successfully.
2025-07-27T03:33:25.307119978Z 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-07-27T03:33:25.308705551Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "created", "updated") SELECT "id", "userId", "name", "created", "updated" FROM "budgets"
2025-07-27T03:33:25.309477004Z query: DROP TABLE "budgets"
2025-07-27T03:33:25.310819918Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-07-27T03:33:25.315130558Z query: DROP INDEX "IDX_0c21df54422306fdf78621fc18"
2025-07-27T03:33:25.315796258Z query: DROP INDEX "IDX_398c07457719d1899ba4f11914"
2025-07-27T03:33:25.321468009Z 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-07-27T03:33:25.323528188Z 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-07-27T03:33:25.324435004Z query: DROP TABLE "budget_months"
2025-07-27T03:33:25.325891036Z query: ALTER TABLE "temporary_budget_months" RENAME TO "budget_months"
2025-07-27T03:33:25.330581631Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-07-27T03:33:25.331390339Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-07-27T03:33:25.333518995Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1649260258195,"budgetMonthAvailable1649260258195"]
2025-07-27T03:33:25.333861084Z Migration budgetMonthAvailable1649260258195 has been executed successfully.
2025-07-27T03:33:25.336532403Z 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-07-27T03:33:25.337689954Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "created", "updated") SELECT "id", "userId", "name", "created", "updated" FROM "budgets"
2025-07-27T03:33:25.338246665Z query: DROP TABLE "budgets"
2025-07-27T03:33:25.339712677Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-07-27T03:33:25.344160122Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1650032177205,"addBudgetCurrency1650032177205"]
2025-07-27T03:33:25.344477932Z Migration addBudgetCurrency1650032177205 has been executed successfully.
2025-07-27T03:33:25.345331040Z query: COMMIT
2025-07-27T03:33:29.665231767Z [custom-init] No custom files found, skipping...
2025-07-27T03:33:29.834809822Z
2025-07-27T03:33:29.834833530Z > BudgE@0.0.8 start
2025-07-27T03:33:29.834838049Z > node build/src/server.js
2025-07-27T03:33:29.834841726Z
2025-07-27T03:33:30.910763974Z !!!WARNING!!! Running in development mode!
2025-07-27T03:33:30.990828935Z Server listening on: http://0.0.0.0:5000
2025-07-27T03:33:31.691931679Z Connection to localhost (127.0.0.1) 5000 port [tcp/*] succeeded!
2025-07-27T03:33:31.727832890Z [ls.io-init] done.
2025-07-27T03:33:34.223904349Z Error: You must be logged in to do that
2025-07-27T03:33:34.223945552Z at /app/www/public/backend/build/src/middleware/authentication.js:41:23
2025-07-27T03:33:34.223976585Z at Generator.next (<anonymous>)
2025-07-27T03:33:34.223986094Z at /app/www/public/backend/build/src/middleware/authentication.js:8:71
2025-07-27T03:33:34.223994611Z at new Promise (<anonymous>)
2025-07-27T03:33:34.224003469Z at __awaiter (/app/www/public/backend/build/src/middleware/authentication.js:4:12)
2025-07-27T03:33:34.224029621Z at expressAuthentication (/app/www/public/backend/build/src/middleware/authentication.js:22:12)
2025-07-27T03:33:34.224037898Z at /app/www/public/backend/build/routes.js:1245:97
2025-07-27T03:33:34.224045844Z at Generator.next (<anonymous>)
2025-07-27T03:33:34.224053790Z at /app/www/public/backend/build/routes.js:8:71
2025-07-27T03:33:34.224061816Z at new Promise (<anonymous>) {
2025-07-27T03:33:34.224069993Z status: 401
2025-07-27T03:33:34.224078239Z }