Klein probleempje. Ik had eindelijk firefly iii min of meer geconfigureerd en werkende voor mijn rekeningen. Ik dacht eventjes snel te upgraden maar daar is iets misgelopen. Blijkbaar bestaat men user account niet meer (en waarschijnlijk dan ook al men instellingen). Ik kan enkel een nieuwe user aanmaken, net zoals een nieuwe installatie.
uitgevoerd. Ik zat per ongeluk nog op een oudere readthedocs versie. Op de nieuwe rtd staat er ook nog
De upgrade is uitgevoerd na een reboot (windows) dus firefly was niet aan het draaien, maar mss is die rm commando belangrijk. Wat vreemd is, is dat bij het starten van de container hij er firefly_iii_app_1 van maakt (en firefly_iii_db_1).
Waarschijnlijk staat de oude database wel nog ergens en is ie nog te redden. Iemand enig idee?
Starting firefly_firefly_iii_db_1 ... done
Starting firefly_firefly_iii_app_1 ... done
Attaching to firefly_firefly_iii_db_1, firefly_firefly_iii_app_1
firefly_iii_db_1 | 2019-07-11 19:53:28.482 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
firefly_iii_db_1 | 2019-07-11 19:53:28.482 UTC [1] LOG: listening on IPv6 address "::", port 5432
firefly_iii_db_1 | 2019-07-11 19:53:28.487 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
firefly_iii_db_1 | 2019-07-11 19:53:28.504 UTC [22] LOG: database system was interrupted; last known up at 2019-07-06 17:23:53 UTC
firefly_iii_db_1 | 2019-07-11 19:53:28.881 UTC [22] LOG: database system was not properly shut down; automatic recovery in progress
firefly_iii_db_1 | 2019-07-11 19:53:28.885 UTC [22] LOG: redo starts at 0/1870A08
firefly_iii_db_1 | 2019-07-11 19:53:28.885 UTC [22] LOG: invalid record length at 0/1870AE8: wanted 24, got 0
firefly_iii_db_1 | 2019-07-11 19:53:28.885 UTC [22] LOG: redo done at 0/1870AB0
firefly_iii_db_1 | 2019-07-11 19:53:28.922 UTC [1] LOG: database system is ready to accept connections
firefly_iii_app_1 | Now in entrypoint.sh for Firefly III
firefly_iii_app_1 | Architecture: x86_64
firefly_iii_app_1 | CPU op-mode(s): 32-bit, 64-bit
firefly_iii_app_1 | Byte Order: Little Endian
firefly_iii_app_1 | CPU(s): 2
firefly_iii_app_1 | On-line CPU(s) list: 0,1
firefly_iii_app_1 | Thread(s) per core: 1
firefly_iii_app_1 | Core(s) per socket: 2
firefly_iii_app_1 | Socket(s): 1
firefly_iii_app_1 | Vendor ID: GenuineIntel
firefly_iii_app_1 | CPU family: 6
firefly_iii_app_1 | Model: 60
firefly_iii_app_1 | Model name: Intel(R) Core(TM) i5-4460 CPU @ 3.20GHz
firefly_iii_app_1 | Stepping: 3
firefly_iii_app_1 | CPU MHz: 2848.853
firefly_iii_app_1 | BogoMIPS: 5697.70
firefly_iii_app_1 | Hypervisor vendor: Microsoft
firefly_iii_app_1 | Virtualization type: full
firefly_iii_app_1 | L1d cache: 32K
firefly_iii_app_1 | L1i cache: 32K
firefly_iii_app_1 | L2 cache: 256K
firefly_iii_app_1 | L3 cache: 6144K
firefly_iii_app_1 | Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss ht syscall nx pdpe1gb rdtscp lm constant_tsc rep_good nopl xtopology pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 movbe popcnt aes xsave avx f16c rdrand hypervisor lahf_lm abm invpcid_single ssbd ibrs ibpb stibp kaiser fsgsbase bmi1 avx2 smep bmi2 erms invpcid xsaveopt flush_l1d arch_capabilities
firefly_iii_app_1 | Making directories...
firefly_iii_app_1 | Touch DB file (if SQLlite)...
firefly_iii_app_1 | Run chown on /var/www/firefly-iii/storage...
firefly_iii_app_1 | Run chmod on /var/www/firefly-iii/storage...
firefly_iii_app_1 | Remove log file...
firefly_iii_app_1 | Map environment variables on .env file...
firefly_iii_app_1 | Dump auto load...
firefly_iii_app_1 | Generating optimized autoload files> Illuminate\Foundation\ComposerScripts::postAutoloadDump
Generated optimized autoload files containing 4639 classes
firefly_iii_app_1 | Discover packages...
firefly_iii_app_1 | Discovered Package: adldap2/adldap2-laravel
firefly_iii_app_1 | Discovered Package: danhunsaker/laravel-flysystem-others
firefly_iii_app_1 | Discovered Package: davejamesmiller/laravel-breadcrumbs
firefly_iii_app_1 | Discovered Package: fideloper/proxy
firefly_iii_app_1 | Discovered Package: laravel/passport
firefly_iii_app_1 | Discovered Package: laravelcollective/html
firefly_iii_app_1 | Discovered Package: nesbot/carbon
firefly_iii_app_1 | Discovered Package: pragmarx/google2fa-laravel
firefly_iii_app_1 | Discovered Package: rcrowe/twigbridge
firefly_iii_app_1 | Package manifest generated successfully.
firefly_iii_app_1 | Run various artisan commands...
firefly_iii_app_1 | Nothing to migrate.
firefly_iii_app_1 | Seeding: AccountTypeSeeder
firefly_iii_db_1 | 2019-07-11 19:53:32.349 UTC [29] ERROR: duplicate key value violates unique constraint "account_types_type_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.349 UTC [29] DETAIL: Key (type)=(Default account) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.349 UTC [29] STATEMENT: insert into "account_types" ("type", "updated_at", "created_at") values ($1, $2, $3) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create account type "Default account". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.354 UTC [29] ERROR: duplicate key value violates unique constraint "account_types_type_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.354 UTC [29] DETAIL: Key (type)=(Cash account) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.354 UTC [29] STATEMENT: insert into "account_types" ("type", "updated_at", "created_at") values ($1, $2, $3) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create account type "Cash account". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.356 UTC [29] ERROR: duplicate key value violates unique constraint "account_types_type_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.356 UTC [29] DETAIL: Key (type)=(Asset account) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.356 UTC [29] STATEMENT: insert into "account_types" ("type", "updated_at", "created_at") values ($1, $2, $3) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create account type "Asset account". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.358 UTC [29] ERROR: duplicate key value violates unique constraint "account_types_type_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.358 UTC [29] DETAIL: Key (type)=(Expense account) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.358 UTC [29] STATEMENT: insert into "account_types" ("type", "updated_at", "created_at") values ($1, $2, $3) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create account type "Expense account". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.360 UTC [29] ERROR: duplicate key value violates unique constraint "account_types_type_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.360 UTC [29] DETAIL: Key (type)=(Revenue account) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.360 UTC [29] STATEMENT: insert into "account_types" ("type", "updated_at", "created_at") values ($1, $2, $3) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create account type "Revenue account". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.362 UTC [29] ERROR: duplicate key value violates unique constraint "account_types_type_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.362 UTC [29] DETAIL: Key (type)=(Initial balance account) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.362 UTC [29] STATEMENT: insert into "account_types" ("type", "updated_at", "created_at") values ($1, $2, $3) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create account type "Initial balance account". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.363 UTC [29] ERROR: duplicate key value violates unique constraint "account_types_type_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.363 UTC [29] DETAIL: Key (type)=(Beneficiary account) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.363 UTC [29] STATEMENT: insert into "account_types" ("type", "updated_at", "created_at") values ($1, $2, $3) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create account type "Beneficiary account". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.365 UTC [29] ERROR: duplicate key value violates unique constraint "account_types_type_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.365 UTC [29] DETAIL: Key (type)=(Import account) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.365 UTC [29] STATEMENT: insert into "account_types" ("type", "updated_at", "created_at") values ($1, $2, $3) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create account type "Import account". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.367 UTC [29] ERROR: duplicate key value violates unique constraint "account_types_type_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.367 UTC [29] DETAIL: Key (type)=(Loan) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.367 UTC [29] STATEMENT: insert into "account_types" ("type", "updated_at", "created_at") values ($1, $2, $3) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create account type "Loan". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.369 UTC [29] ERROR: duplicate key value violates unique constraint "account_types_type_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.369 UTC [29] DETAIL: Key (type)=(Reconciliation account) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.369 UTC [29] STATEMENT: insert into "account_types" ("type", "updated_at", "created_at") values ($1, $2, $3) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create account type "Reconciliation account". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.371 UTC [29] ERROR: duplicate key value violates unique constraint "account_types_type_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.371 UTC [29] DETAIL: Key (type)=(Debt) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.371 UTC [29] STATEMENT: insert into "account_types" ("type", "updated_at", "created_at") values ($1, $2, $3) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create account type "Debt". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.373 UTC [29] ERROR: duplicate key value violates unique constraint "account_types_type_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.373 UTC [29] DETAIL: Key (type)=(Mortgage) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.373 UTC [29] STATEMENT: insert into "account_types" ("type", "updated_at", "created_at") values ($1, $2, $3) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create account type "Mortgage". It might exist already.
firefly_iii_app_1 | Seeding: TransactionCurrencySeeder
firefly_iii_db_1 | 2019-07-11 19:53:32.380 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.380 UTC [29] DETAIL: Key (code)=(EUR) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.380 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "enabled", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6, $7) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "EUR". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.382 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.382 UTC [29] DETAIL: Key (code)=(HUF) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.382 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "HUF". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.384 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.384 UTC [29] DETAIL: Key (code)=(GBP) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.384 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "GBP". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.386 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.386 UTC [29] DETAIL: Key (code)=(UAH) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.386 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "UAH". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.388 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.388 UTC [29] DETAIL: Key (code)=(PLN) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.388 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "PLN". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.391 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.391 UTC [29] DETAIL: Key (code)=(TRY) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.391 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "TRY". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.393 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.393 UTC [29] DETAIL: Key (code)=(USD) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.393 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "USD". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.395 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.395 UTC [29] DETAIL: Key (code)=(BRL) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.395 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "BRL". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.398 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.398 UTC [29] DETAIL: Key (code)=(CAD) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.398 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "CAD". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.400 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.400 UTC [29] DETAIL: Key (code)=(IDR) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.400 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "IDR". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.402 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.402 UTC [29] DETAIL: Key (code)=(AUD) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.402 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "AUD". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.403 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.403 UTC [29] DETAIL: Key (code)=(NZD) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.403 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "NZD". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.405 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.405 UTC [29] DETAIL: Key (code)=(EGP) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.405 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "EGP". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.407 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.407 UTC [29] DETAIL: Key (code)=(MAD) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.407 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "MAD". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.409 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.409 UTC [29] DETAIL: Key (code)=(ZAR) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.409 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "ZAR". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.411 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.411 UTC [29] DETAIL: Key (code)=(JPY) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.411 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "JPY". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.414 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.414 UTC [29] DETAIL: Key (code)=(RMB) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.414 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "RMB". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.416 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.416 UTC [29] DETAIL: Key (code)=(RUB) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.416 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "RUB". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.418 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.418 UTC [29] DETAIL: Key (code)=(INR) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.418 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "INR". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.419 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.419 UTC [29] DETAIL: Key (code)=(XBT) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.419 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "XBT". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.421 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.421 UTC [29] DETAIL: Key (code)=(BCH) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.421 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "BCH". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.423 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.423 UTC [29] DETAIL: Key (code)=(ETH) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.423 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "ETH". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.424 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.424 UTC [29] DETAIL: Key (code)=(ILS) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.424 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "ILS". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.426 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.426 UTC [29] DETAIL: Key (code)=(CHF) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.426 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "CHF". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.427 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_currencies_code_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.427 UTC [29] DETAIL: Key (code)=(HRK) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.427 UTC [29] STATEMENT: insert into "transaction_currencies" ("code", "name", "symbol", "decimal_places", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction currency "HRK". It might exist already.
firefly_iii_app_1 | Seeding: TransactionTypeSeeder
firefly_iii_db_1 | 2019-07-11 19:53:32.431 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_types_type_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.431 UTC [29] DETAIL: Key (type)=(Withdrawal) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.431 UTC [29] STATEMENT: insert into "transaction_types" ("type", "updated_at", "created_at") values ($1, $2, $3) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction type "Withdrawal". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.433 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_types_type_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.433 UTC [29] DETAIL: Key (type)=(Deposit) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.433 UTC [29] STATEMENT: insert into "transaction_types" ("type", "updated_at", "created_at") values ($1, $2, $3) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction type "Deposit". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.435 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_types_type_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.435 UTC [29] DETAIL: Key (type)=(Transfer) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.435 UTC [29] STATEMENT: insert into "transaction_types" ("type", "updated_at", "created_at") values ($1, $2, $3) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction type "Transfer". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.437 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_types_type_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.437 UTC [29] DETAIL: Key (type)=(Opening balance) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.437 UTC [29] STATEMENT: insert into "transaction_types" ("type", "updated_at", "created_at") values ($1, $2, $3) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction type "Opening balance". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.439 UTC [29] ERROR: duplicate key value violates unique constraint "transaction_types_type_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.439 UTC [29] DETAIL: Key (type)=(Reconciliation) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.439 UTC [29] STATEMENT: insert into "transaction_types" ("type", "updated_at", "created_at") values ($1, $2, $3) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create transaction type "Reconciliation". It might exist already.
firefly_iii_app_1 | Seeding: PermissionSeeder
firefly_iii_db_1 | 2019-07-11 19:53:32.443 UTC [29] ERROR: duplicate key value violates unique constraint "roles_name_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.443 UTC [29] DETAIL: Key (name)=(owner) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.443 UTC [29] STATEMENT: insert into "roles" ("name", "display_name", "description", "updated_at", "created_at") values ($1, $2, $3, $4, $5) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create role "Site Owner". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.445 UTC [29] ERROR: duplicate key value violates unique constraint "roles_name_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.445 UTC [29] DETAIL: Key (name)=(demo) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.445 UTC [29] STATEMENT: insert into "roles" ("name", "display_name", "description", "updated_at", "created_at") values ($1, $2, $3, $4, $5) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create role "Demo User". It might exist already.
firefly_iii_app_1 | Seeding: LinkTypeSeeder
firefly_iii_db_1 | 2019-07-11 19:53:32.449 UTC [29] ERROR: duplicate key value violates unique constraint "link_types_name_outward_inward_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.449 UTC [29] DETAIL: Key (name, outward, inward)=(Related, relates to, relates to) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.449 UTC [29] STATEMENT: insert into "link_types" ("name", "inward", "outward", "editable", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create link type "Related". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.450 UTC [29] ERROR: duplicate key value violates unique constraint "link_types_name_outward_inward_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.450 UTC [29] DETAIL: Key (name, outward, inward)=(Refund, (partially) refunds, is (partially) refunded by) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.450 UTC [29] STATEMENT: insert into "link_types" ("name", "inward", "outward", "editable", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create link type "Refund". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.452 UTC [29] ERROR: duplicate key value violates unique constraint "link_types_name_outward_inward_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.452 UTC [29] DETAIL: Key (name, outward, inward)=(Paid, (partially) pays for, is (partially) paid for by) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.452 UTC [29] STATEMENT: insert into "link_types" ("name", "inward", "outward", "editable", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create link type "Paid". It might exist already.
firefly_iii_db_1 | 2019-07-11 19:53:32.453 UTC [29] ERROR: duplicate key value violates unique constraint "link_types_name_outward_inward_unique"
firefly_iii_db_1 | 2019-07-11 19:53:32.453 UTC [29] DETAIL: Key (name, outward, inward)=(Reimbursement, (partially) reimburses, is (partially) reimbursed by) already exists.
firefly_iii_db_1 | 2019-07-11 19:53:32.453 UTC [29] STATEMENT: insert into "link_types" ("name", "inward", "outward", "editable", "updated_at", "created_at") values ($1, $2, $3, $4, $5, $6) returning "id"
firefly_iii_app_1 | [2019-07-11 21:53:32] local.INFO: Could not create link type "Reimbursement". It might exist already.
firefly_iii_app_1 | Seeding: ConfigSeeder
firefly_iii_app_1 | [2019-07-11 21:53:32] local.WARNING: Database entry exists. Update to latest version (10)
firefly_iii_app_1 | Database seeding completed successfully.
firefly_iii_app_1 | Going to decrypt the database.
firefly_iii_app_1 | No decryption required for table "accounts".
firefly_iii_app_1 | No decryption required for table "attachments".
firefly_iii_app_1 | No decryption required for table "bills".
firefly_iii_app_1 | No decryption required for table "budgets".
firefly_iii_app_1 | No decryption required for table "categories".
firefly_iii_app_1 | No decryption required for table "piggy_banks".
firefly_iii_app_1 | No decryption required for table "preferences".
firefly_iii_app_1 | No decryption required for table "tags".
firefly_iii_app_1 | No decryption required for table "transaction_journals".
firefly_iii_app_1 | No decryption required for table "transactions".
firefly_iii_app_1 | No decryption required for table "journal_links".
firefly_iii_app_1 | Done!
firefly_iii_app_1 | [2019-07-11 21:53:32] local.DEBUG: Now in updateAccountCurrencies()
firefly_iii_app_1 | [2019-07-11 21:53:32] local.DEBUG: System default currency is "EUR"
firefly_iii_app_1 | Updating currency information..
firefly_iii_app_1 | Done updating currency information..
firefly_iii_app_1 | Firefly III database is up to date.
firefly_iii_app_1 | No orphaned transactions!
firefly_iii_app_1 | No orphaned journals!
firefly_iii_app_1 | All link types OK!
firefly_iii_app_1 | All access tokens OK!
firefly_iii_app_1 | Amount integrity OK!
firefly_iii_app_1 | Encryption keys already exist. Use the --force option to overwrite them.
firefly_iii_app_1 | [2019-07-11 21:53:34] local.INFO: OAuth client generated but no user associated.
firefly_iii_app_1 | Personal access client created successfully.
firefly_iii_app_1 | Client ID: 40
firefly_iii_app_1 | Client secret: X
firefly_iii_app_1 | [2019-07-11 21:53:34] local.INFO: OAuth client generated but no user associated.
firefly_iii_app_1 | Password grant client created successfully.
firefly_iii_app_1 | Client ID: 41
firefly_iii_app_1 | Client secret: X
firefly_iii_app_1 | Application cache cleared!
firefly_iii_app_1 | +------------------------------------------------------------------------------+
firefly_iii_app_1 | | |
firefly_iii_app_1 | | Thank you for installing Firefly III, v4.7.17! |
firefly_iii_app_1 | | |
firefly_iii_app_1 | | |
firefly_iii_app_1 | +------------------------------------------------------------------------------+
firefly_iii_app_1 | Go!
firefly_iii_app_1 | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.21.0.3. Set the 'ServerName' directive globally to suppress this message
firefly_iii_app_1 | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.21.0.3. Set the 'ServerName' directive globally to suppress this message
firefly_iii_app_1 | [Thu Jul 11 21:53:35.266137 2019] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.25 (Debian) PHP/7.2.16 OpenSSL/1.0.2r configured -- resuming normal operations
firefly_iii_app_1 | [Thu Jul 11 21:53:35.266166 2019] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
Wel wat database errors die ik ook had vlak na de update (ook een user exists error). Ik denk er juist aan dat de developer misschien liever heeft dat ik het op github plaats... das dan mss voor later