datatype mismatch when i try to add to a table

Have you previously modified or constructed any migrations? Or are all migrations system-generated?

You have at least two possible approaches at this point that I can see.

You can:

  • Figure out what’s going wrong in 0004_profile_location_skill_created_alter_skill_id

  • Delete all un-applied migrations (0004 through 0016) and run a makemigrations from the current state of your models.

The second option is only easy if you don’t have any user-edited migrations. If you do have any, then those modifications would need to be reimplemented in the newly-created migration.