Migration error

gistfile1.txt

spiti-main-php-1       | Still waiting for db to be ready... Or maybe the db is not reachable. 17 attempts left
spiti-main-php-1       | Still waiting for db to be ready... Or maybe the db is not reachable. 16 attempts left
spiti-main-php-1       | Still waiting for db to be ready... Or maybe the db is not reachable. 15 attempts left

---> Here I ran `chmod +x bin/console` which did fix the DB (see below) but migration failed 

spiti-main-php-1       | The db is now ready and reachable
spiti-main-php-1       | [notice] Migrating up to DoctrineMigrations\Version20240317205927
spiti-main-database-1  | 2024-07-30 17:14:06.089 UTC [35] ERROR:  syntax error at or near "AUTO_INCREMENT" at character 45
spiti-main-database-1  | 2024-07-30 17:14:06.089 UTC [35] STATEMENT:  CREATE TABLE reset_password_request (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, selector VARCHAR(20) NOT NULL, hashed_token VARCHAR(100) NOT NULL, requested_at DATETIME NOT NULL COMMENT '(DC2Type:datetime_immutable)', expires_at DATETIME NOT NULL COMMENT '(DC2Type:datetime_immutable)', INDEX IDX_7CE748AA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB
spiti-main-php-1       | [error] Migration DoctrineMigrations\Version20221031121935 failed during Execution. Error: "An exception occurred while executing a query: SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "AUTO_INCREMENT"
spiti-main-php-1       | LINE 1: CREATE TABLE reset_password_request (id INT AUTO_INCREMENT N...
spiti-main-php-1       |                                                     ^"
spiti-main-php-1       |
spiti-main-php-1       | In ExceptionConverter.php line 62:
spiti-main-php-1       |
spiti-main-php-1       |   An exception occurred while executing a query: SQLSTATE[42601]: Syntax erro
spiti-main-php-1       |   r: 7 ERROR:  syntax error at or near "AUTO_INCREMENT"
spiti-main-php-1       |   LINE 1: CREATE TABLE reset_password_request (id INT AUTO_INCREMENT N...
spiti-main-php-1       |                                                       ^
spiti-main-php-1       |
spiti-main-php-1       |
spiti-main-php-1       | In Exception.php line 28:
spiti-main-php-1       |
spiti-main-php-1       |   SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "AUTO_INCR
spiti-main-php-1       |   EMENT"
spiti-main-php-1       |   LINE 1: CREATE TABLE reset_password_request (id INT AUTO_INCREMENT N...
spiti-main-php-1       |                                                       ^
spiti-main-php-1       |
spiti-main-php-1       |
spiti-main-php-1       | In Connection.php line 71:
spiti-main-php-1       |
spiti-main-php-1       |   SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "AUTO_INCR
spiti-main-php-1       |   EMENT"
spiti-main-php-1       |   LINE 1: CREATE TABLE reset_password_request (id INT AUTO_INCREMENT N...
spiti-main-php-1       |                                                       ^
spiti-main-php-1       |
spiti-main-php-1       |
spiti-main-php-1       | doctrine:migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--all-or-nothing [ALL-OR-NOTHING]] [--configuration CONFIGURATION] [--em EM] [--conn CONN] [--] [<version>]
spiti-main-php-1       |
spiti-main-php-1 exited with code 7
spiti-main-php-1       | Installing dependencies from lock file (including require-dev)
spiti-main-php-1       | Verifying lock file contents can be installed on current platform.
spiti-main-php-1       | Nothing to install, update or remove
spiti-main-php-1       | Package sensio/framework-extra-bundle is abandoned, you should avoid using it. Use Symfony instead.
spiti-main-php-1       | Generating optimized autoload files
spiti-main-caddy-1     | {"level":"error","ts":1722359651.588321,"logger":"http.log.error","msg":"dialing backend: dial unix /var/run/php/php-fpm.sock: connect: no such file or directory","request":{"remote_ip":"172.20.0.1","remote_port":"63546","client_ip":"172.20.0.1","proto":"HTTP/2.0","method":"GET","host":"localhost","uri":"/","headers":{"Upgrade-Insecure-Requests":["1"],"Accept":["text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"],"Sec-Fetch-Mode":["navigate"],"Sec-Fetch-User":["?1"],"Sec-Fetch-Dest":["document"],"Cookie":["REDACTED"],"Sec-Ch-Ua-Platform":["\"macOS\""],"Sec-Ch-Ua-Mobile":["?0"],"User-Agent":["Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36"],"Sec-Fetch-Site":["none"],"Accept-Encoding":["gzip, deflate, br, zstd"],"Accept-Language":["en-US,en-GB;q=0.9,en;q=0.8"],"Sec-Ch-Ua":["\"Not)A;Brand\";v=\"99\", \"Google Chrome\";v=\"127\", \"Chromium\";v=\"127\""],"Priority":["u=0, i"]},"tls":{"resumed":false,"version":772,"cipher_suite":4865,"proto":"h2","server_name":"localhost"}},"duration":0.00565325,"status":502,"err_id":"ee2e3tm8s","err_trace":"reverseproxy.statusError (reverseproxy.go:1269)"}