I think the problem is the following: You need to run the program with dev_appserver, register, login and create some posts and some comments. As you use it locally, dev_appserver will write index.yaml for you and list the indices you need. After you have fully used the app locally then you upload it on GAE and gae will find the list of indices in index.yaml.
On Jan 1, 11:06 pm, Chad <chad.mic...@gmail.com> wrote: > hmmm. The GAE logs say I am missing an index. > > Below are a couple of log entries. > > In FILE: /base/data/home/apps/mutantacct4/1.338874278338316080/ > applications/blog/controllers/default.py > > Traceback (most recent call last): > File "/base/data/home/apps/mutantacct4/1.338874278338316080/gluon/ > restricted.py", line 173, in restricted > exec ccode in environment > File "/base/data/home/apps/mutantacct4/1.338874278338316080/ > applications/blog/controllers/default.py:create_post", line 64, in > <module> > File "/base/data/home/apps/mutantacct4/1.338874278338316080/gluon/ > globals.py", line 96, in <lambda> > self._caller = lambda f: f() > File "/base/data/home/apps/mutantacct4/1.338874278338316080/ > applications/blog/controllers/default.py:create_post", line 26, in > create_post > File "/base/data/home/apps/mutantacct4/1.338874278338316080/gluon/ > tools.py", line 2114, in create > deletable=False, > File "/base/data/home/apps/mutantacct4/1.338874278338316080/gluon/ > tools.py", line 2052, in update > upload=self.settings.download_url, > File "/base/data/home/apps/mutantacct4/1.338874278338316080/gluon/ > sqlhtml.py", line 618, in __init__ > inp = self.widgets.options.widget(field, default) > File "/base/data/home/apps/mutantacct4/1.338874278338316080/gluon/ > sqlhtml.py", line 194, in widget > options = requires0.options() > File "/base/data/home/apps/mutantacct4/1.338874278338316080/gluon/ > validators.py", line 344, in options > self.build_set() > File "/base/data/home/apps/mutantacct4/1.338874278338316080/gluon/ > validators.py", line 339, in build_set > self.dbset.select(self.dbset._db[self.ktable].ALL, **dd) > File "/base/data/home/apps/mutantacct4/1.338874278338316080/gluon/ > contrib/gql.py", line 660, in select > for item in items: > File "/base/python_lib/versions/1/google/appengine/ext/db/ > __init__.py", line 1527, in __iter__ > return self.run() > File "/base/python_lib/versions/1/google/appengine/ext/db/ > __init__.py", line 1514, in run > iterator = raw_query.Run() > File "/base/python_lib/versions/1/google/appengine/api/ > datastore.py", line 997, in Run > return self._Run() > File "/base/python_lib/versions/1/google/appengine/api/ > datastore.py", line 1021, in _Run > str(exc) + '\nThis query needs this index:\n' + yaml) > NeedIndexError: no matching index found. > This query needs this index: > - kind: auth_user > properties: > - name: first_name > - name: last_name > > 76.84.55.217 - chad.michel [01/Jan/2010:19:20:05 -0800] "GET /blog/ > appadmin/insert/db/post HTTP/1.1" 500 391 "https:// > 1.latest.mutantacct4.appspot.com/blog/appadmin" "Mozilla/4.0 > (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET > CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC > 6.0; .NET4.0C; .NET4.0E),gzip(gfe)" > "1.latest.mutantacct4.appspot.com"E 01-01 07:20PM 05.980 > In FILE: /base/data/home/apps/mutantacct4/1.338872944811925236/ > applications/blog/controllers/appadmin.py > > Traceback (most recent call last): > File "/base/data/home/apps/mutantacct4/1.338872944811925236/gluon/ > restricted.py", line 173, in restricted > exec ccode in environment > File "/base/data/home/apps/mutantacct4/1.338872944811925236/ > applications/blog/controllers/appadmin.py:insert", line 304, in > <module> > File "/base/data/home/apps/mutantacct4/1.338872944811925236/gluon/ > globals.py", line 96, in <lambda> > self._caller = lambda f: f() > File "/base/data/home/apps/mutantacct4/1.338872944811925236/ > applications/blog/controllers/appadmin.py:insert", line 123, in insert > File "/base/data/home/apps/mutantacct4/1.338872944811925236/gluon/ > sqlhtml.py", line 618, in __init__ > inp = self.widgets.options.widget(field, default) > File "/base/data/home/apps/mutantacct4/1.338872944811925236/gluon/ > sqlhtml.py", line 194, in widget > options = requires0.options() > File "/base/data/home/apps/mutantacct4/1.338872944811925236/gluon/ > validators.py", line 344, in options > self.build_set() > File "/base/data/home/apps/mutantacct4/1.338872944811925236/gluon/ > validators.py", line 339, in build_set > self.dbset.select(self.dbset._db[self.ktable].ALL, **dd) > File "/base/data/home/apps/mutantacct4/1.338872944811925236/gluon/ > contrib/gql.py", line 660, in select > for item in items: > File "/base/python_lib/versions/1/google/appengine/ext/db/ > __init__.py", line 1527, in __iter__ > return self.run() > File "/base/python_lib/versions/1/google/appengine/ext/db/ > __init__.py", line 1514, in run > iterator = raw_query.Run() > File "/base/python_lib/versions/1/google/appengine/api/ > datastore.py", line 997, in Run > return self._Run() > File "/base/python_lib/versions/1/google/appengine/api/ > datastore.py", line 1021, in _Run > str(exc) + '\nThis query needs this index:\n' + yaml) > NeedIndexError: no matching index found. > This query needs this index: > - kind: auth_user > properties: > - name: first_name > - name: last_name > > On Jan 1, 10:25 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > What does the GAE log say, as opposed to the web2py ticket? > > Odd it runs on dev_appserver and not GAE. > > Could it be "post" is a reserved keyword and cannot be used as a mode > > name? > > If that is the case the docs do not say it. > > > massimo > > > On Jan 1, 10:09 pm, Chad <chad.mic...@gmail.com> wrote: > > > > Also ... > > > when running GAE locally the datastore works, I can create posts using > > > the create_post action. When actually running in GAE it doesn't work, > > > I receive a "Internal Error" when trying to view the create_post > > > action. > > > > --- begin ticket data --- > > > > value: (dp0 S'output' p1 S'' p2 sS'layer' p3 S'/base/data/home/apps/ > > > mutantacct4/1.338874278338316080/applications/blog/controllers/ > > > default.py' p4 sS'code' p5 S'<code object <module> at > > > 0x7c93e3924ed8d848, file "/base/data/home/apps/ > > > mutantacct4/1.338874278338316080/applications/blog/controllers/ > > > default.py:create_post", line 11>' p6 sS'traceback' p7 S'Traceback > > > (most recent call last):\n File "/base/data/home/apps/ > > > mutantacct4/1.338874278338316080/gluon/restricted.py", line 173, in > > > restricted\n exec ccode in environment\n File "/base/data/home/apps/ > > > mutantacct4/1.338874278338316080/applications/blog/controllers/ > > > default.py:create_post", line 64, in <module>\n File "/base/data/home/ > > > apps/mutantacct4/1.338874278338316080/gluon/globals.py", line 96, in > > > <lambda>\n self._caller = lambda f: f()\n File "/base/data/home/apps/ > > > mutantacct4/1.338874278338316080/applications/blog/controllers/ > > > default.py:create_post", line 26, in create_post\n File "/base/data/ > > > home/apps/mutantacct4/1.338874278338316... > > > > --- end ticket data --- > > > > Line 26 is > > > form = crud.create(db.post) > > > > On Jan 1, 9:23 pm, Chad <chad.mic...@gmail.com> wrote: > > > > > I can't create using appadmin either. When I click on the "insert new > > > > post" link I receive an internal error. "insert new comment" does the > > > > same thing. > > > > > --- begin ticket data --- > > > > > ticket_data > > > > value: (dp0 S'output' p1 S'' p2 sS'layer' p3 S'/base/data/home/apps/ > > > > mutantacct4/1.338872944811925236/applications/blog/controllers/ > > > > appadmin.py' p4 sS'code' p5 S'<code object <module> at > > > > 0x803e47c107c6d768, file "/base/data/home/apps/ > > > > mutantacct4/1.338872944811925236/applications/blog/controllers/ > > > > appadmin.py:insert", line 7>' p6 sS'traceback' p7 S'Traceback (most > > > > recent call last):\n File "/base/data/home/apps/ > > > > mutantacct4/1.338872944811925236/gluon/restricted.py", line 173, in > > > > restricted\n exec ccode in environment\n File "/base/data/home/apps/ > > > > mutantacct4/1.338872944811925236/applications/blog/controllers/ > > > > appadmin.py:insert", line 304, in <module>\n File "/base/data/home/ > > > > apps/mutantacct4/1.338872944811925236/gluon/globals.py", line 96, in > > > > <lambda>\n self._caller = lambda f: f()\n File "/base/data/home/apps/ > > > > mutantacct4/1.338872944811925236/applications/blog/controllers/ > > > > appadmin.py:insert", line 123, in insert\n File "/base/data/home/apps/ > > > > mutantacct4/1.338872944811925236/gluon/sqlht... > > > > type: text > > > > > --- end ticket data --- > > > > > On Jan 1, 9:06 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > > > Normally the datastore does not create tables until you put data in > > > > > them. > > > > > Can you create posts using? > > > > > >http://..../yourapp/appadmin > > > > > > I do not see anything wrong in this line > > > > > > form = crud.create(db.post) > > > > > > Can you tells us what errors you get from GAE? > > > > > > Massimo > > > > > > On Jan 1, 8:45 pm, Chad <chad.mic...@gmail.com> wrote: > > > > > > > I'm really enjoying learning web2py, but I am running into problems > > > > > > when using it with Google App Engine. > > > > > > > I followed the example > > > > > > athttp://www.web2py.com/AlterEgo/default/show/253 > > > > > > which works fine locally, but when trying to run in GAE I can't seem > > > > > > to create posts. When I look at the entities using the Datastore > > > > > > Viewer I do not see a posts entitiy option. I see web2py_* tables > > > > > > and > > > > > > auth_* tables. > > > > > > > I tried to add an action to create posts but I receive an error when > > > > > > running it in GAE (works when running locally). I receive an error > > > > > > on > > > > > > the line that has db.posts (first line of function). > > > > > > > --- begin code --- > > > > > > > def create_post(): > > > > > > form = crud.create(db.post) > > > > > > return dict(form=form) > > > > > > > --- end code --- > > > > > > > As a side note how does one create an instance of a database model? > > > > > > I > > > > > > wanted to create an action that would just quickly create an > > > > > > instance > > > > > > of post and save it with predetermined values, but I couldn't figure > > > > > > out how to do it.- Hide quoted text - > > > > > > - Show quoted text -- Hide quoted text - > > > > > - Show quoted text -- Hide quoted text - > > > - Show quoted text - > > -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@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.
