So I suppose the JOIN in the puppy tutorial is the "friendship" declaration.
What is the recommended pattern to "simulate" a JOIN in order to run on the GAE? Thanks Miguel On Fri, Dec 26, 2008 at 2:54 PM, mdipierro <mdipie...@cs.depaul.edu> wrote: > > you cannot do JOINS on GAE. The puppy tutorial does a JOIN. > > > > On Dec 26, 2:11 pm, Miguel <goncalvesmig...@gmail.com> wrote: > > Hi > > > > I installed web2py and the T2 plugin. I also when through the puppies > > tutorial and everything works fine locally when I am running web2py > > server. > > > > However when I run GAE locally (dev_appserver.py) I get the following > > error: > > Internal Error > > Ticket Issued: Unknown > > > > What am I missing? > > Bellow is the command line log of GAE: > > > > G:\google_appengine>dev_appserver.py crbox > > INFO 2008-12-26 19:57:44,191 appcfg.py] Server: > > appengine.google.com > > INFO 2008-12-26 19:57:44,216 appcfg.py] Checking for updates to > > the SDK. > > INFO 2008-12-26 19:57:44,476 appcfg.py] The SDK is up to date. > > WARNING 2008-12-26 19:57:44,726 dev_appserver.py] Could not > > initialize images API; you are likely missing the Python "PIL" module > > . ImportError: No module named PIL > > INFO 2008-12-26 19:57:45,052 dev_appserver_main.py] Running > > application crbox on port 8080:http://localhost:8080 > > WARNING 2008-12-26 20:03:13,944 portalocker.py] no file locking > > WARNING 2008-12-26 20:03:19,069 cache.py] unable to import dbhash > > WARNING 2008-12-26 20:03:20,520 compileapp.py] unable to import > > py_compile > > WARNING 2008-12-26 20:03:22,191 main.py] unable to import wsgiserver > > INFO 2008-12-26 20:03:28,384 dev_appserver.py] "GET / HTTP/1.1" > > 303 - > > INFO 2008-12-26 20:03:28,684 dev_appserver_index.py] Updating G: > > \google_appengine\crbox\index.yaml > > WARNING 2008-12-26 20:03:28,885 cache.py] no cache.disk > > ERROR 2008-12-26 20:03:30,119 main.py] Traceback (most recent call > > last): > > File "G:\google_appengine\crbox\gluon\restricted.py", line 62, in > > restricted > > exec ccode in environment > > File "G:\google_appengine\crbox\applications\welcome/models/db.py", > > line 60, in <module> > > friendship=db.t2_person.id==db.link.person_id and > > db.company.id==db.link.company_id > > File "G:\google_appengine\crbox\gluon\contrib\gql.py", line 205, in > > __eq__ > > def __eq__(self,value): return SQLQuery(self,'=',value) > > File "G:\google_appengine\crbox\gluon\contrib\gql.py", line 321, in > > __init__ > > raise SyntaxError, 'SQLQuery: right side of filter must be a value > > or entity' > > SyntaxError: SQLQuery: right side of filter must be a value or entity > > > > INFO 2008-12-26 20:03:30,354 dev_appserver.py] "GET /welcome/ > > default/index HTTP/1.1" 200 - > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---