Upgrading from 6 to 7 problems.

[skyway22]

Trying to move from 6 to 7, but ran into some issues

🔍 Validating environment variables...
✅ Valid database connection type: mysql
✅ Core variables validated
🎉 Environment validation complete!
⏳ Waiting for database to be ready...
✅ Database port is open!
Validating and setting PUID/PGID
  User UID: 33
  User GID: 33
🔍 Validating permissions...
⏰ Set Permissions for Lychee folders...
⏰ Set Permissions for dist folder...
⏰ Set Permissions for Upload folder (this may take a while)...
✅ Permissions set securely
Checking RUN_AS_ROOT setting
✅ Will drop privileges to www-data user
🧹 Clearing bootstrap cache...
🌐 Starting Lychee in web mode...
🔄 Running database migrations...
   INFO  Nothing to migrate.  
🧹 Optimizing application...
   INFO  Configuration cache cleared successfully.  
   INFO  Configuration cached successfully.  
   INFO  Route cache cleared successfully.  
   INFO  Routes cached successfully.  
   INFO  Compiled views cleared successfully.  
   INFO  Blade templates cached successfully.  
✅ Application ready!
   INFO  Server running….  
  Local: http://0.0.0.0:8000 
  Press Ctrl+C to stop the server
   WARN  HTTP/2 skipped because it requires TLS.  
   WARN  HTTP/3 skipped because it requires TLS.  
   INFO  Error: loading initial config: loading new config: frankenphp app module: start: failed to initialize workers: too many consecutive failures: worker public/frankenphp-worker.php has not reached frankenphp_handle_request().```

Docker-compose file:

services:
  lychee_db:
    container_name: lychee_db
    image: mariadb:10
    environment:
      - MYSQL_ROOT_PASSWORD=lychee-setup
      - MYSQL_DATABASE=lychee
      - MYSQL_USER=lychee
      - MYSQL_PASSWORD=xxxxxxxxx
    expose: 
      - 3306
    volumes:
      - ./mysql:/var/lib/mysql
    networks:
      - lychee
    restart: unless-stopped

  lychee_api:
    image: ghcr.io/lycheeorg/lychee:edge
    container_name: lychee
    env_file:
      - stack.env
    ports:
      - "${APP_PORT:-8000}:8000"
    volumes:
      - ./data/lychee/uploads:/app/public/uploads
      - ./data/lychee/logs:/app/storage/logs
      - ./data/lychee/tmp:/app/storage/tmp
    environment:
      - DB_CONNECTION=mysql
      - DB_HOST=lychee_db
      - DB_PORT=3306
      - DB_DATABASE=lychee
      - DB_USERNAME=lychee
      # ... other environment variables
    depends_on:
      - lychee_db
    networks:
      - lychee

networks:
  lychee:

volumes:
  mysql:

[ildyria]

Okay, that is weird. I will have a look later, time to sleep, in the meantime, can you try ghcr.io/lycheeorg/lychee:edge-legacy ?
It is literally the same as edge but under the hood it is running nginx instead of frankenphp.

The paths and everything else are the same so you can switch between edge and edge-legacy without problem.

[skyway22]

🔍 Validating environment variables...
✅ Valid database connection type: mysql
✅ Core variables validated
🎉 Environment validation complete!
⏳ Waiting for database to be ready...
✅ Database port is open!
Validating and setting PUID/PGID
  User UID: 1000
  User GID: 1000
🔍 Validating permissions...
⏰ Set Permissions for Lychee folders...
⏰ Set Permissions for dist folder...
⏰ Set Permissions for Upload folder (this may take a while)...
✅ Permissions set securely
Checking RUN_AS_ROOT setting
✅ Will drop privileges to www-data user
🧹 Clearing bootstrap cache...
🌐 Starting Lychee in web mode...
🔄 Running database migrations...
   INFO  Running migrations.  
  2026_10_03_000005_add_360_columns_to_photos .................... 2.04ms FAIL
In Connection.php line 857:
                                                                               
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lychee.photos' d  
  oesn't exist (Connection: mysql, Host: lychee_db, Port: 3306, Database: lyc  
  hee, SQL: alter table `photos` add `is_360` tinyint(1) null after `img_dire  
  ction`)                                                                      
                                                                               
In Connection.php line 601:
                                                                               
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lychee.photos' d  
  oesn't exist                                                                 

Result after changing from lychee:edge to lychee:edge-legacy

[ildyria]

Well that is good news~ish. It means that something is weirdly wrong with the .env

[skyway22]

Content of .env file

PHP_TZ=Europe/Barcelona
TIMEZONE=Europe/Barcelona
APP_FORCE_HTTPS=false
APP_URL=xxxxxxxxxxxxxx
TRUSTED_PROXIES=*
DB_CONNECTION=mysql
DB_HOST=lychee_db
DB_PORT=3306
DB_DATABASE=lychee
DB_USERNAME=lychee
DB_PASSWORD=xxxxxxxxxxxxx
#MAIL_DRIVER=smtp
#MAIL_HOST=smtp.server.domain.tld
#MAIL_PORT=25
STARTUP_DELAY=5
APP_KEY=xxxxxxxxxxxxxxxxxxxxxxxxxx

[ildyria]

This makes 0 senses why it does not work.

[skyway22]

maybe it's broken by fault of migration?

[ildyria]

The problem is that it says that the photos table does not exists, however it is only crashing on the last migration which means that is has access to all the other migrations run etc... So that's why it makes zero sense.

Can you check in your database that the table photos is actually there? there is absolutely no reason why it should not be there if the migrations table is also present.