2025-09-28T03:01:58.650477016Z [migrations] started
2025-09-28T03:01:58.656524162Z [migrations] 01-nginx-site-confs-default: executing...
2025-09-28T03:01:58.663759360Z [migrations] 01-nginx-site-confs-default: succeeded
2025-09-28T03:01:58.666677124Z [migrations] 02-default-location: executing...
2025-09-28T03:01:58.674717544Z [migrations] 02-default-location: succeeded
2025-09-28T03:01:58.674728125Z [migrations] done
2025-09-28T03:01:58.685439693Z usermod: no changes
2025-09-28T03:01:58.687464490Z ───────────────────────────────────────
2025-09-28T03:01:58.687474590Z
2025-09-28T03:01:58.687478478Z ██╗ ███████╗██╗ ██████╗
2025-09-28T03:01:58.687483117Z ██║ ██╔════╝██║██╔═══██╗
2025-09-28T03:01:58.687486905Z ██║ ███████╗██║██║ ██║
2025-09-28T03:01:58.687490602Z ██║ ╚════██║██║██║ ██║
2025-09-28T03:01:58.687494370Z ███████╗███████║██║╚██████╔╝
2025-09-28T03:01:58.687498248Z ╚══════╝╚══════╝╚═╝ ╚═════╝
2025-09-28T03:01:58.687501965Z
2025-09-28T03:01:58.687505472Z Brought to you by linuxserver.io
2025-09-28T03:01:58.687509180Z ───────────────────────────────────────
2025-09-28T03:01:58.687801218Z
2025-09-28T03:01:58.687807951Z To support LSIO projects visit:
2025-09-28T03:01:58.687811819Z https://www.linuxserver.io/donate/
2025-09-28T03:01:58.687815647Z
2025-09-28T03:01:58.687819525Z ───────────────────────────────────────
2025-09-28T03:01:58.687824074Z GID/UID
2025-09-28T03:01:58.687827891Z ───────────────────────────────────────
2025-09-28T03:01:58.692458415Z
2025-09-28T03:01:58.692465920Z User UID: 911
2025-09-28T03:01:58.692469838Z User GID: 911
2025-09-28T03:01:58.692474898Z ───────────────────────────────────────
2025-09-28T03:01:58.694232126Z Linuxserver.io version: 0.0.9-ls164
2025-09-28T03:01:58.694535417Z Build-date: 2025-09-28T02:52:26+00:00
2025-09-28T03:01:58.694542672Z ───────────────────────────────────────
2025-09-28T03:01:58.694546700Z
2025-09-28T03:01:58.777802706Z Setting resolver to 8.8.8.8 8.8.4.4
2025-09-28T03:01:58.783208350Z Setting worker_processes to 64
2025-09-28T03:01:58.803426429Z generating self-signed keys in /config/keys, you can replace these with your own keys if required
2025-09-28T03:01:58.846766584Z .+...+.+......+......+..+...+...+.+...........+...+.........+...+.........+....+..+++++++++++++++++++++++++++++++++++++++*..+.+..+....+..............+.........+++++++++++++++++++++++++++++++++++++++*..+......+...+....+...+..+..........+.....+......+.......+...+.....+.+......+.....+...+..........+..+.......+.....+...............+...+....+...............+...+..+....+..............+............+...+......+......+.........+....+.....+.+..+.......+......+......+...+........+.......+......+.....+.......+...+.....+............+..........+...+..+.........+...+...+....+........+.......+......+...+.....+.+...+.....+......+.........+......++++++
2025-09-28T03:01:58.856863534Z ......+....+......+.....+.+.....+...+....+...........+.......+...+..+.......+......+..+....+...+...+........+......+...............+++++++++++++++++++++++++++++++++++++++*..+.+...........+...+.+......+........+...+....+++++++++++++++++++++++++++++++++++++++*.+......+..............+............+...+......+....+........+..........+.........+.....+...+.+.....+.+..............+.......++++++
2025-09-28T03:01:58.860090462Z -----
2025-09-28T03:01:58.902837713Z New container detected. Setting up app folder and fixing permissions.
2025-09-28T03:02:16.931087908Z query: SELECT * FROM "sqlite_master" WHERE "type" = 'table' AND "name" = 'migrations'
2025-09-28T03:02:16.937057448Z query: CREATE TABLE "migrations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "timestamp" bigint NOT NULL, "name" varchar NOT NULL)
2025-09-28T03:02:17.055097150Z query: SELECT * FROM "migrations" "migrations" ORDER BY "id" DESC
2025-09-28T03:02:17.055974276Z 0 migrations are already loaded in the database.
2025-09-28T03:02:17.056012774Z 3 migrations were found in the source code.
2025-09-28T03:02:17.056025680Z 3 migrations are new migrations that needs to be executed.
2025-09-28T03:02:17.056815621Z query: BEGIN TRANSACTION
2025-09-28T03:02:17.058735346Z query: SELECT COUNT(*) FROM users
2025-09-28T03:02:17.059981114Z query failed: SELECT COUNT(*) FROM users
2025-09-28T03:02:17.060865705Z error: Error: SQLITE_ERROR: no such table: users
2025-09-28T03:02:17.060877289Z --> in Database#all('SELECT COUNT(*) FROM users', undefined, [Function: handler])
2025-09-28T03:02:17.060886858Z at SqliteQueryRunner.<anonymous> (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:60:56)
2025-09-28T03:02:17.060895756Z at step (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:143:27)
2025-09-28T03:02:17.060904343Z at Object.next (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:124:57)
2025-09-28T03:02:17.060912710Z at /app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:117:75
2025-09-28T03:02:17.060921317Z at new Promise (<anonymous>)
2025-09-28T03:02:17.060929674Z at Object.__awaiter (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:113:16)
2025-09-28T03:02:17.060961989Z at execute (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:54:64)
2025-09-28T03:02:17.060970516Z at SqliteQueryRunner.<anonymous> (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:101:46)
2025-09-28T03:02:17.060979114Z at step (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:143:27) {
2025-09-28T03:02:17.060987491Z errno: 1,
2025-09-28T03:02:17.060995777Z code: 'SQLITE_ERROR',
2025-09-28T03:02:17.061003894Z __augmented: true
2025-09-28T03:02:17.061011940Z }
2025-09-28T03:02:17.062818026Z 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:17.064300581Z query: CREATE UNIQUE INDEX "IDX_97672ac88f789774dd47f7c8be" ON "users" ("email")
2025-09-28T03:02:17.067545525Z 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:17.068636832Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-09-28T03:02:17.069495471Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-09-28T03:02:17.072208855Z 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:17.073324882Z query: CREATE INDEX "IDX_cba488e36ca6ff6eec83e91440" ON "category_months" ("categoryId")
2025-09-28T03:02:17.074031404Z query: CREATE INDEX "IDX_de0f1ed5fe7ad4f2254bb815be" ON "category_months" ("budgetMonthId")
2025-09-28T03:02:17.074931837Z query: CREATE INDEX "IDX_23f4c8894717fb764a2b88ff29" ON "category_months" ("month")
2025-09-28T03:02:17.077739491Z 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:17.078630174Z query: CREATE INDEX "IDX_e6d5be2f8c1fbd283150e043a0" ON "categories" ("budgetId")
2025-09-28T03:02:17.079630498Z query: CREATE UNIQUE INDEX "IDX_af173d6048d44da16b00e49e24" ON "categories" ("trackingAccountId")
2025-09-28T03:02:17.082645369Z 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:17.086639621Z 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:17.088505117Z query: CREATE INDEX "IDX_7098ffeb5373b7d6344f4f1663" ON "transactions" ("transferTransactionId")
2025-09-28T03:02:17.094651323Z 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:17.097879092Z 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:17.101149316Z 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:17.102090942Z query: CREATE INDEX "IDX_0dcceebef7c019bc892be7b5d0" ON "category_groups" ("budgetId")
2025-09-28T03:02:17.103195957Z query: DROP INDEX "IDX_398c07457719d1899ba4f11914"
2025-09-28T03:02:17.104034275Z query: DROP INDEX "IDX_0c21df54422306fdf78621fc18"
2025-09-28T03:02:17.108163910Z 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:17.109995759Z 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:17.110835921Z query: DROP TABLE "budget_months"
2025-09-28T03:02:17.112015576Z query: ALTER TABLE "temporary_budget_months" RENAME TO "budget_months"
2025-09-28T03:02:17.118277013Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-09-28T03:02:17.120121517Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-09-28T03:02:17.120960957Z query: DROP INDEX "IDX_cba488e36ca6ff6eec83e91440"
2025-09-28T03:02:17.121863154Z query: DROP INDEX "IDX_de0f1ed5fe7ad4f2254bb815be"
2025-09-28T03:02:17.122830622Z query: DROP INDEX "IDX_23f4c8894717fb764a2b88ff29"
2025-09-28T03:02:17.129556034Z 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:17.130598743Z 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:17.130971874Z query: DROP TABLE "category_months"
2025-09-28T03:02:17.131761434Z query: ALTER TABLE "temporary_category_months" RENAME TO "category_months"
2025-09-28T03:02:17.135456184Z query: CREATE INDEX "IDX_cba488e36ca6ff6eec83e91440" ON "category_months" ("categoryId")
2025-09-28T03:02:17.136048827Z query: CREATE INDEX "IDX_de0f1ed5fe7ad4f2254bb815be" ON "category_months" ("budgetMonthId")
2025-09-28T03:02:17.136622923Z query: CREATE INDEX "IDX_23f4c8894717fb764a2b88ff29" ON "category_months" ("month")
2025-09-28T03:02:17.137071296Z query: DROP INDEX "IDX_e6d5be2f8c1fbd283150e043a0"
2025-09-28T03:02:17.137643397Z query: DROP INDEX "IDX_af173d6048d44da16b00e49e24"
2025-09-28T03:02:17.140569980Z 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:17.141870769Z 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:17.142179200Z query: DROP TABLE "categories"
2025-09-28T03:02:17.143289336Z query: ALTER TABLE "temporary_categories" RENAME TO "categories"
2025-09-28T03:02:17.147383780Z query: CREATE INDEX "IDX_e6d5be2f8c1fbd283150e043a0" ON "categories" ("budgetId")
2025-09-28T03:02:17.148062847Z query: CREATE UNIQUE INDEX "IDX_af173d6048d44da16b00e49e24" ON "categories" ("trackingAccountId")
2025-09-28T03:02:17.150034797Z 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:17.151294865Z 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:17.151807707Z query: DROP TABLE "payees"
2025-09-28T03:02:17.153476097Z query: ALTER TABLE "temporary_payees" RENAME TO "payees"
2025-09-28T03:02:17.158799505Z query: DROP INDEX "IDX_7098ffeb5373b7d6344f4f1663"
2025-09-28T03:02:17.162235433Z 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:17.163469268Z 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:17.164003774Z query: DROP TABLE "transactions"
2025-09-28T03:02:17.164966873Z query: ALTER TABLE "temporary_transactions" RENAME TO "transactions"
2025-09-28T03:02:17.169337934Z query: CREATE INDEX "IDX_7098ffeb5373b7d6344f4f1663" ON "transactions" ("transferTransactionId")
2025-09-28T03:02:17.172980458Z 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:17.173879318Z 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:17.174213962Z query: DROP TABLE "accounts"
2025-09-28T03:02:17.175285329Z query: ALTER TABLE "temporary_accounts" RENAME TO "accounts"
2025-09-28T03:02:17.179400415Z 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:17.180215055Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "toBeBudgeted", "created", "updated") SELECT "id", "userId", "name", "toBeBudgeted", "created", "updated" FROM "budgets"
2025-09-28T03:02:17.180548897Z query: DROP TABLE "budgets"
2025-09-28T03:02:17.181658151Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-09-28T03:02:17.184917554Z query: DROP INDEX "IDX_0dcceebef7c019bc892be7b5d0"
2025-09-28T03:02:17.186493697Z 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:17.187337436Z 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:17.187664515Z query: DROP TABLE "category_groups"
2025-09-28T03:02:17.188527923Z query: ALTER TABLE "temporary_category_groups" RENAME TO "category_groups"
2025-09-28T03:02:17.191928370Z query: CREATE INDEX "IDX_0dcceebef7c019bc892be7b5d0" ON "category_groups" ("budgetId")
2025-09-28T03:02:17.195222372Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1649259669912,"initial1649259669912"]
2025-09-28T03:02:17.195693671Z Migration initial1649259669912 has been executed successfully.
2025-09-28T03:02:17.196892074Z 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:17.197944674Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "created", "updated") SELECT "id", "userId", "name", "created", "updated" FROM "budgets"
2025-09-28T03:02:17.198311392Z query: DROP TABLE "budgets"
2025-09-28T03:02:17.199658655Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-09-28T03:02:17.203779833Z query: DROP INDEX "IDX_0c21df54422306fdf78621fc18"
2025-09-28T03:02:17.204340131Z query: DROP INDEX "IDX_398c07457719d1899ba4f11914"
2025-09-28T03:02:17.207746079Z 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:17.209855777Z 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:17.210281414Z query: DROP TABLE "budget_months"
2025-09-28T03:02:17.211809230Z query: ALTER TABLE "temporary_budget_months" RENAME TO "budget_months"
2025-09-28T03:02:17.216581078Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-09-28T03:02:17.217104272Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-09-28T03:02:17.218148765Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1649260258195,"budgetMonthAvailable1649260258195"]
2025-09-28T03:02:17.218382375Z Migration budgetMonthAvailable1649260258195 has been executed successfully.
2025-09-28T03:02:17.219714247Z 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:17.220628307Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "created", "updated") SELECT "id", "userId", "name", "created", "updated" FROM "budgets"
2025-09-28T03:02:17.221003633Z query: DROP TABLE "budgets"
2025-09-28T03:02:17.222336507Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-09-28T03:02:17.227079046Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1650032177205,"addBudgetCurrency1650032177205"]
2025-09-28T03:02:17.227293738Z Migration addBudgetCurrency1650032177205 has been executed successfully.
2025-09-28T03:02:17.227583151Z query: COMMIT
2025-09-28T03:02:21.804533022Z [custom-init] No custom files found, skipping...
2025-09-28T03:02:21.975460654Z
2025-09-28T03:02:21.975495084Z > BudgE@0.0.8 start
2025-09-28T03:02:21.975505264Z > node build/src/server.js
2025-09-28T03:02:21.975513581Z
2025-09-28T03:02:23.195192473Z !!!WARNING!!! Running in development mode!
2025-09-28T03:02:23.279161986Z Server listening on: http://0.0.0.0:5000
2025-09-28T03:02:23.835625945Z Connection to localhost (127.0.0.1) 5000 port [tcp/*] succeeded!
2025-09-28T03:02:23.853589735Z [ls.io-init] done.
2025-09-28T03:02:25.656923115Z Error: You must be logged in to do that
2025-09-28T03:02:25.656963757Z at /app/www/public/backend/build/src/middleware/authentication.js:41:23
2025-09-28T03:02:25.656973777Z at Generator.next (<anonymous>)
2025-09-28T03:02:25.656982936Z at /app/www/public/backend/build/src/middleware/authentication.js:8:71
2025-09-28T03:02:25.656991453Z at new Promise (<anonymous>)
2025-09-28T03:02:25.656999940Z at __awaiter (/app/www/public/backend/build/src/middleware/authentication.js:4:12)
2025-09-28T03:02:25.657008427Z at expressAuthentication (/app/www/public/backend/build/src/middleware/authentication.js:22:12)
2025-09-28T03:02:25.657017245Z at /app/www/public/backend/build/routes.js:1245:97
2025-09-28T03:02:25.657025652Z at Generator.next (<anonymous>)
2025-09-28T03:02:25.657034299Z at /app/www/public/backend/build/routes.js:8:71
2025-09-28T03:02:25.657042646Z at new Promise (<anonymous>) {
2025-09-28T03:02:25.657051113Z status: 401
2025-09-28T03:02:25.657059310Z }