What type of field are you ordering by? This should work. Can Robin confirm?
Massimo On Jun 7, 11:23 am, Tito Garrido <titogarr...@gmail.com> wrote: > Using update_indexes didn't work... I had to remove all "orderby"s from > "selects". > > Is it a bug? > > Thanks! > > Tito > > > > On Sun, Jun 7, 2009 at 11:18 AM, Tito Garrido <titogarr...@gmail.com> wrote: > > Thank you folks, > > > I'll try appcfg.py update_indexes myapp/ to test... localy it works > > perfectly. > > > I'll keep you in touch about it! > > > Thanks Again > > > Tito > > > On Sat, Jun 6, 2009 at 6:53 PM, Robin B <robi...@gmail.com> wrote: > > >> The easiest way to fix this is to exercise your app on the development > >> server, (use the query that needs that missing index) which will add > >> the missing index to the generated index.yaml. The next time you > >> update/deploy your index.yaml to production, GAE will 'build' the new > >> index which takes time. Until the new index is added, any query that > >> trys to use it will throw an exception. You can see the index > >> building progress if you login to appspot.com. > > >> The safest way to add a new index is to write tests that exercise your > >> app in development, so index.yaml is autogenerated. Then deploy your > >> indexes with: > > >> appcfg.py update_indexes myapp/ > > >>http://code.google.com/appengine/docs/python/tools/uploadinganapp.htm... > > >> Once you see that the indexes are all 'serving' (built), then deploy > >> your app code with: > > >> appcfg.py update myapp/ > > >> Robin > > >> On Jun 6, 1:46 pm, Hans Donner <hans.don...@pobox.com> wrote: > >> > running locally works fine? > >> > did you check index.yaml? > > >> > On Sat, Jun 6, 2009 at 8:41 PM, Tito Garrido<titogarr...@gmail.com> > >> wrote: > >> > > Hi Folks, > > >> > > I've been receiving Index Errors when I try to run my web2py on gae > >> > > application: > > >> > > 189.115.246.131 - - [06/Jun/2009:11:37:39 -0700] "GET / HTTP/1.1" 500 > >> 251 > >> > > " > >>http://appengine.google.com/deployment?&app_id=tito-garrido&version_i..."; > >> > > "Mozilla/5.0 (Windows; U; Windows NT 5.1; pt-BR; rv:1.9.0.10) > >> > > Gecko/2009042316 Firefox/3.0.10,gzip(gfe)" > >> > > "1.latest.tito-garrido.appspot.com" > > >> > > W 06-06 11:37AM 38.505 > > >> > > no file locking > > >> > > D 06-06 11:37AM 39.045 > > >> > > no sqlite3 or mysqlite2.dbapi2 driver > > >> > > D 06-06 11:37AM 39.047 > > >> > > no MySQLdb driver > > >> > > D 06-06 11:37AM 39.049 > > >> > > no psycopg2 driver > > >> > > D 06-06 11:37AM 39.051 > > >> > > no cx_Oracle driver > > >> > > D 06-06 11:37AM 39.054 > > >> > > no MSSQL/DB2 driver > > >> > > D 06-06 11:37AM 39.058 > > >> > > no kinterbasdb driver > > >> > > D 06-06 11:37AM 39.062 > > >> > > no informixdb driver > > >> > > D 06-06 11:37AM 39.065 > > >> > > no zxJDBC driver > > >> > > W 06-06 11:37AM 39.091 > > >> > > unable to import dbhash > > >> > > W 06-06 11:37AM 39.181 > > >> > > unable to import wsgiserver > > >> > > E 06-06 11:37AM 39.420 > > >> > > Traceback (most recent call last): > >> > > File > > >> "/base/data/home/apps/tito-garrido/1.334017845210245114/gluon/restricted.py", > >> > > line 107, in restricted > >> > > exec ccode in environment > > >> > > File > > >> "/base/data/home/apps/tito-garrido/1.334017845210245114/applications/init/controllers/default.py:index", > >> > > line 144, in <module> > >> > > File > > >> "/base/data/home/apps/tito-garrido/1.334017845210245114/gluon/globals.py", > >> > > line 97, in <lambda> > > >> > > self._caller = lambda f: f() > >> > > File > > >> "/base/data/home/apps/tito-garrido/1.334017845210245114/applications/init/controllers/default.py:index", > >> > > line 58, in index > >> > > File > > >> "/base/data/home/apps/tito-garrido/1.334017845210245114/gluon/contrib/gql.py", > >> > > line 736, in select > > >> > > for item in items: > >> > > File > >> "/base/python_lib/versions/1/google/appengine/ext/db/__init__.py", > >> > > line 1372, in __iter__ > >> > > return self.run() > >> > > File > >> "/base/python_lib/versions/1/google/appengine/ext/db/__init__.py", > >> > > line 1360, in run > > >> > > iterator = self._get_query().Run() > >> > > File > >> "/base/python_lib/versions/1/google/appengine/api/datastore.py", line > >> > > 886, in Run > >> > > return self._Run() > >> > > File > >> "/base/python_lib/versions/1/google/appengine/api/datastore.py", line > >> > > 913, in _Run > > >> > > str(exc) + '\nThis query needs this index:\n' + yaml) > >> > > NeedIndexError: no matching index found. > >> > > This query needs this index: > >> > > - kind: product > >> > > properties: > >> > > - name: featured > >> > > - name: name > > >> > > direction: desc > > >> > > Anybody has a clue of what should I do to fix it? > > >> > > Thanks! > > >> > > Tito > > >> > > -- > > >> > > Linux User #387870 > >> > > .........____ > >> > > .... _/_õ|__| > >> > > ..º[ .-.___.-._| . . . . > >> > > .__( o)__( o).:_______ > >> > > Sent from Salvador, BA, Brazil > > > -- > > > Linux User #387870 > > .........____ > > .... _/_õ|__| > > ..º[ .-.___.-._| . . . . > > .__( o)__( o).:_______ > > -- > > Linux User #387870 > .........____ > .... _/_õ|__| > ..º[ .-.___.-._| . . . . > .__( o)__( o).:_______ > Sent from Salvador, BA, Brazil --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
