Whenever any query in run on GAE which involves usage of two or more properties, App engine forces you to define the index for those properties of the entity type. You need to modify the index.yaml file to achieve this.
Take a look at this: https://developers.google.com/appengine/docs/python/config/indexconfig I hope it clears your confusion. On Saturday, June 23, 2012 2:59:33 AM UTC+5:30, mike haberman wrote: > > New to web2py and GAE. But with a very simple example, I > am unable to use web2py admin interface to modify the database > > Using the admin interface for an application, > I can navigate to 'Administrative Interface' --> Applications --> (blog) > Edit --> Models --> database administration > > I can update/insert on any of the auth_ tables > but I get the following error on any table that I create within models for > web2py > > <class 'google.appengine.api.datastore_errors.NeedIndexError'> no matching > index found. > The suggested index for this query is: - kind: auth_user properties: - > name: first_name - name: last_name > > Is there something I need to do to the model definition to avoid this > error ? > > (Also when trying to create a new entity via GAE's Datastore viewer, some > fields are missing > even though it displays all the fields for each entity from a query. Is > there something by default that > makes some fields not show up?) > > > thanks > > mike > >