Monday, February 24, 2020

reg: Error:-django.db.utils.OperationalError: (1170, "BLOB/TEXT column 'Description' used in key specification without a key length")

Hi, 

I am creating a model, which is taking a description as text field. when I migrate I see the below error:

django.db.utils.OperationalError: (1170, "BLOB/TEXT column 'Description' used in key specification without a key length")

ON further research I came to know that its some limitation with MySQL. I am using MYSQL for my dev. Below is the link that describes the issue.

MySQL error: key specification without a key length


So what am I suppose to use if not TextField? I have tried CharField, that doesn't work either. Below is the model details:

class OnlineShop(models.Model):
Product_name = models.CharField(max_length=100, unique=True)
Price = models.IntegerField()
Slug = models.SlugField(max_length=250, unique=True)
Description = models.TextField()
Curr_Time = models.DateTimeField(auto_now_add=True)

def __str__(self):
return '{}'.format(self.Product_name)


Regards,
Amitesh Sahay
91-750 797 8619

No comments:

Post a Comment