2025-08-17T03:18:01.790328748Z [migrations] started
2025-08-17T03:18:01.898157578Z [migrations] 01-nginx-site-confs-default: executing...
2025-08-17T03:18:02.118567379Z [migrations] 01-nginx-site-confs-default: succeeded
2025-08-17T03:18:02.197046312Z [migrations] 02-default-location: executing...
2025-08-17T03:18:02.400462214Z [migrations] 02-default-location: succeeded
2025-08-17T03:18:02.401121802Z [migrations] done
2025-08-17T03:18:02.806230307Z usermod: no changes
2025-08-17T03:18:02.829960660Z ───────────────────────────────────────
2025-08-17T03:18:02.829995750Z 
2025-08-17T03:18:02.830007414Z       ██╗     ███████╗██╗ ██████╗
2025-08-17T03:18:02.830018105Z       ██║     ██╔════╝██║██╔═══██╗
2025-08-17T03:18:02.830032284Z       ██║     ███████╗██║██║   ██║
2025-08-17T03:18:02.830043186Z       ██║     ╚════██║██║██║   ██║
2025-08-17T03:18:02.830054689Z       ███████╗███████║██║╚██████╔╝
2025-08-17T03:18:02.830065581Z       ╚══════╝╚══════╝╚═╝ ╚═════╝
2025-08-17T03:18:02.830076152Z 
2025-08-17T03:18:02.830085902Z    Brought to you by linuxserver.io
2025-08-17T03:18:02.830096714Z ───────────────────────────────────────
2025-08-17T03:18:02.834998985Z 
2025-08-17T03:18:02.835040969Z To support LSIO projects visit:
2025-08-17T03:18:02.835050909Z https://www.linuxserver.io/donate/
2025-08-17T03:18:02.835059446Z 
2025-08-17T03:18:02.835067643Z ───────────────────────────────────────
2025-08-17T03:18:02.835077222Z GID/UID
2025-08-17T03:18:02.835238326Z ───────────────────────────────────────
2025-08-17T03:18:02.930911621Z 
2025-08-17T03:18:02.930950910Z User UID:    911
2025-08-17T03:18:02.930960450Z User GID:    911
2025-08-17T03:18:02.930968806Z ───────────────────────────────────────
2025-08-17T03:18:02.968264113Z Linuxserver.io version: 0.0.9-ls162
2025-08-17T03:18:02.971829923Z Build-date: 2025-08-17T03:08:55+00:00
2025-08-17T03:18:02.971875815Z ───────────────────────────────────────
2025-08-17T03:18:02.971893621Z     
2025-08-17T03:18:05.585897813Z Setting resolver to  8.8.8.8 8.8.4.4
2025-08-17T03:18:05.700658010Z Setting worker_processes to 64
2025-08-17T03:18:06.466135954Z generating self-signed keys in /config/keys, you can replace these with your own keys if required
2025-08-17T03:18:06.654276649Z .+.+......+...+..+.......+..+++++++++++++++++++++++++++++++++++++++*..+..+......+...+......+....+..+....+...........+++++++++++++++++++++++++++++++++++++++*...........+..+...+.+......+.........+...+..+...+..................+...+......+.+............++++++
2025-08-17T03:18:06.920418023Z ....+...+............+...+........+.+.....+......+....+...+..+.+.........+.........+.....+++++++++++++++++++++++++++++++++++++++*......+.............+..+.+............+..+...+..........+...+..+++++++++++++++++++++++++++++++++++++++*..........+...+...+...+.....+.......+..+...+............+.+...............+..+....+.....+...+.+......+.....+....+..+............+..........+...+...+..+...+....+..+.+.......................+.+...+...+........+......+.+........+.........+...+...+.......+.........+...........+.............+......+.....+..........+........+...+...+......+.+...+.....+.+.....+.........+....+...+.........+...+......+...........+.+.....+....+........+.+............+..+......+.......+.................+.+..+..........+..+...+...............+............+.+..+.........+......+..................+.+...+..+...............+.++++++
2025-08-17T03:18:06.955577229Z -----
2025-08-17T03:18:08.293666195Z New container detected. Setting up app folder and fixing permissions.
2025-08-17T03:18:47.304110935Z query: SELECT * FROM "sqlite_master" WHERE "type" = 'table' AND "name" = 'migrations'
2025-08-17T03:18:47.435785692Z query: CREATE TABLE "migrations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "timestamp" bigint NOT NULL, "name" varchar NOT NULL)
2025-08-17T03:18:47.531144193Z query: SELECT * FROM "migrations" "migrations" ORDER BY "id" DESC
2025-08-17T03:18:47.542301098Z 0 migrations are already loaded in the database.
2025-08-17T03:18:47.542685061Z 3 migrations were found in the source code.
2025-08-17T03:18:47.542972620Z 3 migrations are new migrations that needs to be executed.
2025-08-17T03:18:47.553624529Z query: BEGIN TRANSACTION
2025-08-17T03:18:47.587098301Z query: SELECT COUNT(*) FROM users
2025-08-17T03:18:47.623372973Z query failed: SELECT COUNT(*) FROM users
2025-08-17T03:18:47.634078188Z error: Error: SQLITE_ERROR: no such table: users
2025-08-17T03:18:47.634102467Z --> in Database#all('SELECT COUNT(*) FROM users', undefined, [Function: handler])
2025-08-17T03:18:47.634112217Z     at SqliteQueryRunner.<anonymous> (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:60:56)
2025-08-17T03:18:47.634121405Z     at step (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:143:27)
2025-08-17T03:18:47.634129702Z     at Object.next (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:124:57)
2025-08-17T03:18:47.634137888Z     at /app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:117:75
2025-08-17T03:18:47.634146035Z     at new Promise (<anonymous>)
2025-08-17T03:18:47.634154231Z     at Object.__awaiter (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:113:16)
2025-08-17T03:18:47.634184332Z     at execute (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:54:64)
2025-08-17T03:18:47.634192619Z     at SqliteQueryRunner.<anonymous> (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:101:46)
2025-08-17T03:18:47.634201036Z     at step (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:143:27) {
2025-08-17T03:18:47.634209312Z   errno: 1,
2025-08-17T03:18:47.634217098Z   code: 'SQLITE_ERROR',
2025-08-17T03:18:47.634225705Z   __augmented: true
2025-08-17T03:18:47.634233571Z }
2025-08-17T03:18:47.666678561Z 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-17T03:18:47.692810971Z query: CREATE UNIQUE INDEX "IDX_97672ac88f789774dd47f7c8be" ON "users" ("email") 
2025-08-17T03:18:47.750959177Z 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-17T03:18:47.772315159Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId") 
2025-08-17T03:18:47.787217265Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month") 
2025-08-17T03:18:47.826159158Z 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-17T03:18:47.844081135Z query: CREATE INDEX "IDX_cba488e36ca6ff6eec83e91440" ON "category_months" ("categoryId") 
2025-08-17T03:18:47.851804196Z query: CREATE INDEX "IDX_de0f1ed5fe7ad4f2254bb815be" ON "category_months" ("budgetMonthId") 
2025-08-17T03:18:47.862310641Z query: CREATE INDEX "IDX_23f4c8894717fb764a2b88ff29" ON "category_months" ("month") 
2025-08-17T03:18:47.903785564Z 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-17T03:18:47.917508897Z query: CREATE INDEX "IDX_e6d5be2f8c1fbd283150e043a0" ON "categories" ("budgetId") 
2025-08-17T03:18:47.928561232Z query: CREATE UNIQUE INDEX "IDX_af173d6048d44da16b00e49e24" ON "categories" ("trackingAccountId") 
2025-08-17T03:18:47.958966094Z 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-17T03:18:47.998652946Z 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-17T03:18:48.030052472Z query: CREATE INDEX "IDX_7098ffeb5373b7d6344f4f1663" ON "transactions" ("transferTransactionId") 
2025-08-17T03:18:48.068010823Z 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-17T03:18:48.092902204Z 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-17T03:18:48.118203611Z 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-17T03:18:48.124570050Z query: CREATE INDEX "IDX_0dcceebef7c019bc892be7b5d0" ON "category_groups" ("budgetId") 
2025-08-17T03:18:48.132365316Z query: DROP INDEX "IDX_398c07457719d1899ba4f11914"
2025-08-17T03:18:48.149045693Z query: DROP INDEX "IDX_0c21df54422306fdf78621fc18"
2025-08-17T03:18:48.181829526Z 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-17T03:18:48.204911213Z 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-17T03:18:48.221174500Z query: DROP TABLE "budget_months"
2025-08-17T03:18:48.232192045Z query: ALTER TABLE "temporary_budget_months" RENAME TO "budget_months"
2025-08-17T03:18:48.298808732Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId") 
2025-08-17T03:18:48.310942946Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month") 
2025-08-17T03:18:48.316172836Z query: DROP INDEX "IDX_cba488e36ca6ff6eec83e91440"
2025-08-17T03:18:48.320719892Z query: DROP INDEX "IDX_de0f1ed5fe7ad4f2254bb815be"
2025-08-17T03:18:48.325123339Z query: DROP INDEX "IDX_23f4c8894717fb764a2b88ff29"
2025-08-17T03:18:48.365450801Z 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-17T03:18:48.376402924Z 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-17T03:18:48.380311224Z query: DROP TABLE "category_months"
2025-08-17T03:18:48.385233916Z query: ALTER TABLE "temporary_category_months" RENAME TO "category_months"
2025-08-17T03:18:48.417571299Z query: CREATE INDEX "IDX_cba488e36ca6ff6eec83e91440" ON "category_months" ("categoryId") 
2025-08-17T03:18:48.425227586Z query: CREATE INDEX "IDX_de0f1ed5fe7ad4f2254bb815be" ON "category_months" ("budgetMonthId") 
2025-08-17T03:18:48.430519372Z query: CREATE INDEX "IDX_23f4c8894717fb764a2b88ff29" ON "category_months" ("month") 
2025-08-17T03:18:48.434087777Z query: DROP INDEX "IDX_e6d5be2f8c1fbd283150e043a0"
2025-08-17T03:18:48.437535198Z query: DROP INDEX "IDX_af173d6048d44da16b00e49e24"
2025-08-17T03:18:48.487888538Z 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-17T03:18:48.500851621Z 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-17T03:18:48.504625069Z query: DROP TABLE "categories"
2025-08-17T03:18:48.519341531Z query: ALTER TABLE "temporary_categories" RENAME TO "categories"
2025-08-17T03:18:48.552980556Z query: CREATE INDEX "IDX_e6d5be2f8c1fbd283150e043a0" ON "categories" ("budgetId") 
2025-08-17T03:18:48.557994362Z query: CREATE UNIQUE INDEX "IDX_af173d6048d44da16b00e49e24" ON "categories" ("trackingAccountId") 
2025-08-17T03:18:48.582245293Z 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-17T03:18:48.594052187Z query: INSERT INTO "temporary_payees"("id", "budgetId", "transferAccountId", "name", "internal", "created", "updated") SELECT "id", "budgetId", "transferAccountId", "name", "internal", "created", "updated" FROM "payees"
2025-08-17T03:18:48.597953452Z query: DROP TABLE "payees"
2025-08-17T03:18:48.603281200Z query: ALTER TABLE "temporary_payees" RENAME TO "payees"
2025-08-17T03:18:48.633335757Z query: DROP INDEX "IDX_7098ffeb5373b7d6344f4f1663"
2025-08-17T03:18:48.673855567Z 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-17T03:18:48.689220776Z 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-17T03:18:48.692950165Z query: DROP TABLE "transactions"
2025-08-17T03:18:48.697869591Z query: ALTER TABLE "temporary_transactions" RENAME TO "transactions"
2025-08-17T03:18:48.729573499Z query: CREATE INDEX "IDX_7098ffeb5373b7d6344f4f1663" ON "transactions" ("transferTransactionId") 
2025-08-17T03:18:48.761149229Z 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-17T03:18:48.772201203Z 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-17T03:18:48.775218318Z query: DROP TABLE "accounts"
2025-08-17T03:18:48.780904869Z query: ALTER TABLE "temporary_accounts" RENAME TO "accounts"
2025-08-17T03:18:48.823319583Z 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-17T03:18:48.831215062Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "toBeBudgeted", "created", "updated") SELECT "id", "userId", "name", "toBeBudgeted", "created", "updated" FROM "budgets"
2025-08-17T03:18:48.834332389Z query: DROP TABLE "budgets"
2025-08-17T03:18:48.841014534Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-08-17T03:18:48.869705796Z query: DROP INDEX "IDX_0dcceebef7c019bc892be7b5d0"
2025-08-17T03:18:48.899640351Z 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-17T03:18:48.911096319Z 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-17T03:18:48.915341286Z query: DROP TABLE "category_groups"
2025-08-17T03:18:48.921542743Z query: ALTER TABLE "temporary_category_groups" RENAME TO "category_groups"
2025-08-17T03:18:48.952279193Z query: CREATE INDEX "IDX_0dcceebef7c019bc892be7b5d0" ON "category_groups" ("budgetId") 
2025-08-17T03:18:49.002417821Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1649259669912,"initial1649259669912"]
2025-08-17T03:18:49.013751412Z Migration initial1649259669912 has been executed successfully.
2025-08-17T03:18:49.030112216Z 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-17T03:18:49.041890653Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "created", "updated") SELECT "id", "userId", "name", "created", "updated" FROM "budgets"
2025-08-17T03:18:49.045709923Z query: DROP TABLE "budgets"
2025-08-17T03:18:49.054763303Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-08-17T03:18:49.085895890Z query: DROP INDEX "IDX_0c21df54422306fdf78621fc18"
2025-08-17T03:18:49.089158620Z query: DROP INDEX "IDX_398c07457719d1899ba4f11914"
2025-08-17T03:18:49.118568910Z 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-17T03:18:49.128403403Z 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-17T03:18:49.132969386Z query: DROP TABLE "budget_months"
2025-08-17T03:18:49.139532752Z query: ALTER TABLE "temporary_budget_months" RENAME TO "budget_months"
2025-08-17T03:18:49.163763372Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month") 
2025-08-17T03:18:49.168117700Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId") 
2025-08-17T03:18:49.183472278Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1649260258195,"budgetMonthAvailable1649260258195"]
2025-08-17T03:18:49.186571518Z Migration budgetMonthAvailable1649260258195 has been executed successfully.
2025-08-17T03:18:49.207460500Z 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-17T03:18:49.215543335Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "created", "updated") SELECT "id", "userId", "name", "created", "updated" FROM "budgets"
2025-08-17T03:18:49.218767778Z query: DROP TABLE "budgets"
2025-08-17T03:18:49.223627052Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-08-17T03:18:49.261049194Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1650032177205,"addBudgetCurrency1650032177205"]
2025-08-17T03:18:49.263608147Z Migration addBudgetCurrency1650032177205 has been executed successfully.
2025-08-17T03:18:49.267108936Z query: COMMIT
2025-08-17T03:18:59.831249128Z [custom-init] No custom files found, skipping...
2025-08-17T03:19:03.416613959Z 
2025-08-17T03:19:03.416658318Z > BudgE@0.0.8 start
2025-08-17T03:19:03.416668248Z > node build/src/server.js
2025-08-17T03:19:03.416676585Z 
2025-08-17T03:19:13.923434465Z !!!WARNING!!! Running in development mode!
2025-08-17T03:19:14.849307290Z Server listening on: http://0.0.0.0:5000
2025-08-17T03:19:14.891092076Z Connection to localhost (127.0.0.1) 5000 port [tcp/*] succeeded!
2025-08-17T03:19:15.307896644Z [ls.io-init] done.
2025-08-17T03:19:16.695000101Z Error: You must be logged in to do that
2025-08-17T03:19:16.695036354Z     at /app/www/public/backend/build/src/middleware/authentication.js:41:23
2025-08-17T03:19:16.695045964Z     at Generator.next (<anonymous>)
2025-08-17T03:19:16.695054661Z     at /app/www/public/backend/build/src/middleware/authentication.js:8:71
2025-08-17T03:19:16.695062968Z     at new Promise (<anonymous>)
2025-08-17T03:19:16.695071215Z     at __awaiter (/app/www/public/backend/build/src/middleware/authentication.js:4:12)
2025-08-17T03:19:16.695079662Z     at expressAuthentication (/app/www/public/backend/build/src/middleware/authentication.js:22:12)
2025-08-17T03:19:16.695088018Z     at /app/www/public/backend/build/routes.js:1245:97
2025-08-17T03:19:16.695096085Z     at Generator.next (<anonymous>)
2025-08-17T03:19:16.695104201Z     at /app/www/public/backend/build/routes.js:8:71
2025-08-17T03:19:16.695112277Z     at new Promise (<anonymous>) {
2025-08-17T03:19:16.695120554Z   status: 401
2025-08-17T03:19:16.695128570Z }