mb wrote: > Hi, > > it seems there is a problem with the length of table keys, when using > MySQL 5.x and UTF8. > > ... > > To stay true to KISS, change 500 in line 72 to 333 should do the > trick. At least this patch > worked for us.
The real problem is that there's a limit at all... see http://trac.edgewall.org/ticket/3676. There's a patch there, which also contains your proposed fix, plus handles the original issue: http://trac.edgewall.org/attachment/ticket/3676/trac-mysql_backend.diff Of course, special casing column names is a hack, but I don't see how we could do without a hack in this situation, as we're reluctant to make a db change just for that. Even for my proposed change to use different indexes for each backend, I couldn't see how to do it in a non-hackish way... So I think the more pragmatic decision here would be to apply the trac-mysql_backend.diff patch, even if it's not perfect, and take into account the limitations of MySQL when designing the new (multi-)repository cache for 0.12. -- Christian --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Development" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-dev?hl=en -~----------~----~----~----~------~----~------~--~---
