[web2py][GAE]BadValueError: Incomplete key found for reference property

[Phyo Arkar]

Here is another GAE error:



While i am doing this :

def get_items():
        response.generic_patterns = ['json']
        query=(db.item.id>=0)
        #out=[{"name": "Fusion Noodle"}, {"name": "Burger Jumbo"}, {"name": 
"Sushi"}]
        return response.json(db(query).select(db.item.id,db.item.name))




I get:



Traceback (most recent call last):
  File 
"/base/data/home/apps/s~herspos/1.354149753338895814/gluon/restricted.py",
line 192, in restricted
    exec ccode in environment
  File 
"/base/data/home/apps/s~herspos/1.354149753338895814/applications/HersPOS/controllers/default.py:get_items",
line 218, in <module>
  File "/base/data/home/apps/s~herspos/1.354149753338895814/gluon/globals.py",
line 145, in <lambda>
    self._caller = lambda f: f()
  File 
"/base/data/home/apps/s~herspos/1.354149753338895814/applications/HersPOS/controllers/default.py:get_items",
line 160, in get_items
  File "/base/data/home/apps/s~herspos/1.354149753338895814/gluon/dal.py",
line 5481, in select
    return self.db._adapter.select(self.query,fields,attributes)
  File "/base/data/home/apps/s~herspos/1.354149753338895814/gluon/dal.py",
line 3296, in select
    for item in items]
  File 
"/base/python_runtime/python_lib/versions/1/google/appengine/ext/db/__init__.py",
line 2029, in __iter__
    return self.run()
  File 
"/base/python_runtime/python_lib/versions/1/google/appengine/ext/db/__init__.py",
line 2012, in run
    raw_query = self._get_query()
  File 
"/base/python_runtime/python_lib/versions/1/google/appengine/ext/db/__init__.py",
line 2376, in _get_query
    _app=self._app)
  File 
"/base/python_runtime/python_lib/versions/1/google/appengine/api/datastore.py",
line 1328, in __init__
    self.update(filters)
  File 
"/base/python_runtime/python_lib/versions/1/google/appengine/api/datastore.py",
line 1783, in update
    self.__setitem__(filter, value)
  File 
"/base/python_runtime/python_lib/versions/1/google/appengine/api/datastore.py",
line 1726, in __setitem__
    datastore_types.ValidateProperty(' ', value, read_only=True)
  File 
"/base/python_runtime/python_lib/versions/1/google/appengine/api/datastore_types.py",
line 1478, in ValidateProperty
    prop_validator(name, v)
  File 
"/base/python_runtime/python_lib/versions/1/google/appengine/api/datastore_types.py",
line 1392, in ValidatePropertyKey
    'Incomplete key found for reference property %s.' % name)
BadValueError: Incomplete key found for reference property