The charset problem in mysql, I fixed by changing this line in
mysql_backend.py (line 88 in trunk)

from

sql.append(',\n'.join(coldefs) + '\n)')

to

sql.append(',\n'.join(coldefs) + '\n) DEFAULT CHARSET=utf8')

You will probably want to add changes from ticket #986 Comment 47 (the
comment dealing with changes to trac/ticket/model.py)

The 1000 byte limit I fixed by changing this line in mysql_backend.py
(line 61 in trunk)

from

limit = 500 / len(columns)

to

limit = 250 / len(columns)

This is my workaround and is not part of any official trac.  And I am
by no means a python programmer.  But it may work for you as well.

I am using 0.10dev (rev 35something) on Fedora Core 4 and mysql 4.1.12-2

This is what worked for me.

On 8/28/06, Don Fike <[EMAIL PROTECTED]> wrote:

Will issues with MySQL charset utf-8 and key size limits of 1000 bytes
be addressed in the 0.1 release?
This has been a bit of a problem.  On my initenv I had to manually edit
the charset and key sizes to get up
and running.  But this issue seems to come back.  For instance on
attempting to install TagsPlugin, upgrade
fails with the same key size limit error.  Any suggestions on how to
correct the upgrade error appreciated.

Thanks,


_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac

_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac

Reply via email to