Django Table already exist

Question

Here is my Django Migration file. When I run

python manage.py makemigrations/migrate

I get this error.

Error:-

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

I have dropped the database and running it but still get 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')),

Just to make sure: You get this error even if you run `manage.py migrate` on an *empty* database? — Risadinha, Feb 29 '16 at 18:16

score 13 · Answer 1 · edited May 23 '17 at 12:25

13

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

edited May 23 '17 at 12:25

Community

1
1

answered Feb 29 '16 at 17:23

bhzag

2,814
7
21
38

score 5 · Answer 2 · answered Apr 26 '19 at 09:19

5

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

answered Apr 26 '19 at 09:19

LoneCuriousWolf

540
1
4
12

pyjavo · Answer 3 · 2019-03-16T17:55:24.197

4

This question is already answered here

You should run this:

python manage.py migrate <appname> --fake

edited Mar 16 '19 at 17:55

answered Apr 15 '17 at 14:54

pyjavo

1,471
2
23
36

score 2 · Answer 4 · answered Apr 05 '17 at 07:07

temporary solution may be to comment the creation of existing table(tickets_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')),
        #    ],
        #),
        ....
        ....

and where is this class file called MIgration? – Gajendra D Ambi Aug 21 '19 at 19:42 — Gajendra D Ambi, Aug 21 '19 at 19:42

score 1 · Answer 5 · answered Oct 20 '21 at 13:32

version:-Django 3.X

If above solution doesn't work :

python manage.py migrate <appname> --fake

If it doesn't work then have a look at the migrations folder you will find that there will be some missing changes which u have done in models.py but somehow Django is unable to capture, so find it there and again do some changes (even a small) to that model fields and then use ,

py manage.py makemigrations app_name
py manage.py migrate app_name
or
py manage.py makemigration <appname> --fake

score 0 · Answer 6 · answered Mar 31 '22 at 19:59

It is an inconsistent situation of Database.

You may do the followings:

Comment out the code for your last added model.
Run makemigrations and then migrate --fake, to get the record sync at present situation.
Now, uncomment your last added model, and run makemigrations again;

Django Table already exist

6 Answers6

Linked