2025-08-03T03:36:26.292303519Z [migrations] started
2025-08-03T03:36:26.383404580Z [migrations] 01-nginx-site-confs-default: executing...
2025-08-03T03:36:26.643813118Z [migrations] 01-nginx-site-confs-default: succeeded
2025-08-03T03:36:26.713193793Z [migrations] 02-default-location: executing...
2025-08-03T03:36:26.936975539Z [migrations] 02-default-location: succeeded
2025-08-03T03:36:26.937608393Z [migrations] done
2025-08-03T03:36:27.347881598Z usermod: no changes
2025-08-03T03:36:27.386553107Z ───────────────────────────────────────
2025-08-03T03:36:27.386598709Z
2025-08-03T03:36:27.386608248Z ██╗ ███████╗██╗ ██████╗
2025-08-03T03:36:27.386616855Z ██║ ██╔════╝██║██╔═══██╗
2025-08-03T03:36:27.386626034Z ██║ ███████╗██║██║ ██║
2025-08-03T03:36:27.386634751Z ██║ ╚════██║██║██║ ██║
2025-08-03T03:36:27.386643409Z ███████╗███████║██║╚██████╔╝
2025-08-03T03:36:27.386651715Z ╚══════╝╚══════╝╚═╝ ╚═════╝
2025-08-03T03:36:27.386660323Z
2025-08-03T03:36:27.386668349Z Brought to you by linuxserver.io
2025-08-03T03:36:27.386676555Z ───────────────────────────────────────
2025-08-03T03:36:27.392692910Z
2025-08-03T03:36:27.392714474Z To support LSIO projects visit:
2025-08-03T03:36:27.392723181Z https://www.linuxserver.io/donate/
2025-08-03T03:36:27.392731468Z
2025-08-03T03:36:27.392739354Z ───────────────────────────────────────
2025-08-03T03:36:27.392747961Z GID/UID
2025-08-03T03:36:27.392961541Z ───────────────────────────────────────
2025-08-03T03:36:27.471163368Z
2025-08-03T03:36:27.471198489Z User UID: 911
2025-08-03T03:36:27.471208048Z User GID: 911
2025-08-03T03:36:27.471216365Z ───────────────────────────────────────
2025-08-03T03:36:27.506960880Z Linuxserver.io version: 0.0.9-ls161
2025-08-03T03:36:27.510243029Z Build-date: 2025-08-03T03:27:27+00:00
2025-08-03T03:36:27.510272157Z ───────────────────────────────────────
2025-08-03T03:36:27.510282248Z
2025-08-03T03:36:30.022284949Z Setting resolver to 8.8.8.8 8.8.4.4
2025-08-03T03:36:30.129316126Z Setting worker_processes to 64
2025-08-03T03:36:30.866567714Z generating self-signed keys in /config/keys, you can replace these with your own keys if required
2025-08-03T03:36:31.032212676Z ......+++++++++++++++++++++++++++++++++++++++*.+.........+......+........+.+.....+.........+.+............+..+.+......+.....+.+..+++++++++++++++++++++++++++++++++++++++*.......++++++
2025-08-03T03:36:31.399503812Z ..+...+....+...+.....+++++++++++++++++++++++++++++++++++++++*..+........+..........+..+....+.....+....+............+..+...+...+.+.....+...+.+.....+.........+...+.......+...+..+.......+......+.....+...+++++++++++++++++++++++++++++++++++++++*....+.....+..................+...+.......+..+.+..+......+......+....+...........+.+............+...+........+....+.....+...+............+......+.+...+...+..............+...+.+.....+......+.+...+.................+..........+...+...........+.............+.....+......+.......+...+.....+.+...+..+.........+..........+......+...+..+.+..+.......+...+...............+...+..+.+..+............+...............+...+...+......+....+...........+.+..+...+.........+..........+.........+..+.......+..+...+................+..+....+......+...+.........+..+...............+...+......+.......+............+......+............+..+.+.................+.............+......+.....+...+.+.....+.......+.........+......+.....+.........+.............+..+......+.......+...........+.........+......+.+...+.................+......+.........+.+..+...+....+...+...........+......+......+....+...+..................+........++++++
2025-08-03T03:36:31.434397715Z -----
2025-08-03T03:36:32.748524446Z New container detected. Setting up app folder and fixing permissions.
2025-08-03T03:37:11.709287724Z query: SELECT * FROM "sqlite_master" WHERE "type" = 'table' AND "name" = 'migrations'
2025-08-03T03:37:11.863299171Z query: CREATE TABLE "migrations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "timestamp" bigint NOT NULL, "name" varchar NOT NULL)
2025-08-03T03:37:11.958069501Z query: SELECT * FROM "migrations" "migrations" ORDER BY "id" DESC
2025-08-03T03:37:11.969398713Z 0 migrations are already loaded in the database.
2025-08-03T03:37:11.969748357Z 3 migrations were found in the source code.
2025-08-03T03:37:11.970035054Z 3 migrations are new migrations that needs to be executed.
2025-08-03T03:37:11.981087019Z query: BEGIN TRANSACTION
2025-08-03T03:37:12.014035834Z query: SELECT COUNT(*) FROM users
2025-08-03T03:37:12.051385030Z query failed: SELECT COUNT(*) FROM users
2025-08-03T03:37:12.062056218Z error: Error: SQLITE_ERROR: no such table: users
2025-08-03T03:37:12.062080557Z --> in Database#all('SELECT COUNT(*) FROM users', undefined, [Function: handler])
2025-08-03T03:37:12.062090577Z at SqliteQueryRunner.<anonymous> (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:60:56)
2025-08-03T03:37:12.062099906Z at step (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:143:27)
2025-08-03T03:37:12.062108263Z at Object.next (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:124:57)
2025-08-03T03:37:12.062116590Z at /app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:117:75
2025-08-03T03:37:12.062144997Z at new Promise (<anonymous>)
2025-08-03T03:37:12.062153404Z at Object.__awaiter (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:113:16)
2025-08-03T03:37:12.062161570Z at execute (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:54:64)
2025-08-03T03:37:12.062169767Z at SqliteQueryRunner.<anonymous> (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:101:46)
2025-08-03T03:37:12.062178144Z at step (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:143:27) {
2025-08-03T03:37:12.062186450Z errno: 1,
2025-08-03T03:37:12.062197132Z code: 'SQLITE_ERROR',
2025-08-03T03:37:12.062205138Z __augmented: true
2025-08-03T03:37:12.062213024Z }
2025-08-03T03:37:12.094557593Z 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-03T03:37:12.120670934Z query: CREATE UNIQUE INDEX "IDX_97672ac88f789774dd47f7c8be" ON "users" ("email")
2025-08-03T03:37:12.178906468Z 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-03T03:37:12.200188340Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-08-03T03:37:12.214996859Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-08-03T03:37:12.253137669Z 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-03T03:37:12.270469538Z query: CREATE INDEX "IDX_cba488e36ca6ff6eec83e91440" ON "category_months" ("categoryId")
2025-08-03T03:37:12.278073640Z query: CREATE INDEX "IDX_de0f1ed5fe7ad4f2254bb815be" ON "category_months" ("budgetMonthId")
2025-08-03T03:37:12.288504874Z query: CREATE INDEX "IDX_23f4c8894717fb764a2b88ff29" ON "category_months" ("month")
2025-08-03T03:37:12.329968616Z 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-03T03:37:12.344046944Z query: CREATE INDEX "IDX_e6d5be2f8c1fbd283150e043a0" ON "categories" ("budgetId")
2025-08-03T03:37:12.354883835Z query: CREATE UNIQUE INDEX "IDX_af173d6048d44da16b00e49e24" ON "categories" ("trackingAccountId")
2025-08-03T03:37:12.385512258Z 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-03T03:37:12.424585687Z 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-03T03:37:12.458425216Z query: CREATE INDEX "IDX_7098ffeb5373b7d6344f4f1663" ON "transactions" ("transferTransactionId")
2025-08-03T03:37:12.503973852Z 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-03T03:37:12.529026508Z 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-03T03:37:12.554445191Z 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-03T03:37:12.560900409Z query: CREATE INDEX "IDX_0dcceebef7c019bc892be7b5d0" ON "category_groups" ("budgetId")
2025-08-03T03:37:12.568759514Z query: DROP INDEX "IDX_398c07457719d1899ba4f11914"
2025-08-03T03:37:12.584354176Z query: DROP INDEX "IDX_0c21df54422306fdf78621fc18"
2025-08-03T03:37:12.617316078Z 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-03T03:37:12.640479269Z 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-03T03:37:12.657321042Z query: DROP TABLE "budget_months"
2025-08-03T03:37:12.667385448Z query: ALTER TABLE "temporary_budget_months" RENAME TO "budget_months"
2025-08-03T03:37:12.735182453Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-08-03T03:37:12.747199250Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-08-03T03:37:12.752661108Z query: DROP INDEX "IDX_cba488e36ca6ff6eec83e91440"
2025-08-03T03:37:12.757172733Z query: DROP INDEX "IDX_de0f1ed5fe7ad4f2254bb815be"
2025-08-03T03:37:12.761681512Z query: DROP INDEX "IDX_23f4c8894717fb764a2b88ff29"
2025-08-03T03:37:12.801040284Z 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-03T03:37:12.811982568Z 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-03T03:37:12.815796517Z query: DROP TABLE "category_months"
2025-08-03T03:37:12.820606864Z query: ALTER TABLE "temporary_category_months" RENAME TO "category_months"
2025-08-03T03:37:12.852610777Z query: CREATE INDEX "IDX_cba488e36ca6ff6eec83e91440" ON "category_months" ("categoryId")
2025-08-03T03:37:12.860416084Z query: CREATE INDEX "IDX_de0f1ed5fe7ad4f2254bb815be" ON "category_months" ("budgetMonthId")
2025-08-03T03:37:12.866086511Z query: CREATE INDEX "IDX_23f4c8894717fb764a2b88ff29" ON "category_months" ("month")
2025-08-03T03:37:12.869721421Z query: DROP INDEX "IDX_e6d5be2f8c1fbd283150e043a0"
2025-08-03T03:37:12.873113020Z query: DROP INDEX "IDX_af173d6048d44da16b00e49e24"
2025-08-03T03:37:12.905275362Z 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-03T03:37:12.917798629Z 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-03T03:37:12.921574863Z query: DROP TABLE "categories"
2025-08-03T03:37:12.937135676Z query: ALTER TABLE "temporary_categories" RENAME TO "categories"
2025-08-03T03:37:12.969044076Z query: CREATE INDEX "IDX_e6d5be2f8c1fbd283150e043a0" ON "categories" ("budgetId")
2025-08-03T03:37:12.978938359Z query: CREATE UNIQUE INDEX "IDX_af173d6048d44da16b00e49e24" ON "categories" ("trackingAccountId")
2025-08-03T03:37:13.032893584Z 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-03T03:37:13.044960812Z query: INSERT INTO "temporary_payees"("id", "budgetId", "transferAccountId", "name", "internal", "created", "updated") SELECT "id", "budgetId", "transferAccountId", "name", "internal", "created", "updated" FROM "payees"
2025-08-03T03:37:13.048703258Z query: DROP TABLE "payees"
2025-08-03T03:37:13.054298334Z query: ALTER TABLE "temporary_payees" RENAME TO "payees"
2025-08-03T03:37:13.084477352Z query: DROP INDEX "IDX_7098ffeb5373b7d6344f4f1663"
2025-08-03T03:37:13.123541252Z 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-03T03:37:13.139094590Z 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-03T03:37:13.143126960Z query: DROP TABLE "transactions"
2025-08-03T03:37:13.147877304Z query: ALTER TABLE "temporary_transactions" RENAME TO "transactions"
2025-08-03T03:37:13.178548324Z query: CREATE INDEX "IDX_7098ffeb5373b7d6344f4f1663" ON "transactions" ("transferTransactionId")
2025-08-03T03:37:13.210778863Z 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-03T03:37:13.222243538Z 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-03T03:37:13.225395856Z query: DROP TABLE "accounts"
2025-08-03T03:37:13.231069440Z query: ALTER TABLE "temporary_accounts" RENAME TO "accounts"
2025-08-03T03:37:13.273072828Z 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-03T03:37:13.280868365Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "toBeBudgeted", "created", "updated") SELECT "id", "userId", "name", "toBeBudgeted", "created", "updated" FROM "budgets"
2025-08-03T03:37:13.284304334Z query: DROP TABLE "budgets"
2025-08-03T03:37:13.290203623Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-08-03T03:37:13.319762903Z query: DROP INDEX "IDX_0dcceebef7c019bc892be7b5d0"
2025-08-03T03:37:13.348960476Z 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-03T03:37:13.360458197Z 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-03T03:37:13.364777445Z query: DROP TABLE "category_groups"
2025-08-03T03:37:13.370810312Z query: ALTER TABLE "temporary_category_groups" RENAME TO "category_groups"
2025-08-03T03:37:13.403377970Z query: CREATE INDEX "IDX_0dcceebef7c019bc892be7b5d0" ON "category_groups" ("budgetId")
2025-08-03T03:37:13.459668397Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1649259669912,"initial1649259669912"]
2025-08-03T03:37:13.470289894Z Migration initial1649259669912 has been executed successfully.
2025-08-03T03:37:13.486398891Z 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-03T03:37:13.497039968Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "created", "updated") SELECT "id", "userId", "name", "created", "updated" FROM "budgets"
2025-08-03T03:37:13.500483933Z query: DROP TABLE "budgets"
2025-08-03T03:37:13.507487775Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-08-03T03:37:13.533794747Z query: DROP INDEX "IDX_0c21df54422306fdf78621fc18"
2025-08-03T03:37:13.536911924Z query: DROP INDEX "IDX_398c07457719d1899ba4f11914"
2025-08-03T03:37:13.563760125Z 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-03T03:37:13.573488174Z 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-03T03:37:13.577306152Z query: DROP TABLE "budget_months"
2025-08-03T03:37:13.584316819Z query: ALTER TABLE "temporary_budget_months" RENAME TO "budget_months"
2025-08-03T03:37:13.609414655Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month")
2025-08-03T03:37:13.613638070Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId")
2025-08-03T03:37:13.628080501Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1649260258195,"budgetMonthAvailable1649260258195"]
2025-08-03T03:37:13.631304022Z Migration budgetMonthAvailable1649260258195 has been executed successfully.
2025-08-03T03:37:13.650788987Z 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-03T03:37:13.659521581Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "created", "updated") SELECT "id", "userId", "name", "created", "updated" FROM "budgets"
2025-08-03T03:37:13.662703848Z query: DROP TABLE "budgets"
2025-08-03T03:37:13.667563063Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-08-03T03:37:13.706122336Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1650032177205,"addBudgetCurrency1650032177205"]
2025-08-03T03:37:13.708551607Z Migration addBudgetCurrency1650032177205 has been executed successfully.
2025-08-03T03:37:13.712031204Z query: COMMIT
2025-08-03T03:37:23.968739498Z [custom-init] No custom files found, skipping...
2025-08-03T03:37:27.607487873Z
2025-08-03T03:37:27.607536451Z > BudgE@0.0.8 start
2025-08-03T03:37:27.607546481Z > node build/src/server.js
2025-08-03T03:37:27.607554868Z
2025-08-03T03:37:38.231358156Z !!!WARNING!!! Running in development mode!
2025-08-03T03:37:39.140524662Z Server listening on: http://0.0.0.0:5000
2025-08-03T03:37:40.106181654Z Connection to localhost (127.0.0.1) 5000 port [tcp/*] succeeded!
2025-08-03T03:37:40.561723653Z [ls.io-init] done.
2025-08-03T03:37:42.072867901Z Error: You must be logged in to do that
2025-08-03T03:37:42.072914926Z at /app/www/public/backend/build/src/middleware/authentication.js:41:23
2025-08-03T03:37:42.072924656Z at Generator.next (<anonymous>)
2025-08-03T03:37:42.072933484Z at /app/www/public/backend/build/src/middleware/authentication.js:8:71
2025-08-03T03:37:42.072941690Z at new Promise (<anonymous>)
2025-08-03T03:37:42.072950277Z at __awaiter (/app/www/public/backend/build/src/middleware/authentication.js:4:12)
2025-08-03T03:37:42.072958865Z at expressAuthentication (/app/www/public/backend/build/src/middleware/authentication.js:22:12)
2025-08-03T03:37:42.072967121Z at /app/www/public/backend/build/routes.js:1245:97
2025-08-03T03:37:42.072975147Z at Generator.next (<anonymous>)
2025-08-03T03:37:42.072983254Z at /app/www/public/backend/build/routes.js:8:71
2025-08-03T03:37:42.072991310Z at new Promise (<anonymous>) {
2025-08-03T03:37:42.072999627Z status: 401
2025-08-03T03:37:42.073007613Z }