Column publicKeyCredentialId used in key specification without a key length

[leofeyer]

Unfortunately, the changes from #678 don't work for me under MySQL 9.1:

The ORM file contains <field name="publicKeyCredentialId" type="base64" unique="true" length="250"/>. I'm using version 5.1.1 with Symfony 7.2.

[Spomky]

Hello @leofeyer,

Indeed, there is an issue with this field.
The length is defined, but because base64 is of type CLOB the directive is ignored.
Please downgrade to 5.0.x until a fix is released.

---

Note1: https://stackoverflow.com/questions/1827063/mysql-error-key-specification-without-a-key-length

[leofeyer]

Will do. Thank you @Spomky.

[Spomky]

Hi,

I am sorry, but it looks like there is no convenient way to fix this issue. I will revert to the previous behavior i.e. without the index.
Right now, I am wondering if the Doctrine Repository should still be maintained here. IMHO, the current design requires duplicqtions on the application side and the benefits are low