Error utf8

[Sixbell Nekotec Solutions Colombia]

Hi

My English isn't very good but i try to explain you, what's the problem.

I'm working in my own trac which is installed in a internal server. I work in it without problem but if the Server is working in some else the service of my trac don't work. This problem was when in the server become a transfer file for other aplication. The trac return when i restart the Apache server.

In other way, the same problem begin when i'm burning a CD in the server.

Traceback (most recent call last):
  File "E:\Proyecto_TRAC\python\Lib\site-packages\trac\web\main.py", line 406, in dispatch_request
    dispatcher.dispatch(req)
  File "E:\Proyecto_TRAC\python\Lib\site-packages\trac\web\main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "E:\Proyecto_TRAC\python\Lib\site-packages\trac\wiki\web_ui.py", line 97, in process_request
    page = WikiPage(self.env, pagename, version, db)
  File "E:\Proyecto_TRAC\python\Lib\site-packages\trac\wiki\model.py", line 32, in __init__
    self._fetch(name, version, db)
  File "E:\Proyecto_TRAC\python\Lib\site-packages\trac\wiki\model.py", line 53, in _fetch
    (name,))
  File "E:\Proyecto_TRAC\python\Lib\site-packages\trac\db\util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "E:\Proyecto_TRAC\python\Lib\site-packages\trac\db\util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "E:\Proyecto_TRAC\python\Lib\site-packages\MySQLdb\cursors.py", line 163, in execute
    self.errorhandler(self, exc, value)
  File "E:\Proyecto_TRAC\python\Lib\site-packages\MySQLdb\connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
UnicodeDecodeError: 'utf8' codec can't decode bytes in position 247-250: invalid data

[Emmanuel Blot]

Just another character encoding issue with MySQL (sigh…)

See MySqlDb for hints about setting up a Trac environment with MySQL. It is likely your MySQL database is not configured to use UTF-8 character set.

Duplicate of #3723

[hagnat]

found the same error in my trac. After i changed my tables to utf8_general_ci and restarted tracd, my application was working perfectly.

Why doesnt trac set this tables automatically to utf8 when it creates them on install ?

[Christian Boos]

I think it's better if the whole database is created with that default setting (as already strongly advised in MySqlDb and DatabaseBackend - need to check TracInstall and co. by the way).

Reason is that plugins might also create tables and should not have to care about MySQL being used or not.