Hi,
Im using web2py 2.9.12, Im developing on local gae, and when I tried to
execute this query:
pics = db(db.pics.user_id==user_id).select(db.pics.img_link,
projection=True
,orderby=~db.pics.up_date, limitby=(num_min, num_max))
I got that error
WARNING 2015-08-21 23:40:54,728 tasklets.py:410] suspended generator
run_to_queue(query.py:938) raised BadRequestError(projection and keys_only
cannot both be set)
WARNING 2015-08-21 23:40:54,729 tasklets.py:410] suspended generator
helper(context.py:876) raised BadRequestError(projection and keys_only
cannot both be set)
WARNING 2015-08-21 23:40:54,729 tasklets.py:410] suspended generator
has_next_async(query.py:1760) raised BadRequestError(projection and
keys_only cannot both be set)
WARNING 2015-08-21 23:40:54,730 tasklets.py:410] suspended generator
_fetch_page_async(query.py:1349) raised BadRequestError(projection and
keys_only cannot both be set)
ERROR 2015-08-21 23:40:54,736 restricted.py:69] Unable to store in
FILE:
/home/jukvoxman/uweb2py2.9.12/applications/relatos/controllers/default.py
Traceback (most recent call last):
File "/home/jukvoxman/uweb2py2.9.12/gluon/restricted.py", line 227, in
restricted
exec ccode in environment
File
"/home/jukvoxman/uweb2py2.9.12/applications/relatos/controllers/default.py",
line 224, in <module>
File "/home/jukvoxman/uweb2py2.9.12/gluon/globals.py", line 412, in
<lambda>
self._caller = lambda f: f()
File
"/home/jukvoxman/uweb2py2.9.12/applications/relatos/controllers/default.py",
line 82, in getPicsRangeByUserId
projection=True ,orderby=~db.pics.up_date, limitby=(num_min,
num_max))
File "/home/jukvoxman/uweb2py2.9.12/gluon/packages/dal/pydal/objects.py",
line 2026, in select
return adapter.select(self.query,fields,attributes)
File
"/home/jukvoxman/uweb2py2.9.12/gluon/packages/dal/pydal/adapters/google_adapters.py",
line 484, in select
(items, tablename, fields) = self.select_raw(query,fields,attributes)
File
"/home/jukvoxman/uweb2py2.9.12/gluon/packages/dal/pydal/adapters/google_adapters.py",
line 449, in select_raw
keys, cursor, more = items.fetch_page(limit,**fetch_args)
File
"/home/jukvoxman/google_appengine/google/appengine/ext/ndb/utils.py", line
142, in positional_wrapper
return wrapped(*args, **kwds)
File
"/home/jukvoxman/google_appengine/google/appengine/ext/ndb/query.py", line
1331, in fetch_page
return self.fetch_page_async(page_size, **q_options).get_result()
File
"/home/jukvoxman/google_appengine/google/appengine/ext/ndb/tasklets.py",
line 326, in get_result
self.check_success()
File
"/home/jukvoxman/google_appengine/google/appengine/ext/ndb/tasklets.py",
line 369, in _help_tasklet_along
value = gen.throw(exc.__class__, exc, tb)
File
"/home/jukvoxman/google_appengine/google/appengine/ext/ndb/query.py", line
1349, in _fetch_page_async
while (yield it.has_next_async()):
File
"/home/jukvoxman/google_appengine/google/appengine/ext/ndb/tasklets.py",
line 369, in _help_tasklet_along
value = gen.throw(exc.__class__, exc, tb)
File
"/home/jukvoxman/google_appengine/google/appengine/ext/ndb/query.py", line
1760, in has_next_async
yield self._fut
File
"/home/jukvoxman/google_appengine/google/appengine/ext/ndb/context.py",
line 876, in helper
batch, i, ent = yield inq.getq()
File
"/home/jukvoxman/google_appengine/google/appengine/ext/ndb/query.py", line
938, in run_to_queue
batch = yield rpc
File
"/home/jukvoxman/google_appengine/google/appengine/ext/ndb/tasklets.py",
line 455, in _on_rpc_completion
result = rpc.get_result()
File
"/home/jukvoxman/google_appengine/google/appengine/api/apiproxy_stub_map.py",
line 613, in get_result
return self.__get_result_hook(self)
File
"/home/jukvoxman/google_appengine/google/appengine/datastore/datastore_query.py",
line 2897, in __query_result_hook
self._batch_shared.conn.check_rpc_success(rpc)
File
"/home/jukvoxman/google_appengine/google/appengine/datastore/datastore_rpc.py",
line 1373, in check_rpc_success
raise _ToDatastoreError(err)
BadRequestError: projection and keys_only cannot both be set
I have set and index on img_link row (pics entity) like this to be able to
make the projection query on this row:
- kind: pics
properties:
- name: user_id
- name: img_link
- name: up_date
direction: desc
But still no luck... is this a bug or could someone give me a workaround to
fix it?
Thanks in advance!
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
