"Can't adapt" is quite a vague error that psycopg2 issues.

Your issue is (apparently) something to do with encoding, and that's
different than Sandro's issue.

Please include more information, especially if you do decide to file a
ticket.  I can't help with the info given so far...

On Nov 20, 2007 2:55 PM, Jarek Zgoda <[EMAIL PROTECTED]> wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---

Reply via email to