Tajinder Singh Tajinder Singh - 3 years ago 202
Python Question

Error in migrate after adding DateField in Django Model

This is my Django model, in which I want to add another field, in addition to pre-existent fields

class Offerta(models.Model):
#old pre-existent fields
...
#the field I want to add
data_rifiuto = models.DateField(null=True, blank=True)


When I run
'makemigrations myapp'
there are no problems, but when I run the
'migrate'
command, console shows some
errors
:

Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "/usr/lib/python3/dist-packages/django/db/backends/sqlite3/base.py", line 337, in execute
return Database.Cursor.execute(self, query, params)
sqlite3.IntegrityError: NOT NULL constraint failed: myapp_offerta.data_rifiuto

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/opt/pycharm-2017.2.3/helpers/pycharm/django_manage.py", line 43, in <module>
run_module(manage_file, None, '__main__', True)
File "/usr/lib/python3.5/runpy.py", line 205, in run_module
return _run_module_code(code, init_globals, run_name, mod_spec)
File "/usr/lib/python3.5/runpy.py", line 96, in _run_module_code
mod_name, mod_spec, pkg_name, script_name)
File "/usr/lib/python3.5/runpy.py", line 85, in _run_code
exec(code, run_globals)
File "/home/santoryu/richiestaTesi/manage.py", line 22, in <module>
execute_from_command_line(sys.argv)


I think the main problem is here:

sqlite3.IntegrityError: NOT NULL constraint failed: myapp_offerta.data_rifiuto


But I have explicitly say
null=True
.

EDIT
class Migration(migrations.Migration):

dependencies = [
('myapp', '0037_remove_offerta_data_rifiuto'),
]

operations = [
migrations.AddField(
model_name='offerta',
name='data_rifiuto',
field=models.DateField(blank=True, null=True),
),
]

Answer Source

I've solved by deleting some migration files. Now it's working. I've tried to re-run makemigration and migrate and I've didn't get any trouble. I think dependencies from precedent file were the problem

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download