On enter in "RoadMap" OR "new Ticket"

[ezidiu@…]

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 387, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.4/site-packages/trac/ticket/roadmap.py", line 160, in process_request
    'owner')
  File "/usr/lib/python2.4/site-packages/trac/ticket/roadmap.py", line 37, in get_tickets_for_milestone
    fields = TicketSystem(env).get_ticket_fields()
  File "/usr/lib/python2.4/site-packages/trac/ticket/api.py", line 123, in get_ticket_fields
    options = [val.name for val in cls.select(self.env, db=db)]
  File "/usr/lib/python2.4/site-packages/trac/ticket/model.py", line 538, in select
    for name, owner, description in cursor:
  File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 40, in __iter__
    row = self.cursor.fetchone()
  File "/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.py", line 3139, in fetchone
    return self.__fetchOneRow()
  File "/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.py", line 2776, in __fetchOneRow
    _r.getvalue(self._idx_, _i)))
  File "/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.py", line 821, in typecast
    return unicode(value, *self.__conn.client_encoding)
UnicodeDecodeError: 'utf8' codec can't decode bytes in position 1-4: invalid data

[Christian Boos]

Well, not much info provided here… From the stacktrace, it seems that it crashes while getting the records from the component table. Did you insert some data manually or with some script, there?

Can you verify the content of that table?

[ezidiu@…]

yes… i verified the content of that table…. i was setted my config manually.

**

[Christian Boos]

Ok, then you need to make sure that the data is correctly encoded.

It should probably be utf-8 encoded. To be sure, try to create a component with non-ascii characters either TracAdmin or WebAdmin, then look at the actual byte content of the table. Adapt the data already there so that it uses the same encoding.