Done! El domingo, 23 de agosto de 2015, 2:10:27 (UTC+2), Massimo Di Pierro escribió: > > Can you please open a pydal issue about this? > > On Friday, 21 August 2015 18:44:02 UTC-5, Jaime Sempere wrote: >> >> 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.
