2025-08-24T03:13:18.402831739Z [migrations] started
2025-08-24T03:13:18.505724492Z [migrations] 01-nginx-site-confs-default: executing...
2025-08-24T03:13:18.751532118Z [migrations] 01-nginx-site-confs-default: succeeded
2025-08-24T03:13:18.802063422Z [migrations] 02-default-location: executing...
2025-08-24T03:13:19.010376044Z [migrations] 02-default-location: succeeded
2025-08-24T03:13:19.010712111Z [migrations] done
2025-08-24T03:13:19.425630911Z usermod: no changes
2025-08-24T03:13:19.468182283Z ───────────────────────────────────────
2025-08-24T03:13:19.468225109Z
2025-08-24T03:13:19.468234869Z ██╗ ███████╗██╗ ██████╗
2025-08-24T03:13:19.468243807Z ██║ ██╔════╝██║██╔═══██╗
2025-08-24T03:13:19.468252294Z ██║ ███████╗██║██║ ██║
2025-08-24T03:13:19.468260640Z ██║ ╚════██║██║██║ ██║
2025-08-24T03:13:19.468268877Z ███████╗███████║██║╚██████╔╝
2025-08-24T03:13:19.468278096Z ╚══════╝╚══════╝╚═╝ ╚═════╝
2025-08-24T03:13:19.468286573Z
2025-08-24T03:13:19.468294569Z Brought to you by linuxserver.io
2025-08-24T03:13:19.468302825Z ───────────────────────────────────────
2025-08-24T03:13:19.473807676Z
2025-08-24T03:13:19.473843228Z To support LSIO projects visit:
2025-08-24T03:13:19.473855202Z https://www.linuxserver.io/donate/
2025-08-24T03:13:19.473865803Z
2025-08-24T03:13:19.473876815Z ───────────────────────────────────────
2025-08-24T03:13:19.473890513Z GID/UID
2025-08-24T03:13:19.474053190Z ───────────────────────────────────────
2025-08-24T03:13:19.539313052Z
2025-08-24T03:13:19.539356029Z User UID: 911
2025-08-24T03:13:19.539366159Z User GID: 911
2025-08-24T03:13:19.539375568Z ───────────────────────────────────────
2025-08-24T03:13:19.572481787Z Linuxserver.io version: 0.0.9-ls163
2025-08-24T03:13:19.575709404Z Build-date: 2025-08-24T03:02:26+00:00
2025-08-24T03:13:19.575753754Z ───────────────────────────────────────
2025-08-24T03:13:19.575764826Z
2025-08-24T03:13:22.075459752Z Setting resolver to 8.8.8.8 8.8.4.4
2025-08-24T03:13:22.160794883Z Setting worker_processes to 64
2025-08-24T03:13:22.953233463Z generating self-signed keys in /config/keys, you can replace these with your own keys if required
2025-08-24T03:13:23.476501810Z ...+..+.+......+..................+..+....+..+............+..........+......+..+.......+........+...+.........+.+.....+.+.....+.+...+......+...+........+...+....+..+...............+.+.........+...+.....+......+..........+..+....+...+...........+...............+++++++++++++++++++++++++++++++++++++++*.....+..+............+.+........+.+......+..+++++++++++++++++++++++++++++++++++++++*.........+.+.........+..+.+.....+.............+...........+...+...+.........+....+...............+...........+.+..+......+.......+.....+.........+...+...+....+...+...+...+.....+......+......+....+...+..+...+.+..+....+........+...+....+...+...........+.......+..+.......+.....+.+.........+...+...+.....+...+......+.+..+.......+...+.....+.............+..+.......+...+..+.+.........+........+......+......+.+..+.......+...+...+.....+...+................+........+.+..+...+....+........+...+.........+................+.....+.......+.....+.........+..................+.+..+...............+....+...........+.......+..+...+......+.+......+..+......+.+......+.........+...+......+..+...+....+..+.............+.....+.+...............+..+....+...............+.....+...+......+......+.........+.+...+...++++++
2025-08-24T03:13:24.164034736Z .+....+..+.............+.....+......+....+..................+...+............+..+...+...+.+...+............+.....+......+...+++++++++++++++++++++++++++++++++++++++*.....+............+...+......+..+..........+...+.....+.+.....+....+.....+++++++++++++++++++++++++++++++++++++++*.+........+.+......+...+..+...+......+..........+.........+..+............+...+..................+.+...+.....+.......+...+...........+.+.....+.+..+.+..+....+...........+...+.+.........+.....+....+..+.+..+.+.........+..+......+....+.........+.........+...........+......+.............+..+......+...+....+..+.+...............+.....+.............+......+...+...+.....+....+.....+...+.............+..+.+......+......+..+...+....+...........+..........+.....+............+...+...+....+......+..+...+...............+.......+..+...+.......+.....+..........+..................+..+..........+.....+......+..........+..............+...........................+..........+...+...+...+.........+...+..+...+....+...+............+...+........+...+....+...+...+...........+.+.....+...+.......+..+.............+...+...........+......+.......+..+...+......+.........+.+.....+......+...+.............+..+...............+............+......+...+....+..+..........+.....+..................+......+.+...+..+.+........+......+.+............+..+.+..+......+.+.....+......+...+......+...+.+......+...........+...+.+......+...............+..............+.+...+.........+.....+...+.............+.....+.........+...+....+.....+...+.+......+...+....................+.+.....+.+.....+.+........+.........+.......+......+...+.........+...+..+.+..+.........+.........+............+..........+...+......+......+..+.+......+......+.........+...+........+...+......+..........+.........+.........+...+..+......+.........+.+.....+......+......+...+.+.....+.+.........+.........+..+.........+.+.........+........+...+....+......+..+.+......+........+.......+.....++++++
2025-08-24T03:13:24.199367167Z -----
2025-08-24T03:13:25.413377690Z New container detected. Setting up app folder and fixing permissions.
2025-08-24T03:14:04.821347787Z query: SELECT * FROM "sqlite_master" WHERE "type" = 'table' AND "name" = 'migrations'
2025-08-24T03:14:04.941142113Z query: CREATE TABLE "migrations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "timestamp" bigint NOT NULL, "name" varchar NOT NULL)
2025-08-24T03:14:05.041863706Z query: SELECT * FROM "migrations" "migrations" ORDER BY "id" DESC
2025-08-24T03:14:05.053160325Z 0 migrations are already loaded in the database.
2025-08-24T03:14:05.053510420Z 3 migrations were found in the source code.
2025-08-24T03:14:05.053786696Z 3 migrations are new migrations that needs to be executed.
2025-08-24T03:14:05.064069344Z query: BEGIN TRANSACTION
2025-08-24T03:14:05.097687444Z query: SELECT COUNT(*) FROM users
2025-08-24T03:14:05.133710876Z query failed: SELECT COUNT(*) FROM users
2025-08-24T03:14:05.144388950Z error: Error: SQLITE_ERROR: no such table: users
2025-08-24T03:14:05.144413029Z --> in Database#all('SELECT COUNT(*) FROM users', undefined, [Function: handler])
2025-08-24T03:14:05.144423129Z at SqliteQueryRunner.<anonymous> (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:60:56)
2025-08-24T03:14:05.144431937Z at step (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:143:27)
2025-08-24T03:14:05.144440083Z at Object.next (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:124:57)
2025-08-24T03:14:05.144448240Z at /app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:117:75
2025-08-24T03:14:05.144456346Z at new Promise (<anonymous>)
2025-08-24T03:14:05.144464613Z at Object.__awaiter (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:113:16)
2025-08-24T03:14:05.144472699Z at execute (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:54:64)
2025-08-24T03:14:05.144480835Z at SqliteQueryRunner.<anonymous> (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:101:46)
2025-08-24T03:14:05.144489272Z at step (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:143:27) {
2025-08-24T03:14:05.144497399Z errno: 1,
2025-08-24T03:14:05.144505274Z code: 'SQLITE_ERROR',
2025-08-24T03:14:05.144513521Z __augmented: true
2025-08-24T03:14:05.144521387Z }
2025-08-24T03:14:05.177180607Z 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-08-24T03:14:05.203811493Z query: CREATE UNIQUE INDEX "IDX_97672ac88f789774dd47f7c8be" ON "users" ("email")
2025-08-24T03:14:05.261037474Z 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-08-24T03:14:05.282798387Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-08-24T03:14:05.298103885Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-08-24T03:14:05.336902473Z 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-08-24T03:14:05.351750321Z query: CREATE INDEX "IDX_cba488e36ca6ff6eec83e91440" ON "category_months" ("categoryId")
2025-08-24T03:14:05.359089655Z query: CREATE INDEX "IDX_de0f1ed5fe7ad4f2254bb815be" ON "category_months" ("budgetMonthId")
2025-08-24T03:14:05.370022822Z query: CREATE INDEX "IDX_23f4c8894717fb764a2b88ff29" ON "category_months" ("month")
2025-08-24T03:14:05.412868106Z 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-08-24T03:14:05.427447423Z query: CREATE INDEX "IDX_e6d5be2f8c1fbd283150e043a0" ON "categories" ("budgetId")
2025-08-24T03:14:05.438035906Z query: CREATE UNIQUE INDEX "IDX_af173d6048d44da16b00e49e24" ON "categories" ("trackingAccountId")
2025-08-24T03:14:05.466430622Z 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-08-24T03:14:05.504391524Z 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-08-24T03:14:05.525450464Z query: CREATE INDEX "IDX_7098ffeb5373b7d6344f4f1663" ON "transactions" ("transferTransactionId")
2025-08-24T03:14:05.564578014Z 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-08-24T03:14:05.588588656Z 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-08-24T03:14:05.615435676Z 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-08-24T03:14:05.622912066Z query: CREATE INDEX "IDX_0dcceebef7c019bc892be7b5d0" ON "category_groups" ("budgetId")
2025-08-24T03:14:05.631338638Z query: DROP INDEX "IDX_398c07457719d1899ba4f11914"
2025-08-24T03:14:05.649581890Z query: DROP INDEX "IDX_0c21df54422306fdf78621fc18"
2025-08-24T03:14:05.685682568Z 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-08-24T03:14:05.710664213Z 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-08-24T03:14:05.728948218Z query: DROP TABLE "budget_months"
2025-08-24T03:14:05.738241464Z query: ALTER TABLE "temporary_budget_months" RENAME TO "budget_months"
2025-08-24T03:14:05.801557233Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-08-24T03:14:05.811183901Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-08-24T03:14:05.815772958Z query: DROP INDEX "IDX_cba488e36ca6ff6eec83e91440"
2025-08-24T03:14:05.819239987Z query: DROP INDEX "IDX_de0f1ed5fe7ad4f2254bb815be"
2025-08-24T03:14:05.822495520Z query: DROP INDEX "IDX_23f4c8894717fb764a2b88ff29"
2025-08-24T03:14:05.851551016Z 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-08-24T03:14:05.862888958Z 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-08-24T03:14:05.866797556Z query: DROP TABLE "category_months"
2025-08-24T03:14:05.871724443Z query: ALTER TABLE "temporary_category_months" RENAME TO "category_months"
2025-08-24T03:14:05.903821893Z query: CREATE INDEX "IDX_cba488e36ca6ff6eec83e91440" ON "category_months" ("categoryId")
2025-08-24T03:14:05.910605889Z query: CREATE INDEX "IDX_de0f1ed5fe7ad4f2254bb815be" ON "category_months" ("budgetMonthId")
2025-08-24T03:14:05.915385730Z query: CREATE INDEX "IDX_23f4c8894717fb764a2b88ff29" ON "category_months" ("month")
2025-08-24T03:14:05.918916026Z query: DROP INDEX "IDX_e6d5be2f8c1fbd283150e043a0"
2025-08-24T03:14:05.922363285Z query: DROP INDEX "IDX_af173d6048d44da16b00e49e24"
2025-08-24T03:14:05.954811992Z 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-08-24T03:14:05.967492697Z 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-08-24T03:14:05.971388509Z query: DROP TABLE "categories"
2025-08-24T03:14:06.007979964Z query: ALTER TABLE "temporary_categories" RENAME TO "categories"
2025-08-24T03:14:06.042205748Z query: CREATE INDEX "IDX_e6d5be2f8c1fbd283150e043a0" ON "categories" ("budgetId")
2025-08-24T03:14:06.048564848Z query: CREATE UNIQUE INDEX "IDX_af173d6048d44da16b00e49e24" ON "categories" ("trackingAccountId")
2025-08-24T03:14:06.073225397Z 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-08-24T03:14:06.086714359Z query: INSERT INTO "temporary_payees"("id", "budgetId", "transferAccountId", "name", "internal", "created", "updated") SELECT "id", "budgetId", "transferAccountId", "name", "internal", "created", "updated" FROM "payees"
2025-08-24T03:14:06.091726479Z query: DROP TABLE "payees"
2025-08-24T03:14:06.098439331Z query: ALTER TABLE "temporary_payees" RENAME TO "payees"
2025-08-24T03:14:06.130987217Z query: DROP INDEX "IDX_7098ffeb5373b7d6344f4f1663"
2025-08-24T03:14:06.172807488Z 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-08-24T03:14:06.189423464Z 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-08-24T03:14:06.194964899Z query: DROP TABLE "transactions"
2025-08-24T03:14:06.201137053Z query: ALTER TABLE "temporary_transactions" RENAME TO "transactions"
2025-08-24T03:14:06.235233846Z query: CREATE INDEX "IDX_7098ffeb5373b7d6344f4f1663" ON "transactions" ("transferTransactionId")
2025-08-24T03:14:06.268893320Z 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-08-24T03:14:06.281083838Z 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-08-24T03:14:06.285448274Z query: DROP TABLE "accounts"
2025-08-24T03:14:06.292830032Z query: ALTER TABLE "temporary_accounts" RENAME TO "accounts"
2025-08-24T03:14:06.336911374Z 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-08-24T03:14:06.346459524Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "toBeBudgeted", "created", "updated") SELECT "id", "userId", "name", "toBeBudgeted", "created", "updated" FROM "budgets"
2025-08-24T03:14:06.350700892Z query: DROP TABLE "budgets"
2025-08-24T03:14:06.356790790Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-08-24T03:14:06.385803229Z query: DROP INDEX "IDX_0dcceebef7c019bc892be7b5d0"
2025-08-24T03:14:06.406287623Z 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-08-24T03:14:06.414578301Z 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-08-24T03:14:06.417802070Z query: DROP TABLE "category_groups"
2025-08-24T03:14:06.422343111Z query: ALTER TABLE "temporary_category_groups" RENAME TO "category_groups"
2025-08-24T03:14:06.452561068Z query: CREATE INDEX "IDX_0dcceebef7c019bc892be7b5d0" ON "category_groups" ("budgetId")
2025-08-24T03:14:06.488393194Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1649259669912,"initial1649259669912"]
2025-08-24T03:14:06.499573129Z Migration initial1649259669912 has been executed successfully.
2025-08-24T03:14:06.515796405Z 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-08-24T03:14:06.524814587Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "created", "updated") SELECT "id", "userId", "name", "created", "updated" FROM "budgets"
2025-08-24T03:14:06.531905170Z query: DROP TABLE "budgets"
2025-08-24T03:14:06.539604969Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-08-24T03:14:06.571043131Z query: DROP INDEX "IDX_0c21df54422306fdf78621fc18"
2025-08-24T03:14:06.574090586Z query: DROP INDEX "IDX_398c07457719d1899ba4f11914"
2025-08-24T03:14:06.601272450Z 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-08-24T03:14:06.611073449Z 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-08-24T03:14:06.614978139Z query: DROP TABLE "budget_months"
2025-08-24T03:14:06.621946836Z query: ALTER TABLE "temporary_budget_months" RENAME TO "budget_months"
2025-08-24T03:14:06.654093525Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-08-24T03:14:06.658702031Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-08-24T03:14:06.674963654Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1649260258195,"budgetMonthAvailable1649260258195"]
2025-08-24T03:14:06.679131905Z Migration budgetMonthAvailable1649260258195 has been executed successfully.
2025-08-24T03:14:06.699010729Z 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-08-24T03:14:06.707025753Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "created", "updated") SELECT "id", "userId", "name", "created", "updated" FROM "budgets"
2025-08-24T03:14:06.710220594Z query: DROP TABLE "budgets"
2025-08-24T03:14:06.715168303Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-08-24T03:14:06.753885347Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1650032177205,"addBudgetCurrency1650032177205"]
2025-08-24T03:14:06.756366702Z Migration addBudgetCurrency1650032177205 has been executed successfully.
2025-08-24T03:14:06.759766235Z query: COMMIT
2025-08-24T03:14:17.256141223Z [custom-init] No custom files found, skipping...
2025-08-24T03:14:21.038828728Z
2025-08-24T03:14:21.038872687Z > BudgE@0.0.8 start
2025-08-24T03:14:21.038882977Z > node build/src/server.js
2025-08-24T03:14:21.038895362Z
2025-08-24T03:14:31.684437141Z !!!WARNING!!! Running in development mode!
2025-08-24T03:14:32.616874092Z Server listening on: http://0.0.0.0:5000
2025-08-24T03:14:33.444189021Z Connection to localhost (127.0.0.1) 5000 port [tcp/*] succeeded!
2025-08-24T03:14:33.882952668Z [ls.io-init] done.
2025-08-24T03:14:35.143791336Z Error: You must be logged in to do that
2025-08-24T03:14:35.143832339Z at /app/www/public/backend/build/src/middleware/authentication.js:41:23
2025-08-24T03:14:35.143838631Z at Generator.next (<anonymous>)
2025-08-24T03:14:35.143869093Z at /app/www/public/backend/build/src/middleware/authentication.js:8:71
2025-08-24T03:14:35.143882850Z at new Promise (<anonymous>)
2025-08-24T03:14:35.143888171Z at __awaiter (/app/www/public/backend/build/src/middleware/authentication.js:4:12)
2025-08-24T03:14:35.143893101Z at expressAuthentication (/app/www/public/backend/build/src/middleware/authentication.js:22:12)
2025-08-24T03:14:35.143898001Z at /app/www/public/backend/build/routes.js:1245:97
2025-08-24T03:14:35.143902891Z at Generator.next (<anonymous>)
2025-08-24T03:14:35.143907861Z at /app/www/public/backend/build/routes.js:8:71
2025-08-24T03:14:35.143912550Z at new Promise (<anonymous>) {
2025-08-24T03:14:35.143917620Z status: 401
2025-08-24T03:14:35.143922570Z }