On Mon, 2008-09-29 at 13:38 -0700, felix wrote: > syncdb fails on my deployment server (mysql 5.0.67 on ubuntu) with : > > File "./manage.py", line 11, in <module> > execute_manager(settings) > ... > _mysql_exceptions.OperationalError: (1059, "Identifier name > 'releasesnewsletter_id_refs_abstractmailing_ptr_id_62770683bbc11c0b' > is too long") > > the same codebase succeeds on my development server (mysql 5.0.51a on > OS X) > > its a contraint being added.
> > ubuntu: > ALTER TABLE `website_releasesnewsletter_additional_recipients` ADD > CONSTRAINT > releasesnewsletter_id_refs_abstractmailing_ptr_id_14a73856b276acd4 > FOREIGN KEY (`releasesnewsletter_id`) REFERENCES > `website_releasesnewsletter` (`abstractmailing_ptr_id`); > > mac: > ALTER TABLE `website_artistnewsletter_additional_recipients` ADD > CONSTRAINT artistnewsletter_id_refs_abstractmailing_ptr_id_4326e0be > FOREIGN KEY (`artistnewsletter_id`) REFERENCES > `website_artistnewsletter` (`abstractmailing_ptr_id`); So it's not the same codebase then or you're not posting comparable lines, since these two lines are referring to quite different tables. > the ticket I guess is here: > http://code.djangoproject.com/ticket/1820 > > so the constraint generates a hash now, and the mac happened to get a > shorter hash. > egregiously long table name + hash = TILT ! Please open a new ticket about this. Looks like there is an assumption in the code that hash() will return things of a certain length and that isn't necessarily correct. Regards, Malcolm --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
