I have had this problem as well, and discovered that it is a bug in psycopg2.
If you have multiple sites on the same server, using the same psycopg2, you will run into this error. I successfully fixed it by running my sites using mod_wsgi in daemon mode and using virtualenv. I highly recommend the approach. Yours, Corey On Sep 10, 2009, at 9:35 AM, Günter Walser wrote: > > 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:satchmo- > [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 -~----------~----~----~----~------~----~------~--~---
