incorrect string values setting environment

[KarlGoetz]

Binary package hint: trac

Ubuntu server, running 7.10
Trac version:
apt-cache policy trac
trac:
  Installed: 0.10.4-2
  Candidate: 0.10.4-2

Not sure if these are a problem or not:

Creating and Initializing Project
 Installing default wiki pages
 /usr/share/trac/wiki-default/TracQuery => TracQuery
 /usr/share/trac/wiki-default/TracFastCgi => TracFastCgi
/var/lib/python-support/python2.5/trac/db/util.py:50: Warning: Incorrect string value: '\xE2\x86\x92 Ex...' for column 'text' at row 1
  return self.cursor.execute(sql_escape_percent(sql), args)
 /usr/share/trac/wiki-default/WikiHtml => WikiHtml
 /usr/share/trac/wiki-default/TracUnicode => TracUnicode
/var/lib/python-support/python2.5/trac/db/util.py:50: Warning: Incorrect string value: '\xD8\xAA\xD8\xB1\xD8\xA7...' for column 'text' at row 0
  return self.cursor.execute(sql_escape_percent(sql), args)
 /usr/share/trac/wiki-default/TracAccessibility => TracAccessibility
 /usr/share/trac/wiki-default/CamelCase => CamelCase
<workin stuff>

/var/lib/python-support/python2.5/trac/db/util.py:50: Warning: Incorrect string value: '\xD0\xBF\xD0\xB5\xD1\x80...' for column 'text' at row 0

 [9/var/lib/python-support/python2.5/trac/db/util.py:50: Warning: Data truncated for column 'message' at row 1
  return self.cursor.execute(sql_escape_percent(sql), args)

[Tim Hatch (timhatch)]

Hi, thanks for using Trac.

This is an install (or maybe docs) issue. Trac requires UTF-8 databases (that's what those byte sequences are), and those warnings come from mysql. If you use sqlite (like it defaults to) there are no issues like this (so most users won't hit this). The ones that do haven't read http://trac.edgewall.org/wiki/MySqlDb#MySQL in which is stated:

> In order to avoid several issues with unicode and international characters
> throughout Trac (e.g., international characters turning into question marks
> with mysterious "Incorrect string value" errors logged), we strongly advise
> MySQL users to only use databases having the utf8 character set...

I tested on 7.10 and by following the proper CREATE TABLE statement (from that link) things work fine. Leaving it at the default (latin1 on my system), the warnings appear.

[Maarten Bezemer (veger)]

Thank you for taking the time to report this bug and helping to make Ubuntu better. We are sorry that we do not always have the capacity to look at all reported bugs in a timely manner. There have been many changes in Ubuntu since that time you reported the bug and your problem may have been fixed with some of the updates. It would help us a lot if you could test it on a currently supported Ubuntu version. When you test it and it is still an issue, kindly upload the updated logs by running apport-collect 174589 and any other logs that are relevant for this particular issue.

[Launchpad Janitor (janitor)]

[Expired for trac (Ubuntu) because there has been no activity for 60 days.]