List Info

Thread: Trac 0.10b1 Released




Trac 0.10b1 Released
user name
2006-08-28 22:27:23
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
Traclists.edgewall.com
http:
//lists.edgewall.com/mailman/listinfo/trac
Trac 0.10b1 Released
user name
2006-08-28 23:47:54
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 <fikecs.utk.edu> 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
> Traclists.edgewall.com
> http:
//lists.edgewall.com/mailman/listinfo/trac
>
_______________________________________________
Trac mailing list
Traclists.edgewall.com
http:
//lists.edgewall.com/mailman/listinfo/trac
[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )