Thanks for pointing me to the source code. I have taken a look and the problem seems to be with the `returning('id')`, as you correctly pointed out. Is there any configuration I need to apply to MySQL in my codebase to enable the returning clause? I don't think it is fully supported in MySQL.

EDIT: Switched to postgres and it now works fine. It's A bug in AdonisJS at line 176 when using MySQL.

Hi. Thank you for the detailed explanation.

I have been having trouble returning a value for the token after login. I keep getting the error message "Cannot save access token. The result '[0]' of insert query is unexpected" even though the token gets saved to the database. I'm not sure what I could be doing wrong.

You can check out the login method here:

https://github.com/ansman58/properties-backend/blob/main/app/controllers/auth.ts