2025-10-05T03:00:57.290220774Z [migrations] started
2025-10-05T03:00:57.390576201Z [migrations] 01-nginx-site-confs-default: executing...
2025-10-05T03:00:58.348949903Z [migrations] 01-nginx-site-confs-default: succeeded
2025-10-05T03:00:58.424099572Z [migrations] 02-default-location: executing...
2025-10-05T03:00:58.658786279Z [migrations] 02-default-location: succeeded
2025-10-05T03:00:58.659396758Z [migrations] done
2025-10-05T03:00:59.296537889Z usermod: no changes
2025-10-05T03:00:59.333660939Z ───────────────────────────────────────
2025-10-05T03:00:59.333690128Z
2025-10-05T03:00:59.333699236Z ██╗ ███████╗██╗ ██████╗
2025-10-05T03:00:59.333707794Z ██║ ██╔════╝██║██╔═══██╗
2025-10-05T03:00:59.333716060Z ██║ ███████╗██║██║ ██║
2025-10-05T03:00:59.333724167Z ██║ ╚════██║██║██║ ██║
2025-10-05T03:00:59.333732133Z ███████╗███████║██║╚██████╔╝
2025-10-05T03:00:59.333740379Z ╚══════╝╚══════╝╚═╝ ╚═════╝
2025-10-05T03:00:59.333748826Z
2025-10-05T03:00:59.333756552Z Brought to you by linuxserver.io
2025-10-05T03:00:59.333764598Z ───────────────────────────────────────
2025-10-05T03:00:59.341300871Z
2025-10-05T03:00:59.341317715Z To support LSIO projects visit:
2025-10-05T03:00:59.341326502Z https://www.linuxserver.io/donate/
2025-10-05T03:00:59.341334579Z
2025-10-05T03:00:59.341342485Z ───────────────────────────────────────
2025-10-05T03:00:59.341351222Z GID/UID
2025-10-05T03:00:59.341742410Z ───────────────────────────────────────
2025-10-05T03:00:59.746570022Z
2025-10-05T03:00:59.746603971Z User UID: 911
2025-10-05T03:00:59.746613680Z User GID: 911
2025-10-05T03:00:59.746621877Z ───────────────────────────────────────
2025-10-05T03:00:59.783148235Z Linuxserver.io version: 0.0.9-ls165
2025-10-05T03:00:59.786563221Z Build-date: 2025-10-05T02:51:42+00:00
2025-10-05T03:00:59.786584564Z ───────────────────────────────────────
2025-10-05T03:00:59.786593572Z
2025-10-05T03:01:03.489685026Z Setting resolver to 8.8.8.8 8.8.4.4
2025-10-05T03:01:03.598828947Z Setting worker_processes to 64
2025-10-05T03:01:06.384742819Z generating self-signed keys in /config/keys, you can replace these with your own keys if required
2025-10-05T03:01:06.663557709Z ...........+...+......+.+...+............+++++++++++++++++++++++++++++++++++++++*.....+..+...+.......+...+......+..+.........+.+...+......+.....+....+.........+.....+...+...+.+........+............+.+++++++++++++++++++++++++++++++++++++++*...........+...........+............+...+...+....+...+........+......+...+............+.........+.........+.............+...+......+.....+....+..............+...+...+....+..+......+.......+........+....+.........+.....+....++++++
2025-10-05T03:01:07.066034970Z ..+...+.....+............+...+..........+...+++++++++++++++++++++++++++++++++++++++*...........+.....+......+....+.....+.+........+.......+++++++++++++++++++++++++++++++++++++++*..+....+........+.........+.+.....+.........+.+..+.+.........+..+....+..............+...+...+....+...+.................+.+.........+.....+...+....+.........+...........+.+.................+......+.+...+.................+.+..+.+......+.............................+.+......+...+.....+....+........+....+...............+...+.....+.......+...+.................+.........+....+...+..+......+......+.+........+......+...+.......+...........+...+.+........+.+..+..........+.........+.....+...+...+...+....+...+........+.......+...+...............+.........+.....+.+..+...+.......+..+.............+...+.....+.........+..........+..+...+.......+..................+...+...+......+........+.............+...+..+.......+...+..............+......+.......+..+......+.......+...........+......+......+.........+...................+..+.......+......+.....+.+.....+...+......+......+.............+......+..+...+.......+...+..+....+..................+.....+......+.......+..+.++++++
2025-10-05T03:01:07.106181608Z -----
2025-10-05T03:01:11.642435804Z New container detected. Setting up app folder and fixing permissions.
2025-10-05T03:01:53.118589472Z query: SELECT * FROM "sqlite_master" WHERE "type" = 'table' AND "name" = 'migrations'
2025-10-05T03:01:53.255740530Z query: CREATE TABLE "migrations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "timestamp" bigint NOT NULL, "name" varchar NOT NULL)
2025-10-05T03:01:53.362613698Z query: SELECT * FROM "migrations" "migrations" ORDER BY "id" DESC
2025-10-05T03:01:53.373939009Z 0 migrations are already loaded in the database.
2025-10-05T03:01:53.374319235Z 3 migrations were found in the source code.
2025-10-05T03:01:53.374623297Z 3 migrations are new migrations that needs to be executed.
2025-10-05T03:01:53.385306486Z query: BEGIN TRANSACTION
2025-10-05T03:01:53.420813793Z query: SELECT COUNT(*) FROM users
2025-10-05T03:01:53.461766684Z query failed: SELECT COUNT(*) FROM users
2025-10-05T03:01:53.472957734Z error: Error: SQLITE_ERROR: no such table: users
2025-10-05T03:01:53.472981793Z --> in Database#all('SELECT COUNT(*) FROM users', undefined, [Function: handler])
2025-10-05T03:01:53.472991603Z at SqliteQueryRunner.<anonymous> (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:60:56)
2025-10-05T03:01:53.473000521Z at step (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:143:27)
2025-10-05T03:01:53.473008667Z at Object.next (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:124:57)
2025-10-05T03:01:53.473050000Z at /app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:117:75
2025-10-05T03:01:53.473058728Z at new Promise (<anonymous>)
2025-10-05T03:01:53.473066914Z at Object.__awaiter (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:113:16)
2025-10-05T03:01:53.473075031Z at execute (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:54:64)
2025-10-05T03:01:53.473083107Z at SqliteQueryRunner.<anonymous> (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:101:46)
2025-10-05T03:01:53.473091484Z at step (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:143:27) {
2025-10-05T03:01:53.473099560Z errno: 1,
2025-10-05T03:01:53.473107346Z code: 'SQLITE_ERROR',
2025-10-05T03:01:53.473115662Z __augmented: true
2025-10-05T03:01:53.473123448Z }
2025-10-05T03:01:53.506760760Z 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-05T03:01:53.533961664Z query: CREATE UNIQUE INDEX "IDX_97672ac88f789774dd47f7c8be" ON "users" ("email")
2025-10-05T03:01:53.594159080Z 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-05T03:01:53.616622255Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-10-05T03:01:53.634397763Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-10-05T03:01:53.675095831Z 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-05T03:01:53.692697178Z query: CREATE INDEX "IDX_cba488e36ca6ff6eec83e91440" ON "category_months" ("categoryId")
2025-10-05T03:01:53.700673586Z query: CREATE INDEX "IDX_de0f1ed5fe7ad4f2254bb815be" ON "category_months" ("budgetMonthId")
2025-10-05T03:01:53.711741349Z query: CREATE INDEX "IDX_23f4c8894717fb764a2b88ff29" ON "category_months" ("month")
2025-10-05T03:01:53.756845237Z 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-05T03:01:53.772727593Z query: CREATE INDEX "IDX_e6d5be2f8c1fbd283150e043a0" ON "categories" ("budgetId")
2025-10-05T03:01:53.785207860Z query: CREATE UNIQUE INDEX "IDX_af173d6048d44da16b00e49e24" ON "categories" ("trackingAccountId")
2025-10-05T03:01:53.816882811Z 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-05T03:01:53.856251292Z 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-05T03:01:53.889023953Z query: CREATE INDEX "IDX_7098ffeb5373b7d6344f4f1663" ON "transactions" ("transferTransactionId")
2025-10-05T03:01:53.933130754Z 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-05T03:01:53.959092203Z 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-05T03:01:53.985296470Z 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-05T03:01:53.992190359Z query: CREATE INDEX "IDX_0dcceebef7c019bc892be7b5d0" ON "category_groups" ("budgetId")
2025-10-05T03:01:54.000578517Z query: DROP INDEX "IDX_398c07457719d1899ba4f11914"
2025-10-05T03:01:54.018050824Z query: DROP INDEX "IDX_0c21df54422306fdf78621fc18"
2025-10-05T03:01:54.052218694Z 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-05T03:01:54.078187969Z 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-05T03:01:54.094798691Z query: DROP TABLE "budget_months"
2025-10-05T03:01:54.105732805Z query: ALTER TABLE "temporary_budget_months" RENAME TO "budget_months"
2025-10-05T03:01:54.174821953Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-10-05T03:01:54.191492586Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-10-05T03:01:54.197581805Z query: DROP INDEX "IDX_cba488e36ca6ff6eec83e91440"
2025-10-05T03:01:54.202886746Z query: DROP INDEX "IDX_de0f1ed5fe7ad4f2254bb815be"
2025-10-05T03:01:54.207540796Z query: DROP INDEX "IDX_23f4c8894717fb764a2b88ff29"
2025-10-05T03:01:54.246708713Z 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-05T03:01:54.258202864Z 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-05T03:01:54.279362805Z query: DROP TABLE "category_months"
2025-10-05T03:01:54.285260680Z query: ALTER TABLE "temporary_category_months" RENAME TO "category_months"
2025-10-05T03:01:54.318089524Z query: CREATE INDEX "IDX_cba488e36ca6ff6eec83e91440" ON "category_months" ("categoryId")
2025-10-05T03:01:54.326433503Z query: CREATE INDEX "IDX_de0f1ed5fe7ad4f2254bb815be" ON "category_months" ("budgetMonthId")
2025-10-05T03:01:54.332407200Z query: CREATE INDEX "IDX_23f4c8894717fb764a2b88ff29" ON "category_months" ("month")
2025-10-05T03:01:54.336510922Z query: DROP INDEX "IDX_e6d5be2f8c1fbd283150e043a0"
2025-10-05T03:01:54.340364400Z query: DROP INDEX "IDX_af173d6048d44da16b00e49e24"
2025-10-05T03:01:54.377640559Z 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-05T03:01:54.391591126Z 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-05T03:01:54.395462951Z query: DROP TABLE "categories"
2025-10-05T03:01:54.411809010Z query: ALTER TABLE "temporary_categories" RENAME TO "categories"
2025-10-05T03:01:54.445339648Z query: CREATE INDEX "IDX_e6d5be2f8c1fbd283150e043a0" ON "categories" ("budgetId")
2025-10-05T03:01:54.450805653Z query: CREATE UNIQUE INDEX "IDX_af173d6048d44da16b00e49e24" ON "categories" ("trackingAccountId")
2025-10-05T03:01:54.476241723Z 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-05T03:01:54.488560264Z query: INSERT INTO "temporary_payees"("id", "budgetId", "transferAccountId", "name", "internal", "created", "updated") SELECT "id", "budgetId", "transferAccountId", "name", "internal", "created", "updated" FROM "payees"
2025-10-05T03:01:54.492971786Z query: DROP TABLE "payees"
2025-10-05T03:01:54.498581831Z query: ALTER TABLE "temporary_payees" RENAME TO "payees"
2025-10-05T03:01:54.530542547Z query: DROP INDEX "IDX_7098ffeb5373b7d6344f4f1663"
2025-10-05T03:01:54.572522876Z 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-05T03:01:54.588061691Z 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-05T03:01:54.592329123Z query: DROP TABLE "transactions"
2025-10-05T03:01:54.597625055Z query: ALTER TABLE "temporary_transactions" RENAME TO "transactions"
2025-10-05T03:01:54.631258910Z query: CREATE INDEX "IDX_7098ffeb5373b7d6344f4f1663" ON "transactions" ("transferTransactionId")
2025-10-05T03:01:54.664641319Z 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-05T03:01:54.676192575Z 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-05T03:01:54.679712923Z query: DROP TABLE "accounts"
2025-10-05T03:01:54.685845350Z query: ALTER TABLE "temporary_accounts" RENAME TO "accounts"
2025-10-05T03:01:54.729948433Z 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-05T03:01:54.738509418Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "toBeBudgeted", "created", "updated") SELECT "id", "userId", "name", "toBeBudgeted", "created", "updated" FROM "budgets"
2025-10-05T03:01:54.741895526Z query: DROP TABLE "budgets"
2025-10-05T03:01:54.749073938Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-10-05T03:01:54.779658835Z query: DROP INDEX "IDX_0dcceebef7c019bc892be7b5d0"
2025-10-05T03:01:54.810787617Z 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-05T03:01:54.823016788Z 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-05T03:01:54.827817413Z query: DROP TABLE "category_groups"
2025-10-05T03:01:54.834450668Z query: ALTER TABLE "temporary_category_groups" RENAME TO "category_groups"
2025-10-05T03:01:54.866730457Z query: CREATE INDEX "IDX_0dcceebef7c019bc892be7b5d0" ON "category_groups" ("budgetId")
2025-10-05T03:01:54.917735796Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1649259669912,"initial1649259669912"]
2025-10-05T03:01:54.930362889Z Migration initial1649259669912 has been executed successfully.
2025-10-05T03:01:54.947230328Z 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-05T03:01:54.958231647Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "created", "updated") SELECT "id", "userId", "name", "created", "updated" FROM "budgets"
2025-10-05T03:01:55.334653940Z query: DROP TABLE "budgets"
2025-10-05T03:01:55.345541400Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-10-05T03:01:55.380065598Z query: DROP INDEX "IDX_0c21df54422306fdf78621fc18"
2025-10-05T03:01:55.386438528Z query: DROP INDEX "IDX_398c07457719d1899ba4f11914"
2025-10-05T03:01:55.448871355Z 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-05T03:01:55.465559273Z 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-05T03:01:55.470964495Z query: DROP TABLE "budget_months"
2025-10-05T03:01:55.477690106Z query: ALTER TABLE "temporary_budget_months" RENAME TO "budget_months"
2025-10-05T03:01:55.510910499Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-10-05T03:01:55.516985359Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-10-05T03:01:55.538311485Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1649260258195,"budgetMonthAvailable1649260258195"]
2025-10-05T03:01:55.542450418Z Migration budgetMonthAvailable1649260258195 has been executed successfully.
2025-10-05T03:01:55.568901442Z 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-05T03:01:55.580207034Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "created", "updated") SELECT "id", "userId", "name", "created", "updated" FROM "budgets"
2025-10-05T03:01:55.583621027Z query: DROP TABLE "budgets"
2025-10-05T03:01:55.588984937Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-10-05T03:01:55.624975677Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1650032177205,"addBudgetCurrency1650032177205"]
2025-10-05T03:01:55.627454949Z Migration addBudgetCurrency1650032177205 has been executed successfully.
2025-10-05T03:01:55.631075568Z query: COMMIT
2025-10-05T03:02:07.392726923Z [custom-init] No custom files found, skipping...
2025-10-05T03:02:11.661301213Z
2025-10-05T03:02:11.661342967Z > BudgE@0.0.8 start
2025-10-05T03:02:11.661353448Z > node build/src/server.js
2025-10-05T03:02:11.661362216Z
2025-10-05T03:02:23.546017611Z !!!WARNING!!! Running in development mode!
2025-10-05T03:02:24.666347608Z Server listening on: http://0.0.0.0:5000
2025-10-05T03:02:25.159477568Z Connection to localhost (127.0.0.1) 5000 port [tcp/*] succeeded!
2025-10-05T03:02:25.867577672Z [ls.io-init] done.
2025-10-05T03:02:27.233887511Z Error: You must be logged in to do that
2025-10-05T03:02:27.233938814Z at /app/www/public/backend/build/src/middleware/authentication.js:41:23
2025-10-05T03:02:27.233948484Z at Generator.next (<anonymous>)
2025-10-05T03:02:27.233957432Z at /app/www/public/backend/build/src/middleware/authentication.js:8:71
2025-10-05T03:02:27.233965939Z at new Promise (<anonymous>)
2025-10-05T03:02:27.233974406Z at __awaiter (/app/www/public/backend/build/src/middleware/authentication.js:4:12)
2025-10-05T03:02:27.233982763Z at expressAuthentication (/app/www/public/backend/build/src/middleware/authentication.js:22:12)
2025-10-05T03:02:27.233991200Z at /app/www/public/backend/build/routes.js:1245:97
2025-10-05T03:02:27.233999647Z at Generator.next (<anonymous>)
2025-10-05T03:02:27.234008415Z at /app/www/public/backend/build/routes.js:8:71
2025-10-05T03:02:27.234016621Z at new Promise (<anonymous>) {
2025-10-05T03:02:27.234024968Z status: 401
2025-10-05T03:02:27.234033014Z }