Upgrading from v6 to v7

[spindev]

Hi, I'm using docker compose to run lychee. I followed your instructions to upgrade from v6 to v7 but I have an error connecting to my sql-lite database

lychee  | 🚀 Starting Lychee entrypoint...
lychee  | 🔍 Validating environment variables...
lychee  | ✅ Valid database connection type: sqlite
lychee  | ✅ Valid environment: production
lychee  | ✅ Core variables validated
lychee  | 🎉 Environment validation complete!
lychee  | Validating and setting PUID/PGID
lychee  |   User UID: 33
lychee  |   User GID: 33
lychee  | 🔍 Validating permissions...
lychee  | ⏰ Set Permissions for Lychee folders...
lychee  | ✅ Permissions set securely
lychee  | ⏰ Set Permissions for Upload/dist folders (this may take a while)...
lychee  | ✅ Permissions set securely
lychee  | Checking RUN_AS_ROOT setting
lychee  | ✅ Will drop privileges to www-data user
lychee  | 🧹 Clearing bootstrap cache...
lychee  | 🌐 Starting Lychee in web mode...
lychee  | 🔄 Running database migrations...
lychee  |
lychee  |    INFO  Running migrations.
lychee  |
lychee  |   2025_12_15_161819_webshop_level_2 .............................. 0.80ms FAIL
lychee  |
lychee  | In Connection.php line 831:
lychee  |
lychee  |   SQLSTATE[HY000]: General error: 8 attempt to write a readonly database (Con
lychee  |   nection: sqlite, Database: /conf/lychee.db, SQL: update "configs" set "leve
lychee  |   l" = 2 where "key" LIKE webshop_%)
lychee  |
lychee  |
lychee  | In Connection.php line 602:
lychee  |
lychee  |   SQLSTATE[HY000]: General error: 8 attempt to write a readonly database
lychee  |
lychee  |
lychee exited with code 1 (restarting)

My compose file

services:
  lychee:
    image: lycheeorg/lychee:latest
    container_name: lychee
    ports:
      - "8081:8000"
    environment:
      - DB_CONNECTION=sqlite
      - DB_DATABASE=/conf/lychee.db
      - APP_ENV=production
      - APP_DEBUG=false
      - APP_URL=xxx
      - APP_KEY=xxx
      - APP_FORCE_HTTPS=true
      - PHP_TZ=Europe/Berlin
      - TIMEZONE=Europe/Berlin
      - TRUSTED_PROXIES=*
    volumes:
      - ./uploads:/app/public/uploads
      - ./logs:/app/storage/logs
      - ./tmp:/app/storage/tmp
      - ./storage/app:/app/storage/app
      - ./conf/lychee.db:/conf/lychee.db

The database is in the same place like before. I've tried to move it to /storage/app and change the paths but same error. I did not change anything about permissions to the actual database.

Can you guide me in the correct direction please?

Thanks!

Spindev

[ildyria]

I did not change anything about permissions to the actual database.

Your database need to be writable by the PUID/GUID that you assigned in your docker compose (in this case it should be 33:33)
Check what is the access rights in your ./conf with ls -lola

- ./storage/app:/app/storage/app It has been shown that this is not necessary (I need to update the doc).

[ildyria]

Okay another try...

Can you set this gist https://gist.github.com/ildyria/8184b382102fd337f9b71a4f0f3a0fec as 05-permissions-check.sh
and mount it to /usr/local/bin/05-permissions-check.sh

The change compared to the one in the container is the following:

# Check if using SQLite and set database owner
if [ "${DB_CONNECTION:-}" = "sqlite" ]; then
  if [ -n "${DB_DATABASE:-}" ] && [ -f "$DB_DATABASE" ]; then
    echo "📦 Setting SQLite database owner to www-data..."
    chown www-data:www-data "$DB_DATABASE"
  fi
fi

[spindev]

Saved the gist to the file and mounted it.

Attaching to lychee
lychee  | 🚀 Starting Lychee entrypoint...
lychee  | 🔍 Validating environment variables...
lychee  | ✅ Valid database connection type: sqlite
lychee  | ✅ Valid environment: production
lychee  | ✅ Core variables validated
lychee  | 🎉 Environment validation complete!
lychee  | Validating and setting PUID/PGID
lychee  | Updating www-data UID to 1000
lychee  | Updating www-data GID to 1000
lychee  |   User UID: 1000
lychee  |   User GID: 1000
lychee  | 🔍 Validating permissions...
lychee  | ⏰ Set Permissions for Lychee folders...
lychee  | ✅ Permissions set securely
lychee  | 📦 Setting SQLite database owner to www-data...       <------------------------
lychee  | ⏰ Set Permissions for Upload/dist folders (this may take a while)...
lychee  | ✅ Permissions set securely
lychee  | Checking RUN_AS_ROOT setting
lychee  | ✅ Will drop privileges to www-data user
lychee  | 🧹 Clearing bootstrap cache...
lychee  | 🌐 Starting Lychee in web mode...
lychee  | 🔄 Running database migrations...
lychee  |
lychee  |    INFO  Running migrations.
lychee  |
lychee  |   2025_12_15_161819_webshop_level_2 .............................. 1.03ms FAIL
lychee  |
lychee  | In Connection.php line 831:
lychee  |
lychee  |   SQLSTATE[HY000]: General error: 8 attempt to write a readonly database (Con
lychee  |   nection: sqlite, Database: /conf/lychee.db, SQL: update "configs" set "leve
lychee  |   l" = 2 where "key" LIKE webshop_%)
lychee  |
lychee  |
lychee  | In Connection.php line 602:
lychee  |
lychee  |   SQLSTATE[HY000]: General error: 8 attempt to write a readonly database
lychee  |
lychee  |
lychee exited with code 1 (restarting)

echo is visible but error remains :(. I'm really the only one facing this issue 🙈

[ildyria]

echo is visible but error remains :(. I'm really the only one facing this issue 🙈

One of the very few who decided to go with sqlite 😅

[ildyria]

okay let's try the worst case ...
can you set RUN_AS_ROOT=yes in your env ?

[spindev]

That worked actually! I run the additional commands to fix the thumbs. Looks good.

Tried to remove the RUN_AS_ROOT but results again in log writing errors :(

And yes, guilty for using sqlite 😄