I just started receiving the same problem when I try to save an object
that has non-ASCII values in char field (the values are all properly
decoded to unicode)> This seems related to psycopg2 backend, as I do
not observe such behaviour on my dev server with sqlite3 backend. The
model is similar to:
class Label(models.Model):
title = models.CharField(max_length=200, unique=True)
the code that leads to exception is like:
t = 'żołędzie'.decode('utf-8')
label = Label(title=t)
label.save()
The traceback from ipython:
/home/zgoda/www/zgodowie/blog/models.py in save(self)
42 if not self.slug:
43 self.slug = slughifi(self.title)
---> 44 super(Label, self).save()
45
46
/home/zgoda/www/.python/lib/python2.4/site-packages/django/db/models/
base.py in save(self, raw)
257 cursor.execute("INSERT INTO %s (%s) VALUES
(%s)" % \
258 (qn(self._meta.db_table),
','.join(field_names),
--> 259 ','.join(placeholders)), db_values)
260 else:
261 # Create a new record with defaults for
everything.
ProgrammingError: can't adapt
I use SVN trunk rev. 6702.
On 26 Paź, 09:47, sandro dentella <[EMAIL PROTECTED]> wrote:
> On 26 Set, 12:59, Sandro Dentella <[EMAIL PROTECTED]> wrote:
>
>
>
> > Hi,
>
> > I'm meeting a weird problem in adjangoapplication.
> > It works w/o any problem from my pc connecting remotely to my customer's
> > apache but is not working inside the lan.
>
> > I'm connecting from firefox/ubuntu they're connecting from firefox/XP.
>
> > the weird part is that:
>
> > 1. they have being working w/o probelms for 10 days and no modifications
> > where made
>
> > 2. the error complains "can'tadapt" as if trying to insert wrong types
> > into the db, but the error trace shows the values are correct
>
> > 3. a restart of apache fixes the problem
>
> > 4. this is the second time the error happens...
>
> > Any hints?
> > TIA
> > sandro
> > *:-)
>
> Hi,
>
> once again I stumble into this problem. This time I gathered some
> more
> info so I describe them.
>
> I try to insert a record it fails from a Windows pc with Firefox
> (and
> IE). It works from linux (firefox or galeon).
>
> When it fails the error message is "can't adapt" but
>
> 1. the params in the log are:
> ('2007-10-26 08:50:03.651993', '2007-10-26 08:50:03.652039', 1, 17,
> '2007-10-26', u'2', Decimal("100"), 'h', u'prova in fi'
>
> 2. from my linux box I print params before a *working* insert and I
> get:
> ['2007-10-26 09:17:44.744656', '2007-10-26 09:17:44.744682', 1, 17,
> '2007-10-26', u'2', Decimal("100"), 'h', u'prova']
>
> Not realy different!!!!
>
> 3. When it fails the database is not hit. Db is postgres and I
> switched on
> statement log on every log:
>
> log_min_duration_statement = 0
>
> 4. If I restart apache the error is fixed
>
> I'm running mod_wsgi
>
> What should I do, next time it happens to better investigate. It's
> already
> happened 4 times in 2 months and I cannot just accept it...
>
> Thanks for any possible help
>
> sandro
> *:-)
>
> the insert statement that worked follows:
>
> INSERT INTO
> "timereport_report"
> ("date_create","date_last_modify","status","user_id","date","job_id","qty","unit","description")
> VALUES ('2007-10-26 10:09:07.721575','2007-10-26 10:09:07.721619',
> 1,17,'2007-10-26','2',100,'h','prova in fi2')
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django 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/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
