Edgewall Software

Ticket #5051 (closed defect: worksforme)

Opened 20 months ago

Last modified 20 months ago

On enter in "RoadMap" OR "new Ticket"

Reported by: ezidiu@… Owned by: jonas
Priority: normal Milestone:
Component: general Version:
Severity: normal Keywords: postgresql
Cc:

Description (last modified by cboos) (diff)

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

Attachments

Change History

Changed 20 months ago by cboos

  • keywords postgresql verify added
  • description modified (diff)

Changed 20 months ago by cboos

  • keywords needinfo added; verify removed

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?

Changed 20 months ago by ezidiu@…

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

**

Changed 20 months ago by cboos

  • keywords needinfo removed
  • status changed from new to closed
  • resolution set to worksforme

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.

Add/Change #5051 (On enter in "RoadMap" OR "new Ticket")

Author



Change Properties
<Author field>
Action
as closed
Next status will be 'reopened'
to The owner will change from jonas. Next status will be 'closed'
 
Note: See TracTickets for help on using tickets.