PyAMF DatabaseError:'数据库不支持此查询。'返回用户obj时

Question

这是我得到的错误：

ERROR    2011-11-19 04:19:55,441 django.py:164] Error encoding AMF request
Traceback (most recent call last):
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/remoting/gateway/django.py", line 161, in __call__
    logger=self.logger, timezone_offset=timezone_offset)
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/remoting/__init__.py", line 676, in encode
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/remoting/__init__.py", line 520, in _write_body
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/remoting/__init__.py", line 486, in _encode_body
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/codec.py", line 499, in writeElement
    func(data)
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/amf0.py", line 657, in writeAMF3
    self.context.getAMF3Encoder(self).writeElement(data)
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/codec.py", line 499, in writeElement
    func(data)
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/amf3.py", line 1456, in writeObject
    self.writeElement(value)
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/codec.py", line 499, in writeElement
    func(data)
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/amf3.py", line 1298, in writeList
    [self.writeElement(x) for x in n]
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/codec.py", line 499, in writeElement
    func(data)
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/codec.py", line 358, in __call__
    ret = self.func(data, encoder=self.encoder)
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/adapters/_django_db_models_base.py", line 276, in writeDjangoObject
    encoder.writeObject(referenced_object)
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/amf3.py", line 1468, in writeObject
    self.writeElement(value)
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/codec.py", line 499, in writeElement
    func(data)
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/codec.py", line 358, in __call__
    ret = self.func(data, encoder=self.encoder)
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/adapters/_django_db_models_base.py", line 276, in writeDjangoObject
    encoder.writeObject(referenced_object)
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/amf3.py", line 1468, in writeObject
    self.writeElement(value)
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/codec.py", line 499, in writeElement
    func(data)
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/codec.py", line 358, in __call__
    ret = self.func(data, encoder=self.encoder)
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/adapters/_django_db_models_base.py", line 276, in writeDjangoObject
    encoder.writeObject(referenced_object)
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/amf3.py", line 1447, in writeObject
    attrs = alias.getEncodableAttributes(obj, codec=self)
  File "/Library/Python/2.6/site-packages/PyAMF-0.6.1-py2.6-macosx-10.6-universal.egg/pyamf/adapters/_django_db_models_base.py", line 173, in getEncodableAttributes
    attrs[name] = [x for x in getattr(obj, name).all()]
  File "/Users/bryce/Documents/Aptana Studio 3 Workspace/django-blog/django/db/models/query.py", line 107, in _result_iter
    self._fill_cache()
  File "/Users/bryce/Documents/Aptana Studio 3 Workspace/django-blog/django/db/models/query.py", line 774, in _fill_cache
    self._result_cache.append(self._iter.next())
  File "/Users/bryce/Documents/Aptana Studio 3 Workspace/django-blog/django/db/models/query.py", line 275, in iterator
    for row in compiler.results_iter():
  File "/Users/bryce/Documents/Aptana Studio 3 Workspace/DennysBE/djangotoolbox/db/basecompiler.py", line 225, in results_iter
    self.check_query()
  File "/Users/bryce/Documents/Aptana Studio 3 Workspace/DennysBE/djangotoolbox/db/basecompiler.py", line 273, in check_query
    raise DatabaseError('This query is not supported by the database.')
DatabaseError: This query is not supported by the database.

以下是我对这个问题很重要的模型：

^{pr2}$

以下是导致错误的方法：

def foo_bar(request):
    user = request.user
    c = ChallengeAct()
    c.challenge = Challenge.objects.get(id=1)
    c.start_date = datetime.now()
    c.progress_value = 1
    c.user = user
    c.save()

#    Here is where I set the user to null to avoid the DatabaseError
    c.user = None
    return [c]

有趣的是，我需要在返回之前设置c.user = None，这样就不会出现{}问题。在

--update——我想得越多，获取user对象就好像是pyamf和django-nonrl问题。我猜当pyamf试图获取user对象时，它正在使用某种类型的join查询，这在django nonrl上不受支持。在

为什么会这样？有办法绕过它吗？在

Answer 1

您不必为用户模型考虑blank=True, null=True。通常，django.contrib.auth.models.AnonymousUser负责匿名请求。它可能解决也可能无法解决问题，但值得尝试，即：

class ChallengeAct(RewardActBase):
    user = models.ForeignKey(User)
    ....