How to solve #1170-blob/text column variable key specification

#1170 – Blob/Text Column ‘Variable’ Used In Key Specification Without A Key Length In Django

If you having 1170 – Blob/Text Column ‘Variable’ Used In Key Specification error and you have search for solution you didn’t see, then welcome at the end of this article you will be able to solve your problem.

How to solve #1170 – BLOB/TEXT column ‘variable’ used in key specification without a key length in django

The error message you have  encountered  (#1170) usually comes up  in MySQL when you’re trying to create an index on a column of data type BLOB or TEXT without specifying a key length.

Or some times you might been on sqLite then you might want to migrate to MySql then the error will pop up if you have set a unique constraint without specifying a key length.

Say for example you have added unique key in slug then you must specify a key length in the title, also you must also specify a key length in the slug it self .

lets say you have a model then with title and slug then you want a unique constrant in such a way that all your slug would be unique then to solve thisÂ

Steps required in solving #1170 – BLOB/TEXT column ‘variable’ used in key specification without a key length in django

from django.db import models
from django.utils.text import slugify

class Blog(models.Model):
    title = models.CharField(max_length=200)
    slug = models.SlugField(unique=True, blank=True)

    def save(self, *args, **kwargs):
        if not self.slug:
            self.slug = slugify(self.title)
        super().save(*args, **kwargs)

    def __str__(self):
        return self.title

Since you have specify a key length in the title the error will disappearÂ

To resolve this issue, you need to ensure that you provide a key length when creating an index on columns of these data types.

You don’t need to enter into  your db to resolve this issue, just make sure that you specify a key length in some of the fields you have like title, Slug, category etcÂ

Here’s an example of how you can modify your index creation statement

how to install burp suite in Kali Linux