Hi, everybody.
mwerr, I've tried it with success.
Now my trac system is almost working.
The only issue I have is:
All the queryies trac sends to mysql works, except the one which
retrieves the reports.
I was surfing the code and I found the problem is in line 404 of
ticket/report.py:
cursor.execute(sql, args)
If I replace the sql variable with a literal string it works fine. For
example the following works:
cursor.execute("select * from ticket",[])
(indeed, I replace with a literal string that is in sql variable)
The error raised up is:
unknown encoding: latin1_swedish_ci
My database, tables and fields are in utf8 general. The mysql engine
is in latin1_swedish_ci (I can't change it, I'm not the admin).
I'm working with the following versions:
Python 2.3.4
MySQL 4.1.11
Trac 0.10.4
Thanks in advance.
On 15 jun, 10:23, mwuerr <[EMAIL PROTECTED]> wrote:
> 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_cifor each table. Both prior and after I ran the query
> > ALTER DATABASE DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci, but
> > it still is atlatin1_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
-~----------~----~----~----~------~----~------~--~---
