Lychee: Unable to upgrade!

Detailed description of the problem [REQUIRED]

I have downloaded and unpacked the new zip, checked permissions, .env file and so on.

After logging in to the GUI to complete the installation i get: Updating user failed

ModelDBException in /home/web/gardiol.org/subdomains/photos/Lychee/app/Exceptions/ModelDBException.php (line 50)

     *
     * @return ModelDBException
     */
    public static function create(string $modelName, string $operationName, \Throwable $previous = null): ModelDBException
    {
        return new ModelDBException(Str::ucfirst($operationName) . ' ' . $modelName . ' failed', $previous);
    }
}

QueryException

SQLSTATE[HY000]: General error: 1364 Field ‘id’ doesn’t have a default value (SQL: insert into users (username, password, updated_at, created_at) values ($2y$10$LAdeiZwZq8vDrMXsPAF3JeidUqQXHl5Ry5v.qIYyKGBZbih7agLAy, $2y$10$ruv1WvHL/2cTp8xDb7vYh.huY7LpNpFnSpWydu1tRo2AVgZyDajD6, 2022-08-31 07:44:30.529740, 2022-08-31 07:44:30.529740))

To try to fix i deleted the users in the “users” table, but the error is still here. I see that new users get added to the users table.

Steps to reproduce the issue

Steps to reproduce the behavior: Login

Screenshots

Output of the diagnostics [REQUIRED]

Can’t access at this time due to error

Browser and system

Linux, firefox. server is installed on Linux + MySql.