asbiin / laravel-webauthn

Webauthn adapter for Laravel
MIT License
275 stars 38 forks source link

Fresh install - error on php artisan migrate - 1170 BLOB/TEXT column 'credentialId' used in key specification without a key length #426

Closed emilas44 closed 1 year ago

emilas44 commented 1 year ago

OS: Linux Ubuntu 22.04 Laravel version: 10.1.5 MySQL version: 8.0

laravel@1f8e2eb5a18b:/var/www/html$ php artisan migrate 
Xdebug: [Step Debug] Could not connect to debugging client. Tried: localhost:9003 (fallback through xdebug.client_host/xdebug.client_port).

   INFO  Preparing database.  

  Creating migration table ............................................................................................................... 47ms DONE

   INFO  Running migrations.  

  2014_10_12_000000_create_users_table ................................................................................................... 84ms DONE
  2014_10_12_100000_create_password_reset_tokens_table .................................................................................. 123ms DONE
  2019_03_29_163611_add_webauthn ........................................................................................................ 164ms FAIL

   Illuminate\Database\QueryException 

  SQLSTATE[42000]: Syntax error or access violation: 1170 BLOB/TEXT column 'credentialId' used in key specification without a key length (Connection: mysql, SQL: alter table `webauthn_keys` add index `webauthn_keys_credentialid_index`(`credentialId`))

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
    756▕         // If an exception occurs when attempting to run a query, we'll format the error
    757▕         // message to include the bindings with SQL, which will make this exception a
    758▕         // lot more helpful to the developer instead of just the database's errors.
    759▕         catch (Exception $e) {
  ➜ 760▕             throw new QueryException(
    761▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    762▕             );
    763▕         }
    764▕     }

      +9 vendor frames 

  10  database/migrations/2019_03_29_163611_add_webauthn.php:16
      Illuminate\Support\Facades\Facade::__callStatic()
      +25 vendor frames 

  36  artisan:35
      Illuminate\Foundation\Console\Kernel::handle()
asbiin commented 1 year ago

fixed by #431