Hi, I just had the same problem.
Windows, MySql 5.0 python 2.4, Trac 10.4 As I found ne other thread about this I think I should share what I found out: I had to drop the database and delete the partial environment that was created by my first call to trac-admin Then i recreated the database mysql> CREATE trac; and then I thought I could be a good Idea to set the character set so i executed: mysql> USE trac; mysql> ALTER DATABASE DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; then I did run trac-admin again and everything worked fine. My trac seems to work now A wish here, you could detect this a create a usefull errormessage. The same with the case when the specified database does not exists. Some users may not be able to read the exception output and figure out what is wrong. Marcus On May 21, 10:57 pm, "Wetterman, Christopher" <[EMAIL PROTECTED]> wrote: > Trac can connect to the MySQL DB just fine. It has created all the > tables itself. I did notice though the character set is > latin1_swedish_ci for each table. Both prior and after I ran the query > ALTER DATABASE DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci, but > it still is at latin1_swedish_ci. Not sure where to go from here. > > Chris > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] > > On Behalf Of [EMAIL PROTECTED] > Sent: Monday, May 21, 2007 2:02 AM > To: [email protected] > Subject: [Trac] AW: [Trac] Issues Regarding Windows Install of Trac > 0.10.4 Environment > > > self.cursor.execute(sql_escape_percent(sql), args) > > File "C:\Program Files\Python24\Lib\site-packages\MySQLdb > > \cursors.py", line 166, in execute self.errorhandler(self, exc, value) > > File "C:\Program Files\Python24\Lib\site-packages\MySQLdb > > \connections.py", line 35, in defaulterrorhandler raise errorclass, > > errorvalue > > OperationalError: (1366, "Incorrect string value: '\\xE2\\x86\\x92 > >Ex...' for column 'text' at row 0") > > I think there's a problem with the MySql database. > Your wrote that you have installed MySql. > Have you created a database for your trac environment and the according > user? > Seehttp://trac.edgewall.org/wiki/DatabaseBackend > Is the database started as a service at startup? > Was the MySql server running when you started to create the Trac > environment? > Has the Trac database user the right to connect from the localhost to > the MySql database? > > Alex --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
