Django table already exists

Question

Here is my Django migration file. When i started

python manage.py makemigrations/migrate 

I get this error.

 Error:- django.db.utils.OperationalError: (1050, "Table 'tickets_duration' already exists") 

I dumped the database and started it, but still getting the same error.

 class Migration(migrations.Migration): dependencies = [ ] operations = [ migrations.CreateModel( name='Duration', fields=[ ('Id', models.UUIDField(primary_key=True, db_column=b'duration_id', default=uuid.uuid4, serialize=False, editable=False)), ('duration', models.CharField(max_length=200, db_column=b'duration')), ], ), migrations.CreateModel( name='ErrorCount', fields=[ ('Id', models.UUIDField(primary_key=True, db_column=b'error_id', default=uuid.uuid4, serialize=False, editable=False)), ('error', models.CharField(max_length=200, db_column=b'error')), ], ), migrations.CreateModel( name='OutageCaused', fields=[ ('Id', models.UUIDField(primary_key=True, db_column=b'error_id', default=uuid.uuid4, serialize=False, editable=False)), ('outage_caused', models.CharField(max_length=200, db_column=b'outage_caused')), ], ), migrations.CreateModel( name='Pg', fields=[ ('Id', models.UUIDField(primary_key=True, db_column=b'pg_id', default=uuid.uuid4, serialize=False, editable=False)), ('pg_cd', models.CharField(max_length=200, db_column=b'pg_cd')), ], ), migrations.CreateModel( name='SystemCaused', fields=[ ('Id', models.UUIDField(primary_key=True, db_column=b'error_id', default=uuid.uuid4, serialize=False, editable=False)), ('system_caused', models.CharField(max_length=200, db_column=b'system_caused')), ], ), migrations.CreateModel( name='Tickets', fields=[ ('ticket_num', models.CharField(max_length=100, serialize=False, primary_key=True, db_column=b'ticket_id')), ('created_dt', models.DateTimeField(db_column=b'created_dt')), ('ticket_type', models.CharField(max_length=20, db_column=b'ticket_type')), ('addt_notes', models.CharField(max_length=1000, db_column=b'addt_notes')), ('row_create_ts', models.DateTimeField(default=datetime.datetime(2016, 2, 29, 16, 58, 31, 584733))), ('row_end_ts', models.DateTimeField(default=b'9999-12-31 00:00:00.00000-00', db_column=b'row_end_ts')), ('duration', models.ManyToManyField(to='tickets.Duration')), ('error_count', models.ManyToManyField(to='tickets.ErrorCount')), ('outage_caused', models.ManyToManyField(to='tickets.OutageCaused')), 

Answer 1

try python manage.py migrate your_app --fake . This post talks about it. Django South - the table already exists .

Answer 2

Temporary solution

may be to comment on the creation of an existing table (ticket_duration).

 class Migration(migrations.Migration): dependencies = [ ] operations = [ #migrations.CreateModel( # name='Duration', # fields=[ # ('Id', models.UUIDField(primary_key=True, db_column=b'duration_id', default=uuid.uuid4, serialize=False, editable=False)), # ('duration', models.CharField(max_length=200, db_column=b'duration')), # ], #), .... .... 

Answer 3

This question has already been answered here.

You should run this:

python manage.py migrate <appname> --fake

Answer 4

python manage.py migrate --fake-initial should work for django 2.2