当对django 项目数据库修改时候 migrate出问题 django.db.utils.InternalError: (1091, "Can't DROP 'dt_id'; check that column/key exists")

django.db.utils.InternalError: (1091, "Can't DROP 'dt_id'; check that column/key exists")

可能数据库中的字段结构已经完成了此字段的修改但是在

   python manage.py makemigrations 新生成的 0028_auto_20190220_1615.py文件中  可能还会有删除字段的操作

# Generated by Django 2.1.2 
from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ('cinema', '0027_auto_20190219_1750'),
    ]

    operations = [
        migrations.RemoveField(
            model_name='cinema',
            name='dt',
        ),
        migrations.AddField(
            model_name='cinema',
            name='city',
            field=models.CharField(default='', max_length=64),
        ),
        migrations.AlterField(
            model_name='cinema',
            name='cinema_code',
            field=models.CharField(max_length=64, null=True, unique=True),
        ),
    ]

所有想要完成

Python manage.py migrate 

需要把这句话注释掉

from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ('cinema', '0027_auto_20190219_1750'),
    ]

    operations = [
        # migrations.RemoveField(
        #     model_name='cinema',
        #     name='dt',
        # ),
        migrations.AddField(
            model_name='cinema',
            name='city',
            field=models.CharField(default='', max_length=64),
        ),
        migrations.AlterField(
            model_name='cinema',
            name='cinema_code',
            field=models.CharField(max_length=64, null=True, unique=True),
        ),
    ]

才能正常的进行数据库 migrate

posted on 2019-02-20 16:23  王大拿  阅读(4802)  评论(1编辑  收藏  举报

导航