No problem. We are also learning GAE as we go, it is changing fast and
so is web2py.

On Jan 2, 11:07 am, Chad <chad.mic...@gmail.com> wrote:
> Thanks, that solved it. Also, thanks for the quick responses, I am
> just learning the framework so getting feedback so fast was awesome.
>
> On Jan 2, 12:36 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > 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,
>
> ...
>
> read more »

--

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.


Reply via email to