2025-07-27T03:33:08.937010821Z [migrations] started
2025-07-27T03:33:09.028808346Z [migrations] 01-nginx-site-confs-default: executing...
2025-07-27T03:33:09.277221646Z [migrations] 01-nginx-site-confs-default: succeeded
2025-07-27T03:33:09.352472282Z [migrations] 02-default-location: executing...
2025-07-27T03:33:09.572663734Z [migrations] 02-default-location: succeeded
2025-07-27T03:33:09.573479697Z [migrations] done
2025-07-27T03:33:09.951384162Z usermod: no changes
2025-07-27T03:33:09.976494735Z ───────────────────────────────────────
2025-07-27T03:33:09.976532702Z 
2025-07-27T03:33:09.976542291Z       ██╗     ███████╗██╗ ██████╗
2025-07-27T03:33:09.976551099Z       ██║     ██╔════╝██║██╔═══██╗
2025-07-27T03:33:09.976560007Z       ██║     ███████╗██║██║   ██║
2025-07-27T03:33:09.976568554Z       ██║     ╚════██║██║██║   ██║
2025-07-27T03:33:09.976577141Z       ███████╗███████║██║╚██████╔╝
2025-07-27T03:33:09.976585398Z       ╚══════╝╚══════╝╚═╝ ╚═════╝
2025-07-27T03:33:09.976593835Z 
2025-07-27T03:33:09.976601681Z    Brought to you by linuxserver.io
2025-07-27T03:33:09.976609807Z ───────────────────────────────────────
2025-07-27T03:33:09.981504694Z 
2025-07-27T03:33:09.981554704Z To support LSIO projects visit:
2025-07-27T03:33:09.981568061Z https://www.linuxserver.io/donate/
2025-07-27T03:33:09.981579134Z 
2025-07-27T03:33:09.981589424Z ───────────────────────────────────────
2025-07-27T03:33:09.981601078Z GID/UID
2025-07-27T03:33:09.981741921Z ───────────────────────────────────────
2025-07-27T03:33:10.070395616Z 
2025-07-27T03:33:10.070425276Z User UID:    911
2025-07-27T03:33:10.070434013Z User GID:    911
2025-07-27T03:33:10.070442270Z ───────────────────────────────────────
2025-07-27T03:33:10.103364533Z Linuxserver.io version: 0.0.9-ls160
2025-07-27T03:33:10.107182040Z Build-date: 2025-07-27T03:23:50+00:00
2025-07-27T03:33:10.107203002Z ───────────────────────────────────────
2025-07-27T03:33:10.107210217Z     
2025-07-27T03:33:12.687374405Z Setting resolver to  8.8.8.8 8.8.4.4
2025-07-27T03:33:12.829893875Z Setting worker_processes to 64
2025-07-27T03:33:13.548423540Z generating self-signed keys in /config/keys, you can replace these with your own keys if required
2025-07-27T03:33:13.995004364Z ............+.........+...+......+.....+.+...+...+........+....+...........+.+.....+....+.........+.....................+.....+......+..........+.....+...+...+++++++++++++++++++++++++++++++++++++++*...+.+...+......+..+++++++++++++++++++++++++++++++++++++++*...+..+.+...+.........+..+.........+.+.........+.....+.+......+...+......+.....+......+.........+...+...+.............+............+..+..................+.......+......+....................+.+.........+...........+.+.........+.........+..+...+............+....+........+.+..+...+.+...+.....+......+....+.....+.+..............+......+....+...............+..+......+..........+...+..+............+.+..+..........+........+......+...+.+......+...........+....+.....+.+.........+..............+.........+...+............+................+..+.........+...+.+.....+.+......+...+............+...............+...+.....+.......+..+............+...+.......+...+...+..+.+..+.........++++++
2025-07-27T03:33:14.343533959Z ...+.......+++++++++++++++++++++++++++++++++++++++*......+.....+.......+++++++++++++++++++++++++++++++++++++++*.....+......+....................+....+.....+...+....+..................+...+.....+.........+......+..........+..+......+.+...............+......+..+......+....+.....+......+...............+....+...+...+..+.......+..+...+.......+...+...+........+......+..........+........+.+..+....+...+........+.......+...............+..+.+.....+............+.+......+..............+....+..+.+...+.....+.+......+........+.......+........+....+...+.....+.........+.+..+.......+..............+.+.........+..+....+..............+.+......+........+.+........+...+...+......+.........+....+..+..........+........+...+...+.......+........+.+.....................+.................+...+........................+...+.+......+...+..+.............+.................+.+...+............+...+..++++++
2025-07-27T03:33:14.378979874Z -----
2025-07-27T03:33:15.692140339Z New container detected. Setting up app folder and fixing permissions.
2025-07-27T03:33:54.609730011Z query: SELECT * FROM "sqlite_master" WHERE "type" = 'table' AND "name" = 'migrations'
2025-07-27T03:33:54.754519121Z query: CREATE TABLE "migrations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "timestamp" bigint NOT NULL, "name" varchar NOT NULL)
2025-07-27T03:33:54.850423276Z query: SELECT * FROM "migrations" "migrations" ORDER BY "id" DESC
2025-07-27T03:33:54.863456640Z 0 migrations are already loaded in the database.
2025-07-27T03:33:54.864025896Z 3 migrations were found in the source code.
2025-07-27T03:33:54.864454710Z 3 migrations are new migrations that needs to be executed.
2025-07-27T03:33:54.877725933Z query: BEGIN TRANSACTION
2025-07-27T03:33:54.910129451Z query: SELECT COUNT(*) FROM users
2025-07-27T03:33:54.945616078Z query failed: SELECT COUNT(*) FROM users
2025-07-27T03:33:54.956320943Z error: Error: SQLITE_ERROR: no such table: users
2025-07-27T03:33:54.956345523Z --> in Database#all('SELECT COUNT(*) FROM users', undefined, [Function: handler])
2025-07-27T03:33:54.956355383Z     at SqliteQueryRunner.<anonymous> (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:60:56)
2025-07-27T03:33:54.956397077Z     at step (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:143:27)
2025-07-27T03:33:54.956405534Z     at Object.next (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:124:57)
2025-07-27T03:33:54.956413740Z     at /app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:117:75
2025-07-27T03:33:54.956421917Z     at new Promise (<anonymous>)
2025-07-27T03:33:54.956430093Z     at Object.__awaiter (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:113:16)
2025-07-27T03:33:54.956438771Z     at execute (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:54:64)
2025-07-27T03:33:54.956446867Z     at SqliteQueryRunner.<anonymous> (/app/www/public/backend/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:101:46)
2025-07-27T03:33:54.956455274Z     at step (/app/www/public/backend/node_modules/typeorm/node_modules/tslib/tslib.js:143:27) {
2025-07-27T03:33:54.956463360Z   errno: 1,
2025-07-27T03:33:54.956471146Z   code: 'SQLITE_ERROR',
2025-07-27T03:33:54.956479062Z   __augmented: true
2025-07-27T03:33:54.956486878Z }
2025-07-27T03:33:54.988517605Z 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-07-27T03:33:55.015596763Z query: CREATE UNIQUE INDEX "IDX_97672ac88f789774dd47f7c8be" ON "users" ("email") 
2025-07-27T03:33:55.073053969Z 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-07-27T03:33:55.094244579Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId") 
2025-07-27T03:33:55.109915925Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month") 
2025-07-27T03:33:55.150462370Z 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-07-27T03:33:55.168813162Z query: CREATE INDEX "IDX_cba488e36ca6ff6eec83e91440" ON "category_months" ("categoryId") 
2025-07-27T03:33:55.177843947Z query: CREATE INDEX "IDX_de0f1ed5fe7ad4f2254bb815be" ON "category_months" ("budgetMonthId") 
2025-07-27T03:33:55.189558526Z query: CREATE INDEX "IDX_23f4c8894717fb764a2b88ff29" ON "category_months" ("month") 
2025-07-27T03:33:55.231669040Z 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-07-27T03:33:55.247375466Z query: CREATE INDEX "IDX_e6d5be2f8c1fbd283150e043a0" ON "categories" ("budgetId") 
2025-07-27T03:33:55.258176065Z query: CREATE UNIQUE INDEX "IDX_af173d6048d44da16b00e49e24" ON "categories" ("trackingAccountId") 
2025-07-27T03:33:55.288501158Z 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-07-27T03:33:55.329780349Z 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-07-27T03:33:55.361462164Z query: CREATE INDEX "IDX_7098ffeb5373b7d6344f4f1663" ON "transactions" ("transferTransactionId") 
2025-07-27T03:33:55.399690080Z 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-07-27T03:33:55.424480088Z 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-07-27T03:33:55.449843590Z 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-07-27T03:33:55.456446236Z query: CREATE INDEX "IDX_0dcceebef7c019bc892be7b5d0" ON "category_groups" ("budgetId") 
2025-07-27T03:33:55.464224759Z query: DROP INDEX "IDX_398c07457719d1899ba4f11914"
2025-07-27T03:33:55.481874699Z query: DROP INDEX "IDX_0c21df54422306fdf78621fc18"
2025-07-27T03:33:55.514860320Z 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-07-27T03:33:55.538087841Z 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-07-27T03:33:55.553212085Z query: DROP TABLE "budget_months"
2025-07-27T03:33:55.563209667Z query: ALTER TABLE "temporary_budget_months" RENAME TO "budget_months"
2025-07-27T03:33:55.628487531Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId") 
2025-07-27T03:33:55.640620152Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month") 
2025-07-27T03:33:55.646534511Z query: DROP INDEX "IDX_cba488e36ca6ff6eec83e91440"
2025-07-27T03:33:55.651098371Z query: DROP INDEX "IDX_de0f1ed5fe7ad4f2254bb815be"
2025-07-27T03:33:55.655911092Z query: DROP INDEX "IDX_23f4c8894717fb764a2b88ff29"
2025-07-27T03:33:55.696329820Z 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-07-27T03:33:55.707606537Z 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-07-27T03:33:55.711401809Z query: DROP TABLE "category_months"
2025-07-27T03:33:55.716370384Z query: ALTER TABLE "temporary_category_months" RENAME TO "category_months"
2025-07-27T03:33:55.748315449Z query: CREATE INDEX "IDX_cba488e36ca6ff6eec83e91440" ON "category_months" ("categoryId") 
2025-07-27T03:33:55.758371519Z query: CREATE INDEX "IDX_de0f1ed5fe7ad4f2254bb815be" ON "category_months" ("budgetMonthId") 
2025-07-27T03:33:55.763137816Z query: CREATE INDEX "IDX_23f4c8894717fb764a2b88ff29" ON "category_months" ("month") 
2025-07-27T03:33:55.766906084Z query: DROP INDEX "IDX_e6d5be2f8c1fbd283150e043a0"
2025-07-27T03:33:55.770445501Z query: DROP INDEX "IDX_af173d6048d44da16b00e49e24"
2025-07-27T03:33:55.803709492Z 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-07-27T03:33:55.816330366Z 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-07-27T03:33:55.819746465Z query: DROP TABLE "categories"
2025-07-27T03:33:55.835596791Z query: ALTER TABLE "temporary_categories" RENAME TO "categories"
2025-07-27T03:33:55.867753983Z query: CREATE INDEX "IDX_e6d5be2f8c1fbd283150e043a0" ON "categories" ("budgetId") 
2025-07-27T03:33:55.875122110Z query: CREATE UNIQUE INDEX "IDX_af173d6048d44da16b00e49e24" ON "categories" ("trackingAccountId") 
2025-07-27T03:33:55.916100996Z 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-07-27T03:33:55.929058317Z query: INSERT INTO "temporary_payees"("id", "budgetId", "transferAccountId", "name", "internal", "created", "updated") SELECT "id", "budgetId", "transferAccountId", "name", "internal", "created", "updated" FROM "payees"
2025-07-27T03:33:55.933147321Z query: DROP TABLE "payees"
2025-07-27T03:33:55.938393655Z query: ALTER TABLE "temporary_payees" RENAME TO "payees"
2025-07-27T03:33:55.968875063Z query: DROP INDEX "IDX_7098ffeb5373b7d6344f4f1663"
2025-07-27T03:33:56.009182988Z 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-07-27T03:33:56.024347773Z 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-07-27T03:33:56.028571949Z query: DROP TABLE "transactions"
2025-07-27T03:33:56.033345682Z query: ALTER TABLE "temporary_transactions" RENAME TO "transactions"
2025-07-27T03:33:56.063606215Z query: CREATE INDEX "IDX_7098ffeb5373b7d6344f4f1663" ON "transactions" ("transferTransactionId") 
2025-07-27T03:33:56.109087758Z 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-07-27T03:33:56.119956273Z 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-07-27T03:33:56.123362271Z query: DROP TABLE "accounts"
2025-07-27T03:33:56.129102760Z query: ALTER TABLE "temporary_accounts" RENAME TO "accounts"
2025-07-27T03:33:56.170365458Z 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-07-27T03:33:56.178178009Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "toBeBudgeted", "created", "updated") SELECT "id", "userId", "name", "toBeBudgeted", "created", "updated" FROM "budgets"
2025-07-27T03:33:56.181307761Z query: DROP TABLE "budgets"
2025-07-27T03:33:56.188224890Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-07-27T03:33:56.216058476Z query: DROP INDEX "IDX_0dcceebef7c019bc892be7b5d0"
2025-07-27T03:33:56.236366258Z 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-07-27T03:33:56.247728327Z 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-07-27T03:33:56.252152185Z query: DROP TABLE "category_groups"
2025-07-27T03:33:56.258376138Z query: ALTER TABLE "temporary_category_groups" RENAME TO "category_groups"
2025-07-27T03:33:56.288548854Z query: CREATE INDEX "IDX_0dcceebef7c019bc892be7b5d0" ON "category_groups" ("budgetId") 
2025-07-27T03:33:56.337246333Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1649259669912,"initial1649259669912"]
2025-07-27T03:33:56.348310722Z Migration initial1649259669912 has been executed successfully.
2025-07-27T03:33:56.364468407Z 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-07-27T03:33:56.374483314Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "created", "updated") SELECT "id", "userId", "name", "created", "updated" FROM "budgets"
2025-07-27T03:33:56.377705442Z query: DROP TABLE "budgets"
2025-07-27T03:33:56.391125214Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-07-27T03:33:56.420674285Z query: DROP INDEX "IDX_0c21df54422306fdf78621fc18"
2025-07-27T03:33:56.423868897Z query: DROP INDEX "IDX_398c07457719d1899ba4f11914"
2025-07-27T03:33:56.452137419Z 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-07-27T03:33:56.462106604Z 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-07-27T03:33:56.466494740Z query: DROP TABLE "budget_months"
2025-07-27T03:33:56.472901180Z query: ALTER TABLE "temporary_budget_months" RENAME TO "budget_months"
2025-07-27T03:33:56.504576692Z query: CREATE INDEX "IDX_0c21df54422306fdf78621fc18" ON "budget_months" ("month") 
2025-07-27T03:33:56.508938014Z query: CREATE INDEX "IDX_398c07457719d1899ba4f11914" ON "budget_months" ("budgetId") 
2025-07-27T03:33:56.527262042Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1649260258195,"budgetMonthAvailable1649260258195"]
2025-07-27T03:33:56.530680896Z Migration budgetMonthAvailable1649260258195 has been executed successfully.
2025-07-27T03:33:56.547979589Z 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-07-27T03:33:56.556169260Z query: INSERT INTO "temporary_budgets"("id", "userId", "name", "created", "updated") SELECT "id", "userId", "name", "created", "updated" FROM "budgets"
2025-07-27T03:33:56.559354624Z query: DROP TABLE "budgets"
2025-07-27T03:33:56.564415615Z query: ALTER TABLE "temporary_budgets" RENAME TO "budgets"
2025-07-27T03:33:56.603650940Z query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1650032177205,"addBudgetCurrency1650032177205"]
2025-07-27T03:33:56.606221797Z Migration addBudgetCurrency1650032177205 has been executed successfully.
2025-07-27T03:33:56.609669148Z query: COMMIT
2025-07-27T03:34:07.172335787Z [custom-init] No custom files found, skipping...
2025-07-27T03:34:10.842723233Z 
2025-07-27T03:34:10.842764216Z > BudgE@0.0.8 start
2025-07-27T03:34:10.842773915Z > node build/src/server.js
2025-07-27T03:34:10.842782082Z 
2025-07-27T03:34:21.288382796Z !!!WARNING!!! Running in development mode!
2025-07-27T03:34:22.225136573Z Server listening on: http://0.0.0.0:5000
2025-07-27T03:34:22.290647968Z Connection to localhost (127.0.0.1) 5000 port [tcp/*] succeeded!
2025-07-27T03:34:22.730212655Z [ls.io-init] done.
2025-07-27T03:34:24.965940463Z Error: You must be logged in to do that
2025-07-27T03:34:24.965973650Z     at /app/www/public/backend/build/src/middleware/authentication.js:41:23
2025-07-27T03:34:24.965977999Z     at Generator.next (<anonymous>)
2025-07-27T03:34:24.965982758Z     at /app/www/public/backend/build/src/middleware/authentication.js:8:71
2025-07-27T03:34:24.965986596Z     at new Promise (<anonymous>)
2025-07-27T03:34:24.965990283Z     at __awaiter (/app/www/public/backend/build/src/middleware/authentication.js:4:12)
2025-07-27T03:34:24.965993971Z     at expressAuthentication (/app/www/public/backend/build/src/middleware/authentication.js:22:12)
2025-07-27T03:34:24.965997688Z     at /app/www/public/backend/build/routes.js:1245:97
2025-07-27T03:34:24.966001326Z     at Generator.next (<anonymous>)
2025-07-27T03:34:24.966004953Z     at /app/www/public/backend/build/routes.js:8:71
2025-07-27T03:34:24.966008580Z     at new Promise (<anonymous>) {
2025-07-27T03:34:24.966012358Z   status: 401
2025-07-27T03:34:24.966015955Z }