Edgewall Software
Modify

Opened 16 years ago

Closed 16 years ago

Last modified 14 years ago

#6495 closed defect (duplicate)

Error utf8

Reported by: Sixbell Nekotec Solutions Colombia Owned by: Christian Boos
Priority: normal Milestone:
Component: wiki system Version: 0.10
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description (last modified by Emmanuel Blot)

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

Attachments (0)

Change History (4)

comment:1 by Emmanuel Blot, 16 years ago

Description: modified (diff)
Resolution: fixed
Status: newclosed

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

comment:2 by hagnat, 16 years ago

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 ?

comment:3 by Christian Boos, 16 years ago

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.

comment:4 by Christian Boos, 14 years ago

Resolution: fixedduplicate

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Christian Boos.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from Christian Boos to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.