Hi all, Newbie to Django & hit a brick wall. I'm trying to run syncdb on my models and it bails out on a couple of fields that I have where the issue is maximum key lengths in MySQL.
First field is CharField, unique, max_length=500 Second is TextField, unique In both cases syncdb fails with a MySQLdb _mysql_exceptions.OperationalError (1071, "Specified key was too long: max length is 767 bytes). What MySQL is expecting is obviously a key length specified as part of the constraint/index (as per official docs) but I can't see a way of doing this in Django. I tried the reverse approach of using my existing table SQL scripts from MySQL Workbench to generate the tables and then to write the models to match. This works fine for most things but then you hit the problem of running model unit tests where "manage.py tests" uses the model to generate the test tables & this obviously fails on the key length issue again. "If I had any hair i'd be tearing it out..." Am I missing something obvious (apart from "try Postgres....") ? Thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
