You are trying to add a non-nullable field 'first_res' to result without a default; we can't do that
在模型中新增加字段导致报错信息
报错信息:
You are trying to add a non-nullable field 'first_res' to result without a default; we can't do that (the database needs something to populate existing rows).
Please select a fix:
1) Provide a one-off default now (will be set on all existing rows with a null value for this column)
2) Quit, and let me add a default in models.py
Select an option: 1)
解决方法:
这个问题是在模型中新添加的,在原来已经有的表单中没有值。所以在新添加的值得括号中添加null=True
如
1 first_result = models.CharField(max_length = 200, null=True)
然后
python manage.py makemigrations
python manage.py migrate
注意:
如果该表中已经存在数据,不要执行python manage.py migrate这行代码,如果执行的话,之前表中的所有数据可能会清空;
如果该表中已经存在数据,可以只执行代码python manage.py makemigrationgs,建立数据库模型,然后在数据库中单独在这张表中增加一列数据。