django.db.utils.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')

Open bktbunu opened this issue 5 years ago • 1 comments

I am using Python 3.8 on ubuntu 18.04. While running sudo python3 manage.py migrate I am getting the following error. Other tables are migrated successfully except django_chatterbot

Applying django_chatterbot.0010_statement_text...Traceback (most recent call last): .... .... File "/usr/local/lib/python3.8/site-packages/MySQLdb/connections.py", line 239, in query _mysql.connection.query(self, query) django.db.utils.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')

error.txt

Mar 24 '20 06:03 bktbunu

It looks like the 0010 migration increased the text field length from 255 characters to 400, I wonder if this error was something MySQL-specific.

Mar 30 '25 15:03 gunthercox