The problem in my case seems to be strictly related to psycopg2
backend. I tried with psycopg and it does not happens.
Should I file a ticket?
On 20 Lis, 10:17, Jarek Zgoda <[EMAIL PROTECTED]> wrote:
> 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 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
-~----------~----~----~----~------~----~------~--~---
