Unable to access Tokens Table or delete users with associated Token

[LastAeon77]

When I am trying to access Tokens in Admin or when I am trying to delete user, I am hit with this error

I can't delete users no matter what I try, even directly through shell.

I am also unable to specifically access auth_token value through shell

When I try to access the Token table through Admin, this error pops up

When I try to delete users through Admin, This error pops up

I think it is some logic error in the rest auth token but I am not sure. If anyone could help please do tell!

PS. I do not know if this helps, but as a side note I am using AbstractUser to make my own Users. I am also using simpltjwt for authentications. (I was following this guide to do authentication with another site https://hackernoon.com/110percent-complete-jwt-authentication-with-django-and-react-2020-iejq34ta)

[hashlash]

Does your custom User model use a CharField as its primary key? Could you please provide your custom User implementation?

I think it's somewhat similar to: https://stackoverflow.com/questions/31404781/django-and-postgresql-operator-does-not-exist-integer-character-varying.

[LastAeon77]

Does your custom User model use a CharField as its primary key? Could you please provide your custom User implementation?

I think it's somewhat similar to: https://stackoverflow.com/questions/31404781/django-and-postgresql-operator-does-not-exist-integer-character-varying.

No, all I did with it is add a user favorite color. I have not modified it in any other way. In addition, the error (I presume) comes from the fact that auth_token is a varying char, which is something created from the rest_framework.

[hashlash]

authtoken.user is created with OneToOneField which should use the appropriate column type.

Have you try to recreate the database? Or maybe just re run the authtoken and your user module migrations. And make sure there's no new migration changes.

$ python manage.py migrate authtoken zero
$ python manage.py migrate <user module> zero
$ python manage.py makemigrations
$ python manage.py migrate

[LastAeon77]

authtoken.user is created with OneToOneField which should use the appropriate column type.

Have you try to recreate the database? Or maybe just re run the authtoken and your user module migrations. And make sure there's no new migration changes.

$ python manage.py migrate authtoken zero
$ python manage.py migrate <user module> zero
$ python manage.py makemigrations
$ python manage.py migrate

I tried this and it still doesn't work. However, you did give me an idea. What I did was I downloaded the database locally, manually deleted the column authtoken_token.user.id, then recreate it into an integer. Afterward, I restored it onto the Heroku database, and everything is fine now. Thank you very much for your patient guidance :D

[hashlash]

Nice! Glad to hear that your problem's solved.

You can mark this thread as an answer, so this discussion will be marked as Answered and other contributors can focus on other Unanswered discussions :D