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.html#Updating_Indexes > > 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).:_______ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
