django-autofixture icon indicating copy to clipboard operation
django-autofixture copied to clipboard

errro with mysql Row size

Open albertwh1te opened this issue 8 years ago • 1 comments

when I use sqllite as my django databases when I run this command python manage.py loadtestdata -v0 product.TrustProduct:10 it works perfectly well But when I use Mysql as my database;

Django throwout this error message:

django.db.utils.OperationalError: (1118, 'Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.')

albertwh1te avatar Jul 12 '16 08:07 albertwh1te

Hm, the generators usually get a correct max_length set that is determined from the actual model field. Can you paste the definition of your model here maybe? Are you sure the max length in the DB and in your model matches up?

gregmuellegger avatar Aug 20 '16 16:08 gregmuellegger