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.
