On Wed, 2008-02-13 at 23:59 -0800, Meista wrote:
> Hi,
>
> im getting a UnicodeDecodeError in my application.
> The strange thing is that it appears on the very first request after a
> restart.
> Then everything works fine but the error appears sporadic over the
> day.
> The app runs as fastcgi. Django version is trunk from 01/27/2008
> request.session['akt_Firma'] contains a number i.e "1".
> Has somebody a hint for me?
> Traceback (most recent call last):
[...]
> File "/usr/lib/python2.4/site-packages/django/db/models/query.py",
> line 189, in iterator
> cursor.execute("SELECT " + (self._distinct and "DISTINCT " or "")
> + ",".join(select) + sql, params)
>
> 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
>
> UnicodeDecodeError: 'utf8' codec can't decode bytes in position 3-4:
> invalid data
It looks like this is being raised by the MySQL wrapper when it tries to
convert the data it has read back from UTF-8 into Unicode (a *decode*
error happens in the conversion from UTF-8 -> Unicode, an *encode* error
happens when going in the opposite direction).
That suggests the data in your database, isn't correctly encoded for
some reason. You'll need to capture the exact value(s) of akt_Firma that
is causing the problem and manually check the database entries.
Alternatively, you could probably work out which entries are problematic
by looping through all possible values for akt_Firma and then extracting
the records one at a time. For example:
values = [int(o['nr']) for o in Firma.objects.values('nr')]
for v in values:
print 'Trying akt_Firma =', v
Firma.objects.get(nr=v)
and then sit back and wait for the wheels to fall off. Then you'll have
to examine the database by hand, because Django's already telling you it
can't read the data.
Regards,
Malcolm
> >
>
--
Why can't you be a non-conformist like everyone else?
http://www.pointy-stick.com/blog/
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
