0

I want convert one of my field type from CharField to TextField

I changed as followings:

From:
project = models.CharField('Project',max_length=500)        

To:
project = models.TextField('Project',blank=True)

And after I run the migrate cmd , I met the following errors:

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

I performed the steps mentioned in Django: Convert CharField to TextField with data intact

MySQL:
BEGIN;
    ALTER TABLE TestLog
        MODIFY failed_reqs TEXT NULL,
        MODIFY passed_reqs TEXT NULL;
COMMIT;

Bug met the same errors:

mysql> ALTER TABLE ct_task
    -> MODIFY project TEXT NULL;
ERROR 1170 (42000): BLOB/TEXT column 'project' used in key specification without a key length

Anyone can help how can i do this conversion ? many thanks

Community
  • 1
  • 1
JiangLing
  • 367
  • 1
  • 3
  • 14

0 Answers0