django.db.utils.OperationalError: (1071, 'Angegebener Schlüssel war zu lang; maximale Schlüssellänge beträgt 767 Byte')
Mein Modell
class Course(models.Model):
language = models.ForeignKey(Language)
name = models.CharField(max_length=50, unique=True, default='course')
title = models.CharField(max_length=1024, default='no title')
foreign_title = models.CharField(max_length=1024, default='no title', blank=True)
header = models.CharField(max_length=1024, default='', blank=True)
description = models.TextField(null=True, blank=True)
def __str__(self):
return self.title
def __unicode__(self):
return u'%s' % self.title
Ich füge "unique_together" hinzu:
class Course(models.Model):
language = models.ForeignKey(Language)
name = models.CharField(max_length=50, unique=True, default='course')
title = models.CharField(max_length=1024, default='no title')
foreign_title = models.CharField(max_length=1024, default='no title', blank=True)
header = models.CharField(max_length=1024, default='', blank=True)
description = models.TextField(null=True, blank=True)
class Meta:
unique_together = ['language', 'name', 'title']
def __str__(self):
return self.title
def __unicode__(self):
return u'%s' % self.title
Migrationszeit, in der der Fehler angezeigt wird:
django.db.utils.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')
Meine DB ist: mysql Ver 15.1 Distrib 10.0.17-MariaDB, für debian-linux-gnu (x86_64) mit readline 5.2
Ich habe versucht, den Index mysql zu verlängern:
MariaDB [(none)]> set global innodb_file_format = BARRACUDA;
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> set global innodb_large_prefix = ON;
Query OK, 0 rows affected (0.00 sec)
Aber das ist immer noch nicht genug:
django.db.utils.OperationalError: (1071, 'Specified key was too long; max key length is 3072 bytes')
Die Problemindexlänge. Wie spezifiziere ich den Längenlimit-Django-Index?