I don't think it’s the configuration. I suggest you open home/newt/django/1.0/lib/django/db/models/sql/query.py, Go to line 2369 and insert print 'The SQL:\n, sql; print 'The Parameters:\n, params Statements.
Then you analyze your parameters if there is a strange value when the error happens, eg None values or similar strangeness's which aren't accepted by PostgreSQL. And if you find something strange you track where it comes from, maybe from line number = obj.get_aggregation()[None] which can be seen in your traceback. Hope this might help to narrow down the root cause, Rgds Günter -----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von Newt Gesendet: Donnerstag, 10. September 2009 15:07 An: Satchmo users Betreff: Re: Annoying can't adapt problem I use postgresql with psycopg2, mod_python on ubuntu 8.04 I'll try with other databases. Is there any known issue with this configuration? Ales On Sep 9, 4:19 pm, Chris Moffitt <[email protected]> wrote: > Which database are you using? If you try sqlite for testing purposes, do you > see the same thing? > > -Chris > > On Wed, Sep 9, 2009 at 2:46 AM, Newt <[email protected]> wrote: > > > Hello, > > > has anyone encoutered problem when you get the 'can't adapt' error > > when checking out (steps 2 and 3)?? > > it's problem on satchmo 8.1 with both django 1.0 and 1.1 > > it happens just sometimes, so refreshing page helps. I went through > > the critical lines and all seem to be fine. > > > I'll upgrade to satchmo 0.9+ soon, but until then I have to get this > > running. > > > File "/home/newt/django/1.0/lib/satchmo/payment/forms.py", line 43, > > in _get_shipping_choices > > if method.valid(): > > > File "/home/newt/django/1.0/lib/satchmo/shipping/modules/tiered/ > > models.py", line 86, in valid > > price = self.cost() > > > File "/home/newt/django/1.0/lib/satchmo/shipping/modules/tiered/ > > models.py", line 51, in cost > > return self.carrier.price(total) > > > File "/home/newt/django/1.0/lib/satchmo/shipping/modules/tiered/ > > models.py", line 188, in price > > if not prices.count() > 0: > > > File "/home/newt/django/1.0/lib/django/db/models/query.py", line > > 292, in count > > return self.query.get_count() > > > File "/home/newt/django/1.0/lib/django/db/models/sql/query.py", line > > 376, in get_count > > number = obj.get_aggregation()[None] > > > File "/home/newt/django/1.0/lib/django/db/models/sql/query.py", line > > 348, in get_aggregation > > result = query.execute_sql(SINGLE) > > > File "/home/newt/django/1.0/lib/django/db/models/sql/query.py", line > > 2369, in execute_sql > > cursor.execute(sql, params) > > > ProgrammingError: can't adapt > > > Thanks for your help, > > > Ales --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Satchmo 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/satchmo-users?hl=en -~----------~----~----~----~------~----~------~--~---
