Django 报错 django.db.utils.OperationalError: (1071, 'Specified key was too long) 解决方法

最新推荐文章于 2024-01-09 14:38:36 发布

程序圆圆圆

最新推荐文章于 2024-01-09 14:38:36 发布

阅读量5.5k

点赞数

分类专栏： Django 文章标签： django mysql

本文链接：https://blog.csdn.net/lancegentry/article/details/90906675

版权

Django 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

Django 报错 django.db.utils.OperationalError: (1071, ‘Specified key was too long; max key length is 767 bytes’)

如果出现以下形式的报错，则是因为模型的CharField的max_length指定的过大。可以通过直接修改migrations的文件修复。

  File "/home/yyy/venv/lib/python3.6/site-packages/MySQLdb/cursors.py", line 374, in _do_query
    db.query(q)
  File "/home/yyy/venv/lib/python3.6/site-packages/MySQLdb/connections.py", line 277, in query
    _mysql.connection.query(self, query)
django.db.utils.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')

例如下面的代码是原文件

class Migration(migrations.Migration):

    dependencies = [
        ('goods', '0006_remove_goodstype_order'),
    ]

    operations = [
        migrations.AlterField(
            model_name='goodstype',
            name='name',
            field=models.CharField(max_length=256, unique=True, verbose_name='名称'),
        ),
    ]

修改为：

class Migration(migrations.Migration):

    dependencies = [
        ('goods', '0006_remove_goodstype_order'),
    ]

    operations = [
        migrations.AlterField(
            model_name='goodstype',
            name='name',
            
            # 修改这里的max_length为50
            field=models.CharField(max_length=50, unique=True, verbose_name='名称'),
        ),
    ]