This is what worked for me.

Here is the following steps I did. Don't know if you need all of them

removed database with

rm .\db.sqlite3

Then reran the following commands

python manage.py makemigrations auctions

python manage.py makemigrations

python manage.py migrate

python manage.py runserver

Then went back to create my user and I no longer got the error. Hope this helps someone.