#Database URL Error

3 messages · Page 1 of 1 (latest)

plucky widget
#

To keep things simple I've created a new Payload website with create-payload-app and chose Sqlite for a db. I accepted the default connection string/url, of file:./panda-payload-sqlite.db. Now when I start the app up I get this error:

ERROR: Error: cannot connect to SQLite: URL_INVALID: The URL 'host=127.0.0.1 port=5432 dbname=postgres user=postgres connect_timeout=10 sslmode=prefer' is not in a valid format

My .env file only has this:

# Database connection string
DATABASE_URL=file:./panda-payload-sqlite.db
# Or use a PG connection string
#DATABASE_URL=postgresql://127.0.0.1:5432/your-database-name

File payload.config.ts contains this

  db: sqliteAdapter({
    client: {
      url: process.env.DATABASE_URL || '',
    },
  }),

Why is whatever it is trying to use a phantom Postgres connection string?

tidal cragBOT
plucky widget
#

I had to do a cleanup and close all terminals and run $env:DATABASE_URL = $null in PowerShell, but thinsg are looking good now.