jsonb data type not supported

[gdg87]

Hi,
I try to use the package with mysql database but I have this error

DataTypeNotSupportedError: Data type "jsonb" in "AccessTokenEntity.createdFrom" is not supported by "mysql" database.

Is possible switch the field type to json in order to support more database.

Thanks

[ptesser]

Hi,
it's the same for me.
I'm using a MySQL 5.7 database and I think the problem appears because in MYSQL jsonb is not support.

Is there a workaround for this?

Is it possible to change the default entities with custom ones?

Thanks

[gdg87]

Hi @ptesser,
since no news comes from switchit I decide fork it and publish a new package. You can find it here:

https://www.npmjs.com/package/@switchit/nestjs-oauth2-server

If you want to contribute you are welcome.

[nmacherey]

Sorry I was blocked on a bug project for last couple ok weeks. I will look at your fork and integrate it. Could you propose a Pull request ? Thanks a lot Envoyé de mon iPhone

…

Le 10 juin 2020 à 17:56, gdg87 ***@***.***> a écrit :  Hi @ptesser, since no news comes from switchit I decide fork it and publish a new package. You can find it here: ***@***.***/nestjs-oauth2-server If you want to contribute you are welcome. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or unsubscribe.

[ptesser]

Hi @gdg87,
thanks for the fork. I'll watch it, but probably I'll wait that @nmacherey take care of your integration.

Thanks a lot

[CayBap]

I change to json type and I try to run it in mysql
set global sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
it worked