[Python] django.db.utils.OperationalError: no such column: dashboard_player.player_run...

class Player(models.Model):
role_choices = [
('Batsman', 'Batsman'),
('Bowler', 'Bowler'),
('AllRounder', 'AllRounder'),
('WicketKeeper', 'WicketKeeper'),
]
player_name = models.CharField(max_length=30, blank=False)
player_team = models.ForeignKey(Team, on_delete=models.CASCADE, blank=False)
match_number = models.ForeignKey(Match, on_delete=models.CASCADE, blank=False)
player_role = models.CharField(choices=role_choices, max_length=15, blank=False)
player_available = models.BooleanField(default=True)
player_number = models.IntegerField(null=True, editable=False)
player_run = models.IntegerField(blank=True, null=True, default=0)
player_wickets = models.IntegerField(blank=True, null=True, default=0)
player_catch = models.IntegerField(blank=True, null=False, default=0)

def __str__(self):
return f"{self.player_name} ({self.player_role})"


after adding player_run, player_wickets, player_catch I ran the migration commands which asked for a default value to which i mistakenly added datetime to it. But now whenever i try to save any player it says

raise e.__class__(
TypeError: Field 'player_catch' expected a number but got datetime.datetime(2025, 2, 6, 10, 53, 15, 330920, tzinfo=datetime.timezone.utc).


and the api response is

'table dashboard_player has no column named player_run'


Can anyone tell what can be the problem in this code?

Continue reading...