Getting a sqlite error, might be due to .env?

[cjosh-vt]

I use the docker compose method to launch reiverr, I updated from version .4 to .6 this morning which meant taking out the url and keys from the docker compose file and putting them in a .env file (as far as I can tell I cant find any documentation that says this) I'm not building the docker file rather just using ghcr.io/aleksilassila/reiverr:latest as it was the easiest way to get started.
I have a few questions

1. Where does the .env file go, in the root directory (where the docker-compose.yml file is) or in the volume (./config) I have tried both and neither seem to fix the issue which leads to question 2
2. Is this because I missed version .5? In order to get it up and running I ran docker compose down followed by docker system prune -a . Without the prune command it doesn't seem to pull a new image and still launches the old container/image for reiverr.
3. Is there possibly an additional setup step that I am missing? Version .4 worked as expected and version .6 seems to only load a black page and throws the error in the container.

I get the following error (only after I visit the page in a browser)

Data Source has been initialized!
Listening on 0.0.0.0:9494
query: SELECT "Settings"."name" AS "Settings_name", "Settings"."isSetupDone" AS "Settings_isSetupDone", "Settings"."autoplayTrailers" AS "Settings_autoplayTrailers", "Settings"."language" AS "Settings_language", "Settings"."animationDuration" AS "Settings_animationDuration", "Settings"."discoverRegion" AS "Settings_discoverRegion", "Settings"."discoverExcludeLibraryItems" AS "Settings_discoverExcludeLibraryItems", "Settings"."discoverIncludedLanguages" AS "Settings_discoverIncludedLanguages", "Settings"."sonarrBaseUrl" AS "Settings_sonarrBaseUrl", "Settings"."sonarrApiKey" AS "Settings_sonarrApiKey", "Settings"."sonarrRootFolderPath" AS "Settings_sonarrRootFolderPath", "Settings"."sonarrQualityProfileId" AS "Settings_sonarrQualityProfileId", "Settings"."sonarrLanguageProfileId" AS "Settings_sonarrLanguageProfileId", "Settings"."radarrBaseUrl" AS "Settings_radarrBaseUrl", "Settings"."radarrApiKey" AS "Settings_radarrApiKey", "Settings"."radarrRootFolderPath" AS "Settings_radarrRootFolderPath", "Settings"."radarrQualityProfileId" AS "Settings_radarrQualityProfileId", "Settings"."jellyfinBaseUrl" AS "Settings_jellyfinBaseUrl", "Settings"."jellyfinApiKey" AS "Settings_jellyfinApiKey", "Settings"."jellyfinUserId" AS "Settings_jellyfinUserId" FROM "settings" "Settings" WHERE ("Settings"."name" = ?) LIMIT 1 -- PARAMETERS: ["default"]
query failed: SELECT "Settings"."name" AS "Settings_name", "Settings"."isSetupDone" AS "Settings_isSetupDone", "Settings"."autoplayTrailers" AS "Settings_autoplayTrailers", "Settings"."language" AS "Settings_language", "Settings"."animationDuration" AS "Settings_animationDuration", "Settings"."discoverRegion" AS "Settings_discoverRegion", "Settings"."discoverExcludeLibraryItems" AS "Settings_discoverExcludeLibraryItems", "Settings"."discoverIncludedLanguages" AS "Settings_discoverIncludedLanguages", "Settings"."sonarrBaseUrl" AS "Settings_sonarrBaseUrl", "Settings"."sonarrApiKey" AS "Settings_sonarrApiKey", "Settings"."sonarrRootFolderPath" AS "Settings_sonarrRootFolderPath", "Settings"."sonarrQualityProfileId" AS "Settings_sonarrQualityProfileId", "Settings"."sonarrLanguageProfileId" AS "Settings_sonarrLanguageProfileId", "Settings"."radarrBaseUrl" AS "Settings_radarrBaseUrl", "Settings"."radarrApiKey" AS "Settings_radarrApiKey", "Settings"."radarrRootFolderPath" AS "Settings_radarrRootFolderPath", "Settings"."radarrQualityProfileId" AS "Settings_radarrQualityProfileId", "Settings"."jellyfinBaseUrl" AS "Settings_jellyfinBaseUrl", "Settings"."jellyfinApiKey" AS "Settings_jellyfinApiKey", "Settings"."jellyfinUserId" AS "Settings_jellyfinUserId" FROM "settings" "Settings" WHERE ("Settings"."name" = ?) LIMIT 1 -- PARAMETERS: ["default"]
error: Error: SQLITE_ERROR: no such table: settings
QueryFailedError: SQLITE_ERROR: no such table: settings
    at handler (/usr/src/app/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:81:26)
    at replacement (/usr/src/app/node_modules/sqlite3/lib/trace.js:25:27)
    at Statement.errBack (/usr/src/app/node_modules/sqlite3/lib/sqlite3.js:15:21) {
  query: 'SELECT "Settings"."name" AS "Settings_name", "Settings"."isSetupDone" AS "Settings_isSetupDone", "Settings"."autoplayTrailers" AS "Settings_autoplayTrailers", "Settings"."language" AS "Settings_language", "Settings"."animationDuration" AS "Settings_animationDuration", "Settings"."discoverRegion" AS "Settings_discoverRegion", "Settings"."discoverExcludeLibraryItems" AS "Settings_discoverExcludeLibraryItems", "Settings"."discoverIncludedLanguages" AS "Settings_discoverIncludedLanguages", "Settings"."sonarrBaseUrl" AS "Settings_sonarrBaseUrl", "Settings"."sonarrApiKey" AS "Settings_sonarrApiKey", "Settings"."sonarrRootFolderPath" AS "Settings_sonarrRootFolderPath", "Settings"."sonarrQualityProfileId" AS "Settings_sonarrQualityProfileId", "Settings"."sonarrLanguageProfileId" AS "Settings_sonarrLanguageProfileId", "Settings"."radarrBaseUrl" AS "Settings_radarrBaseUrl", "Settings"."radarrApiKey" AS "Settings_radarrApiKey", "Settings"."radarrRootFolderPath" AS "Settings_radarrRootFolderPath", "Settings"."radarrQualityProfileId" AS "Settings_radarrQualityProfileId", "Settings"."jellyfinBaseUrl" AS "Settings_jellyfinBaseUrl", "Settings"."jellyfinApiKey" AS "Settings_jellyfinApiKey", "Settings"."jellyfinUserId" AS "Settings_jellyfinUserId" FROM "settings" "Settings" WHERE ("Settings"."name" = ?) LIMIT 1',
  parameters: [ 'default' ],
  driverError: Error: SQLITE_ERROR: no such table: settings
  --> in Database#all('SELECT "Settings"."name" AS "Settings_name", "Settings"."isSetupDone" AS "Settings_isSetupDone", "Settings"."autoplayTrailers" AS "Settings_autoplayTrailers", "Settings"."language" AS "Settings_language", "Settings"."animationDuration" AS "Settings_animationDuration", "Settings"."discoverRegion" AS "Settings_discoverRegion", "Settings"."discoverExcludeLibraryItems" AS "Settings_discoverExcludeLibraryItems", "Settings"."discoverIncludedLanguages" AS "Settings_discoverIncludedLanguages", "Settings"."sonarrBaseUrl" AS "Settings_sonarrBaseUrl", "Settings"."sonarrApiKey" AS "Settings_sonarrApiKey", "Settings"."sonarrRootFolderPath" AS "Settings_sonarrRootFolderPath", "Settings"."sonarrQualityProfileId" AS "Settings_sonarrQualityProfileId", "Settings"."sonarrLanguageProfileId" AS "Settings_sonarrLanguageProfileId", "Settings"."radarrBaseUrl" AS "Settings_radarrBaseUrl", "Settings"."radarrApiKey" AS "Settings_radarrApiKey", "Settings"."radarrRootFolderPath" AS "Settings_radarrRootFolderPath", "Settings"."radarrQualityProfileId" AS "Settings_radarrQualityProfileId", "Settings"."jellyfinBaseUrl" AS "Settings_jellyfinBaseUrl", "Settings"."jellyfinApiKey" AS "Settings_jellyfinApiKey", "Settings"."jellyfinUserId" AS "Settings_jellyfinUserId" FROM "settings" "Settings" WHERE ("Settings"."name" = ?) LIMIT 1', [ 'default' ], [Function: handler])
      at execute (/usr/src/app/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:62:46)
      at /usr/src/app/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:103:19 {
    errno: 1,
    code: 'SQLITE_ERROR',
    __augmented: true
  },
  errno: 1,
  code: 'SQLITE_ERROR',
  __augmented: true
}

[cjosh-vt]

Apparently I wasn't the only the one with this issue, version .6.1 has a fix for this. I should have read through the releases before posting, though I'm not sure why it wasn't pulling .6.1 as I use the 'latest' tag but oh well.