2025-09-28T03:02:01.282494913Z [migrations] started
2025-09-28T03:02:01.411914639Z [migrations] 01-nginx-site-confs-default: executing...
2025-09-28T03:02:02.010492794Z [migrations] 01-nginx-site-confs-default: succeeded
2025-09-28T03:02:02.080203195Z [migrations] 02-default-location: executing...
2025-09-28T03:02:02.321661561Z [migrations] 02-default-location: succeeded
2025-09-28T03:02:02.322309716Z [migrations] done
2025-09-28T03:02:03.383397502Z usermod: no changes
2025-09-28T03:02:03.420152178Z ───────────────────────────────────────
2025-09-28T03:02:03.420166196Z
2025-09-28T03:02:03.420172338Z ██╗ ███████╗██╗ ██████╗
2025-09-28T03:02:03.420178160Z ██║ ██╔════╝██║██╔═══██╗
2025-09-28T03:02:03.420183831Z ██║ ███████╗██║██║ ██║
2025-09-28T03:02:03.420189473Z ██║ ╚════██║██║██║ ██║
2025-09-28T03:02:03.420195204Z ███████╗███████║██║╚██████╔╝
2025-09-28T03:02:03.420200775Z ╚══════╝╚══════╝╚═╝ ╚═════╝
2025-09-28T03:02:03.420206657Z
2025-09-28T03:02:03.420211958Z Brought to you by linuxserver.io
2025-09-28T03:02:03.420217429Z ───────────────────────────────────────
2025-09-28T03:02:03.425523212Z
2025-09-28T03:02:03.425557852Z To support LSIO projects visit:
2025-09-28T03:02:03.425567371Z https://www.linuxserver.io/donate/
2025-09-28T03:02:03.425575668Z
2025-09-28T03:02:03.425584005Z ───────────────────────────────────────
2025-09-28T03:02:03.425593544Z GID/UID
2025-09-28T03:02:03.425701681Z ───────────────────────────────────────
2025-09-28T03:02:03.508633765Z
2025-09-28T03:02:03.508655569Z User UID: 911
2025-09-28T03:02:03.508660098Z User GID: 911
2025-09-28T03:02:03.508664376Z ───────────────────────────────────────
2025-09-28T03:02:03.543815062Z Linuxserver.io version: 0.0.9-ls164
2025-09-28T03:02:03.546947079Z Build-date: 2025-09-28T02:52:26+00:00
2025-09-28T03:02:03.546961387Z ───────────────────────────────────────
2025-09-28T03:02:03.546969965Z
2025-09-28T03:02:07.808740495Z Setting resolver to 8.8.8.8 8.8.4.4
2025-09-28T03:02:07.931549540Z Setting worker_processes to 64
2025-09-28T03:02:09.732479718Z generating self-signed keys in /config/keys, you can replace these with your own keys if required
2025-09-28T03:02:10.096834616Z ...+...+.....+......+...+.+..+...+......+.+..+...+++++++++++++++++++++++++++++++++++++++*............+.......+++++++++++++++++++++++++++++++++++++++*.......+........................+.....+.+......+..............+.+........+......+.+...+..+.............+......+..+............+.+.....+..............................+.........+...+....+...+..+.+........+......+....+..+...+....+...+..+.+...........+...+...+....+......+..+.+..+....+......+...+......+.....+.+........+.+...+...+..+................+.........+..+.+..+.......+.....+.............+........+...+.+.....+...++++++
2025-09-28T03:02:10.417124178Z ..+.........+......+......+.......+..+...+.+......+...+.....+.............+.........+.....+.+...+.....+.+......+.....+...+.......+............+...+...+...........+.........+.........+.............+........+..........+.........+..+.............+..+.+.....+...+.........+.+..+....+.....+...+.+.....+....+...+.........+...+..+.........+.......+++++++++++++++++++++++++++++++++++++++*.+.......+...+...........+......+....+..+....+.....+....+..+...+.+......+..+...+.........+.+...+++++++++++++++++++++++++++++++++++++++*.....+........+.........+...+....+...+..+...+.+......+......+..+.......+........+.+......+......+...+......+.....+...............+......+...+....+..+....+.........+.....+.............+.....+.......+...+...+...............+..+...+....+..+.+............+........+.......+......+....................+.+..............+.+.....+.+...+...........+...+.+.....+.......+..+...+...+............+.......+.....+.+......+...+...............+........+...+......+...+...............+.+......+......+............+..+....+.....+....+...+..+.+...........+....+...............+............+.........+......+..+.+..+...+.+.....+.............+........+..........+............+......+..+.............+..+...+.+......+........+.++++++
2025-09-28T03:02:10.453240337Z -----
2025-09-28T03:02:14.177780029Z New container detected. Setting up app folder and fixing permissions.
2025-09-28T03:02:54.942618665Z query: SELECT * FROM "sqlite_master" WHERE "type" = 'table' AND "name" = 'migrations'
2025-09-28T03:02:55.095883184Z query: CREATE TABLE "migrations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "timestamp" bigint NOT NULL, "name" varchar NOT NULL)
2025-09-28T03:02:55.192497807Z query: SELECT * FROM "migrations" "migrations" ORDER BY "id" DESC
2025-09-28T03:02:55.203717498Z 0 migrations are already loaded in the database.
2025-09-28T03:02:55.204124217Z 3 migrations were found in the source code.
2025-09-28T03:02:55.204430744Z 3 migrations are new migrations that needs to be executed.
2025-09-28T03:02:55.215934898Z query: BEGIN TRANSACTION
2025-09-28T03:02:55.250698805Z query: SELECT COUNT(*) FROM users
2025-09-28T03:02:55.290813647Z query failed: SELECT COUNT(*) FROM users
2025-09-28T03:02:55.302059410Z error: Error: SQLITE_ERROR: no such table: users
2025-09-28T03:02:55.302083649Z --> in Database#all('SELECT COUNT(*) FROM users', undefined, [Function: handler])
2025-09-28T03:02:55.302093890Z at SqliteQueryRunner.<anonymous> (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:60:56)
2025-09-28T03:02:55.302102828Z at step (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:143:27)
2025-09-28T03:02:55.302144482Z at Object.next (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:124:57)
2025-09-28T03:02:55.302153279Z at /app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:117:75
2025-09-28T03:02:55.302161756Z at new Promise (<anonymous>)
2025-09-28T03:02:55.302169893Z at Object.__awaiter (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:113:16)
2025-09-28T03:02:55.302178009Z at execute (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:54:64)
2025-09-28T03:02:55.302186035Z at SqliteQueryRunner.<anonymous> (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:101:46)
2025-09-28T03:02:55.302194452Z at step (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:143:27) {
2025-09-28T03:02:55.302202609Z errno: 1,
2025-09-28T03:02:55.302210484Z code: 'SQLITE_ERROR',
2025-09-28T03:02:55.302218390Z __augmented: true
2025-09-28T03:02:55.302226346Z }
2025-09-28T03:02:55.335898495Z 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-09-28T03:02:55.362929071Z query: CREATE UNIQUE INDEX "IDX_97672ac88f789774dd47f7c8be" ON "users" ("email")
2025-09-28T03:02:55.422804561Z 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-09-28T03:02:55.445002807Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-09-28T03:02:55.460418897Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-09-28T03:02:55.503917201Z 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-09-28T03:02:55.521295272Z query: CREATE INDEX "IDX_cba488e36ca6ff6eec83e91440" ON "category_months" ("categoryId")
2025-09-28T03:02:55.529699103Z query: CREATE INDEX "IDX_de0f1ed5fe7ad4f2254bb815be" ON "category_months" ("budgetMonthId")
2025-09-28T03:02:55.540623680Z query: CREATE INDEX "IDX_23f4c8894717fb764a2b88ff29" ON "category_months" ("month")
2025-09-28T03:02:55.584247777Z 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-09-28T03:02:55.599832978Z query: CREATE INDEX "IDX_e6d5be2f8c1fbd283150e043a0" ON "categories" ("budgetId")
2025-09-28T03:02:55.612096100Z query: CREATE UNIQUE INDEX "IDX_af173d6048d44da16b00e49e24" ON "categories" ("trackingAccountId")
2025-09-28T03:02:55.643107612Z 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-09-28T03:02:55.682371410Z 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-09-28T03:02:55.718422278Z query: CREATE INDEX "IDX_7098ffeb5373b7d6344f4f1663" ON "transactions" ("transferTransactionId")
2025-09-28T03:02:56.047577813Z 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-09-28T03:02:56.073903060Z 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-09-28T03:02:56.099894433Z 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-09-28T03:02:56.106733153Z query: CREATE INDEX "IDX_0dcceebef7c019bc892be7b5d0" ON "category_groups" ("budgetId")
2025-09-28T03:02:56.114794074Z query: DROP INDEX "IDX_398c07457719d1899ba4f11914"
2025-09-28T03:02:56.132559334Z query: DROP INDEX "IDX_0c21df54422306fdf78621fc18"
2025-09-28T03:02:56.166403680Z 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-09-28T03:02:56.190108580Z 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-09-28T03:02:56.205996851Z query: DROP TABLE "budget_months"
2025-09-28T03:02:56.216284255Z query: ALTER TABLE "temporary_budget_months" RENAME TO "budget_months"
2025-09-28T03:02:56.283551818Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-09-28T03:02:56.296197651Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-09-28T03:02:56.302186689Z query: DROP INDEX "IDX_cba488e36ca6ff6eec83e91440"
2025-09-28T03:02:56.307252670Z query: DROP INDEX "IDX_de0f1ed5fe7ad4f2254bb815be"
2025-09-28T03:02:56.312079889Z query: DROP INDEX "IDX_23f4c8894717fb764a2b88ff29"
2025-09-28T03:02:56.352534986Z 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-09-28T03:02:56.364165133Z 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-09-28T03:02:56.368435181Z query: DROP TABLE "category_months"
2025-09-28T03:02:56.373747377Z query: ALTER TABLE "temporary_category_months" RENAME TO "category_months"
2025-09-28T03:02:56.411378748Z query: CREATE INDEX "IDX_cba488e36ca6ff6eec83e91440" ON "category_months" ("categoryId")
2025-09-28T03:02:56.419357583Z query: CREATE INDEX "IDX_de0f1ed5fe7ad4f2254bb815be" ON "category_months" ("budgetMonthId")
2025-09-28T03:02:56.424797867Z query: CREATE INDEX "IDX_23f4c8894717fb764a2b88ff29" ON "category_months" ("month")
2025-09-28T03:02:56.428799274Z query: DROP INDEX "IDX_e6d5be2f8c1fbd283150e043a0"
2025-09-28T03:02:56.452458562Z query: DROP INDEX "IDX_af173d6048d44da16b00e49e24"
2025-09-28T03:02:56.486700057Z 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-09-28T03:02:56.499391462Z 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-09-28T03:02:56.503661419Z query: DROP TABLE "categories"
2025-09-28T03:02:56.519631856Z query: ALTER TABLE "temporary_categories" RENAME TO "categories"
2025-09-28T03:02:56.552174060Z query: CREATE INDEX "IDX_e6d5be2f8c1fbd283150e043a0" ON "categories" ("budgetId")
2025-09-28T03:02:56.557678924Z query: CREATE UNIQUE INDEX "IDX_af173d6048d44da16b00e49e24" ON "categories" ("trackingAccountId")
2025-09-28T03:02:56.582885908Z 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-09-28T03:02:56.594746961Z query: INSERT INTO "temporary_payees"("id", "budgetId", "transferAccountId", "name", "internal", "created", "updated") SELECT "id", "budgetId", "transferAccountId", "name", "internal", "created", "updated" FROM "payees"
2025-09-28T03:02:56.598949853Z query: DROP TABLE "payees"
2025-09-28T03:02:56.605044986Z query: ALTER TABLE "temporary_payees" RENAME TO "payees"
2025-09-28T03:02:56.634485193Z query: DROP INDEX "IDX_7098ffeb5373b7d6344f4f1663"
2025-09-28T03:02:56.676732048Z 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-09-28T03:02:56.692282529Z 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-09-28T03:02:56.696665734Z query: DROP TABLE "transactions"
2025-09-28T03:02:56.702009003Z query: ALTER TABLE "temporary_transactions" RENAME TO "transactions"
2025-09-28T03:02:56.733260508Z query: CREATE INDEX "IDX_7098ffeb5373b7d6344f4f1663" ON "transactions" ("transferTransactionId")
2025-09-28T03:02:56.766147326Z 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-09-28T03:02:56.777194699Z 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-09-28T03:02:56.780795710Z query: DROP TABLE "accounts"
2025-09-28T03:02:56.786802575Z query: ALTER TABLE "temporary_accounts" RENAME TO "accounts"
2025-09-28T03:02:56.829122967Z 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-09-28T03:02:56.837242907Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "toBeBudgeted", "created", "updated") SELECT "id", "userId", "name", "toBeBudgeted", "created", "updated" FROM "budgets"
2025-09-28T03:02:56.840915973Z query: DROP TABLE "budgets"
2025-09-28T03:02:56.847865155Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-09-28T03:02:56.876492726Z query: DROP INDEX "IDX_0dcceebef7c019bc892be7b5d0"
2025-09-28T03:02:56.907522365Z 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-09-28T03:02:56.919679112Z 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-09-28T03:02:56.924434267Z query: DROP TABLE "category_groups"
2025-09-28T03:02:56.931107884Z query: ALTER TABLE "temporary_category_groups" RENAME TO "category_groups"
2025-09-28T03:02:56.961197990Z query: CREATE INDEX "IDX_0dcceebef7c019bc892be7b5d0" ON "category_groups" ("budgetId")
2025-09-28T03:02:57.013629632Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1649259669912,"initial1649259669912"]
2025-09-28T03:02:57.025421405Z Migration initial1649259669912 has been executed successfully.
2025-09-28T03:02:57.042304950Z 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-09-28T03:02:57.054550246Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "created", "updated") SELECT "id", "userId", "name", "created", "updated" FROM "budgets"
2025-09-28T03:02:57.058640341Z query: DROP TABLE "budgets"
2025-09-28T03:02:57.071966574Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-09-28T03:02:57.102216401Z query: DROP INDEX "IDX_0c21df54422306fdf78621fc18"
2025-09-28T03:02:57.107444298Z query: DROP INDEX "IDX_398c07457719d1899ba4f11914"
2025-09-28T03:02:57.150899315Z 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-09-28T03:02:57.166836224Z 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-09-28T03:02:57.172568325Z query: DROP TABLE "budget_months"
2025-09-28T03:02:57.179458408Z query: ALTER TABLE "temporary_budget_months" RENAME TO "budget_months"
2025-09-28T03:02:57.213837631Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-09-28T03:02:57.220200804Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-09-28T03:02:57.242001609Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1649260258195,"budgetMonthAvailable1649260258195"]
2025-09-28T03:02:57.246250976Z Migration budgetMonthAvailable1649260258195 has been executed successfully.
2025-09-28T03:02:57.270690325Z 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-09-28T03:02:57.279092122Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "created", "updated") SELECT "id", "userId", "name", "created", "updated" FROM "budgets"
2025-09-28T03:02:57.286668918Z query: DROP TABLE "budgets"
2025-09-28T03:02:57.292178361Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-09-28T03:02:57.324808101Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1650032177205,"addBudgetCurrency1650032177205"]
2025-09-28T03:02:57.327294246Z Migration addBudgetCurrency1650032177205 has been executed successfully.
2025-09-28T03:02:57.331109118Z query: COMMIT
2025-09-28T03:03:08.051375155Z [custom-init] No custom files found, skipping...
2025-09-28T03:03:12.467422968Z
2025-09-28T03:03:12.467462999Z > BudgE@0.0.8 start
2025-09-28T03:03:12.467473119Z > node build/src/server.js
2025-09-28T03:03:12.467481436Z
2025-09-28T03:03:24.363401519Z !!!WARNING!!! Running in development mode!
2025-09-28T03:03:25.423166693Z Server listening on: http://0.0.0.0:5000
2025-09-28T03:03:25.738499808Z Connection to localhost (127.0.0.1) 5000 port [tcp/*] succeeded!
2025-09-28T03:03:26.188560408Z [ls.io-init] done.
2025-09-28T03:03:28.259923543Z Error: You must be logged in to do that
2025-09-28T03:03:28.259960397Z at /app/www/public/backend/build/src/middleware/authentication.js:41:23
2025-09-28T03:03:28.259970387Z at Generator.next (<anonymous>)
2025-09-28T03:03:28.259979124Z at /app/www/public/backend/build/src/middleware/authentication.js:8:71
2025-09-28T03:03:28.259987371Z at new Promise (<anonymous>)
2025-09-28T03:03:28.259995568Z at __awaiter (/app/www/public/backend/build/src/middleware/authentication.js:4:12)
2025-09-28T03:03:28.260003724Z at expressAuthentication (/app/www/public/backend/build/src/middleware/authentication.js:22:12)
2025-09-28T03:03:28.260011951Z at /app/www/public/backend/build/routes.js:1245:97
2025-09-28T03:03:28.260020047Z at Generator.next (<anonymous>)
2025-09-28T03:03:28.260028324Z at /app/www/public/backend/build/routes.js:8:71
2025-09-28T03:03:28.260037151Z at new Promise (<anonymous>) {
2025-09-28T03:03:28.260045458Z status: 401
2025-09-28T03:03:28.260053474Z }