When using MySQL, you should be using the utf8_bin collation, since Trac assumes that DB is case-sensitive.
--Noah > -----Original Message----- > From: [email protected] [mailto:[email protected]] > On Behalf Of Daniel Mayer > Sent: Monday, February 02, 2009 2:21 AM > To: [email protected] > Subject: [Trac] Re: deletion of two files in different cases break > repository browser / timeline > > > > On Mon, 2009-02-02 at 07:41 +0100, Jeroen Ruigrok van der Werven wrote: > > -On [20090202 02:20], [email protected] ([email protected]) wrote: > > >The history still contains the two import_csv.php files of course. > > >When we view this repository with the Trac browser, it still shows > the > > >two files and stops showing revisions which are newer than the one > in > > >which the two files have been deleted. I.e. it does not show the > most > > >recent revision nor any changes from the point of deletion on. > > > > Have you tried a manual sync from trac-admin? > > Hi, > > I did try it now, and it seems to bring us closer to the root of the > problem. The error at the end below is exactly caused by the file I > mentioned in my original email. This is the output: > > > Resyncing repository history... > /usr/lib/python2.4/site-packages/Trac-0.11.2.1- > py2.4.egg/trac/db/util.py:50: Warning: Data truncated for column 'path' > at row 1 > return self.cursor.execute(sql_escape_percent(sql), args) > /usr/lib/python2.4/site-packages/Trac-0.11.2.1- > py2.4.egg/trac/db/util.py:50: Warning: Data truncated for column > 'base_path' at row 1 > return self.cursor.execute(sql_escape_percent(sql), args) > /usr/lib/python2.4/site-packages/Trac-0.11.2.1- > py2.4.egg/trac/db/util.py:50: Warning: Data truncated for column > 'message' at row 1 > return self.cursor.execute(sql_escape_percent(sql), args) > Traceback (most recent call last): > File "/usr/bin/trac-admin", line 7, in ? > sys.exit( > File > "/usr/lib/python2.4/site-packages/Trac-0.11.2.1- > py2.4.egg/trac/admin/console.py", line 1294, in run > return admin.onecmd(command) > File > "/usr/lib/python2.4/site-packages/Trac-0.11.2.1- > py2.4.egg/trac/admin/console.py", line 123, in onecmd > rv = cmd.Cmd.onecmd(self, line) or 0 > File "/usr/lib/python2.4/cmd.py", line 219, in onecmd > return func(arg) > File > "/usr/lib/python2.4/site-packages/Trac-0.11.2.1- > py2.4.egg/trac/admin/console.py", line 665, in do_resync > repos = env.get_repository().sync(self._resync_feedback) > File > "/usr/lib/python2.4/site-packages/Trac-0.11.2.1- > py2.4.egg/trac/versioncontrol/cache.py", line 210, in sync > (str(next_youngest), > File > "/usr/lib/python2.4/site-packages/Trac-0.11.2.1- > py2.4.egg/trac/db/util.py", line 50, in execute > return self.cursor.execute(sql_escape_percent(sql), args) > File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line 163, > in execute > self.errorhandler(self, exc, value) > File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line > 35, in defaulterrorhandler > raise errorclass, errorvalue > _mysql_exceptions.IntegrityError: (1062, "Duplicate entry > '875-trunk/wsb/htdocs/system/pages/cms/user/import_csv.php-D' for key > 1") > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
