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? See http://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 -~----------~----~----~----~------~----~------~--~---
