This means that the DB contains non-UTF-8 characters. To fix this, you need to find the culprit in the DB, and fix it either in the DB or in the SQL archive and re-import the archive once you're sure that the archive only contains UTF-8 data. You can try isolate which SQL table is in trouble: use the "Search" menu (not the Search shortcut), then perform a search for only one of the available options (ticket, wiki, changesets) You can also try to search for char "0x80" in your SQL archive.
HTH, Manu On 7/17/07, Fangman, Patricia M (Shelly) <[EMAIL PROTECTED]> wrote: > > > > I'm running Trac on RHEL 4 update 5. I'm have Trac 0.10.4, subversion > 1.4.3, python 2.3 and postgresql 8.2.4. The database was converted from > another Trac server (they used SQLite). When accessing certain tickets or > performing a search, we get the error you see below. Any idea how to start > debugging this issue? > > Traceback (most recent call last): > File > "/usr/lib/python2.3/site-packages/trac/web/main.py", line > 406, in dispatch_request > dispatcher.dispatch(req) > File > "/usr/lib/python2.3/site-packages/trac/web/main.py", line > 237, in dispatch > resp = chosen_handler.process_request(req) > File > "/usr/lib/python2.3/site-packages/trac/ticket/web_ui.py", > line 313, in process_request > get_reporter_id(req, 'author')) > File > "/usr/lib/python2.3/site-packages/trac/ticket/web_ui.py", > line 630, in _insert_ticket_data > for change in self.grouped_changelog_entries(ticket, db): > File > "/usr/lib/python2.3/site-packages/trac/ticket/web_ui.py", > line 677, in grouped_changelog_entries > changelog = ticket.get_changelog(when=when, db=db) > File > "/usr/lib/python2.3/site-packages/trac/ticket/model.py", > line 298, in get_changelog > for t, author, field, oldvalue, newvalue, permanent in cursor: > File "/usr/lib/python2.3/site-packages/trac/db/util.py", > line 40, in __iter__ > row = self.cursor.fetchone() > UnicodeDecodeError: 'utf8' codec can't decode byte 0x80 in position 22: > unexpected code byte > > > Shelly Fangman > EMSL High Performance Computing and Networking Services (HPCaNS) > Battelle (Pacific Northwest National Laboratories) > [EMAIL PROTECTED] > > > -- Manu --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
