[web2py] Re: GAE deployment problem

Still can't figure it out, I think I doing something wrong with GAE but I can't figure out what it is, I've tried searching for it but can't find any solutions. I've got to the point where it uploads a blank app that seems to just display 'Hello world' on the front page and nothing else (which is

[web2py] Re: GAE deployment problem

Oh I didn't know GAE had logs too whoops. It gives me the warning: File referenced by handler not found: gaehandler.py Any idea what that means? On Aug 26, 1:58 pm, Massimo Di Pierro wrote: > Check the GAE logs on the dashboard. > > On Aug 25, 10:32 pm, Jarrod Cugley wrote: > > > > > > > > >

[web2py] Re: GAE deployment problem

Check the GAE logs on the dashboard. On Aug 25, 10:32 pm, Jarrod Cugley wrote: > So I've created a basic website that works on the web2py server, so I > wanted to test it on the GAE, these are my steps so far: > > 1. read:http://web2py.com/book/default/chapter/11#Google-App-Engine > 2. copied the

Re: [web2py] Re: GAE questions...

On Sunday, August 21, 2011 5:06:11 AM UTC-4, sebastian wrote: > > thanks cfh, > > that's great... web2py now supports GAE native lists !!! > > any idea if it is possible to use Expanto and PolyModel classes ? > > PolyModel: https://groups.google.com/d/msg/web2py/OsNUPL9IwH4/CmsuUIuX34kJ

Re: [web2py] Re: GAE questions...

i can't remember for sure, but i thought the DAL made them all as expando classes given that web2py supports multiple db backends where expando and polymodel would not be supported there is no direct support for that. you can always redefine the table though and the no-op migration will ha

Re: [web2py] Re: GAE questions...

thanks cfh, that's great... web2py now supports GAE native lists !!! any idea if it is possible to use Expanto and PolyModel classes ? On Sat, Aug 20, 2011 at 7:07 PM, howesc wrote: > i use list fields (which now implemented using the GAE native list property > and string list property) liber

[web2py] Re: GAE questions...

i use list fields (which now implemented using the GAE native list property and string list property) liberally. in places where i wish i had a join, i tend to use the web2py syntax that does the subquery for me: item.user.name where item is a Row, with a field user that is a reference to the

[web2py] Re: GAE deployment issue on Ubuntu

I just decided to use the appcfg.py tool to deploy my app and it was successful. Anyone who has had success deploying an app from inside web2py to GAE should comment. thanks On Aug 14, 12:14 am, Pystar wrote: > Hi, > I am running Web2py 1.98.2 on Ubuntu 11.04, when I try to deploy my > applicatio

[web2py] Re: GAE Question

I decided to upgrade to the latest web2py version 1.98.2, then using the GAE app launcher for windows (version 1.5.2) I deployed it to the google server. when I try to go to the url.appspot.com then I got a server error 500. I believe there's currently an issue with GAE at google's side. Sever

[web2py] Re: GAE Question

I decided to upgrade to the latest web2py version 1.98.2, then using the GAE app launcher for windows (version 1.5.2) I deployed it to the google server. when I try to go to the url .appspot.com then I got a server error 500. then I try to run locally on my machine (http://127.0.0.1:9000/admin/def

[web2py] Re: GAE and atomic inserts: DAL enhancement?

i opened ticket 350: http://code.google.com/p/web2py/issues/detail?id=350 i'm happy to do some work here and/or help test things.

[web2py] Re: GAE and atomic inserts: DAL enhancement?

Please open a ticket. This should be doable without too much work. On Jul 26, 9:11 pm, howesc wrote: > Hi GAE web2py users, > > I ran into an issue today where i need to have atomic inserts into a GAE > table.  in a normal database you can do a read/write lock and check if a row > exists before y

[web2py] Re: GAE users - SDK upgrade breaks your test database

i was wrong, the above does not quite work. but our friends from the app engine team have told us: Another way to deal with it is to use the --default_partition="" flag rather than using an older version of the sdk. http://code.google.com/appengine/forum/?place=topic%2Fgoogle-appengine%2FkJGP

[web2py] Re: GAE deploy only on UNIX Systems?

The web interface to GAE deployment yes it only works on Unix systems. But the fact is whether on windows or not, you still need to download the google sdk and run dev_appserver. The web2py deployment page would only save you form typing "appcfg.py deploy web2py" and on windows you do not have to d

Re: [web2py] Re: GAE taskqueue with Web2py 1.95.1

ahh, yes i've been playing that game with my URL calls as well. i'll keep an eye out for places in my code that do the same. thanks! cfh

Re: [web2py] Re: GAE taskqueue with Web2py 1.95.1

it was this definition: auth.messages.verify_email = request.env.http_host+str(URL(r=request,c='default',f='user', args=['verify_email']))+'/%(key)s to verify your email' which I had changed from: auth.messages.verify_email = request.env.http_host+URL(r=request,c='default',f='user', args=['verif

Re: [web2py] Re: GAE taskqueue with Web2py 1.95.1

i'm curious about what that bug in db.py was that broke the dev_appserver. if we ever get to the point where development and production environments are exactly the same, think about how many QA jobs would be lost! ;) cfh

Re: [web2py] Re: GAE taskqueue with Web2py 1.95.1

ah ha! a bug in my app's db.py was preventing dev_appserver.py from calling my task url... sensitive chap. these subtly differences between web2py, dev_appserver and GAE are frustrating - I'll be happier when it's all in the cloud :) On 2 June 2011 15:28, Carl Roach wrote: > thanks for the feedb

Re: [web2py] Re: GAE taskqueue with Web2py 1.95.1

thanks for the feedback. my task is called correctly when I manually "Run" it from http://localhost:8080/_ah/admin/tasks?queue=default I've given the task a name (to make it unique) using a mixture of a-z0-9- The fact that dev_appserver is failing to call the URL correctly / URL is failing to cal

[web2py] Re: GAE taskqueue with Web2py 1.95.1

taskqueue is no longer a labs feature, but a trunk feature on GAE, so use: from google.appengine.api import taskqueue can you try and load the logged URL by hand in the browser? It should follow the same URL processing and i have not had to add special routes.py or app.yaml to make it work. c

[web2py] Re: GAE for Dummies - again

Martin, i'm a little confused here, i think you are mixing the SDK with the production GAE. Yes, that error shows when deploying, but it's in reference to the fact that for the code upload to GAE you don't have SSL, nothing to do with ssl on GAE. For what it's worth, https is available on app

[web2py] Re: GAE and MySQL

"any suggestion for a free hosting to fully use web2py??? " Have you looked at Amazon EC2 any? You get a year free of a Micro computing instance. That would be a good 'free' hosting alternative. You'll have to set up your server on your own. Plenty of good advice in the web2py book though. On May

[web2py] Re: GAE and MySQL

GAE restricts outbound connections except using GAE api, so I doubt the pymysql driver will work. Moreover it would be very slow because it will be unable to maintain state. Massimo On May 29, 4:55 pm, ra3don wrote: > I think this should be possible. > > You would just have to do: > mysql://us

[web2py] Re: GAE and MySQL

I think this should be possible. You would just have to do: mysql://username:password@IP_OF_MYSQL_SERVER/DB_NAME I'd also imagine you would have to allow remote users in your MySQL database. If i'm not mistaken, the default is to allow only local users in, you will have to try your luck. If you

[web2py] Re: gae list type field

Docs are wrong but we can make this work. I just made a change to trunk to fix that particular error. Please try again, there may be other errors related to this. On May 28, 3:30 pm, Rip Ryness wrote: > This syntax: > Field('list_tags',type=gae.StringListProperty(),widget=str_list.widget), > > C

[web2py] Re: GAE for Dummies

My application is called rtPlanB, In my yaml file I had specified it with the same capatilisation. Strangely it works when I change it to all lower case.

Re: [web2py] Re: GAE for Dummies

Thanks for your reply, I have double checked the app.yaml and the app name matches exactly that of the application in web2py I will just check that the softlinks appear correct as per the slice(again) On 18/05/11 23:09, howesc wrote: i have never seen this error myself, but it seems like perh

[web2py] Re: GAE caching

actually i would recommend that this be removed from web2py. Ikai Lan (app engine system developer at google) says they can detect those dummy requests and punish apps that do that (was chatting with him at a conference last fall). i would instead pay the modest $9 a month for "always on". or

[web2py] Re: GAE for Dummies

i have never seen this error myself, but it seems like perhaps a type in your app.yaml file?

[web2py] Re: GAE deployment routing to welcome app, not my own app.

Thanks! Used router and changed default app to kiekjs. On Apr 27, 9:33 pm, Jonathan Lundell wrote: > On Apr 27, 2011, at 12:27 PM, Johan wrote: > > > > > > > > > > > > > Hi, > > > I'm trying to deploy my app on GAE, but I don't know how to configure > > the app.yaml so that the request is route

Re: [web2py] Re: gae error

yes, i use python 2.6, i'll try your adviced to use python 2.5 thank you so much and best regards, steve van christie On Mon, Apr 18, 2011 at 5:34 AM, howesc wrote: > i didn't look at the slicebut you are using python 2.6. GAE does not > like python 2.6. it's old skool and likes python 2

[web2py] Re: gae error

i didn't look at the slicebut you are using python 2.6. GAE does not like python 2.6. it's old skool and likes python 2.5 check that you both have python 2.5 installed, and that you are invoking dev_appserver.py with python2.5 cfh

[web2py] Re: GAE inconsistent on server and localhost

On 17 Kwi, 00:36, howesc wrote: > can you post the error you get from the GAE console?  GAE dev server is much > more consistent than it was a year ago, but there are still some > differences. > > cfh As I said on the dev server it runs just fine. The error only shows up in the cloud. On 17 Kwi,

[web2py] Re: GAE inconsistent on server and localhost

On 17 Kwi, 00:36, howesc wrote: > can you post the error you get from the GAE console?  GAE dev server is much > more consistent than it was a year ago, but there are still some > differences. > > cfh I'd like to but this generates a ticket and so the error is not shown by GAE. Instead it gets st

[web2py] Re: GAE inconsistent on server and localhost

Check the logs in the GAE page for your app. Top one should be the latest. On Apr 17, 4:18 am, Karol Marcjan wrote: > In my controller I've got a following action defined: > > @auth.requires_login() > def chapter(): >     chapter_id = int(request.args[0]) > >     chapter = db.chapter[chapter_id]

[web2py] Re: GAE inconsistent on server and localhost

can you post the error you get from the GAE console? GAE dev server is much more consistent than it was a year ago, but there are still some differences. cfh

[web2py] Re: GAE SDK and site-packages

Please ignore this, restarting the dev_appserver created the .pyc file in site-packages and fixed the problem. On Apr 16, 10:48 pm, Richard wrote: > I have downloaded the current GAE SDK (v 1.4.3) and find that it > doesn't seem to recognise a module in the site-packages folder on one > PC (pytho

[web2py] Re: GAE inconsistent on server and localhost

Couple things to try: @auth.requires_login() def chapter(): chapter_id = int(request.args[0]) chapter = db.chapter(chapter_id) #() instead of [] book = chapter.book chapter_count = db(db.chapter.book == book.id).count() return dict(chapter=chapter, book=book, chapter_coun

[web2py] Re: GAE internal error unknown

Hi Arble Samong Thank you very much. Actually the application does not run even on web2py server. The appengine log prove how stupid i am. It is a simple progam miss 'undefined name' Thank you, again. On 4月5日, 午後1:49, Arbie Samong wrote: > In appengine.google.com you have your dashboard, and o

[web2py] Re: GAE internal error unknown

In appengine.google.com you have your dashboard, and one of the menu choices on the left would be the Logs. Click on that, and the first entry should be the latest. You'll definitely see an error message there. Regards, Arbie On Apr 5, 12:00 pm, kawate wrote: > Version 1.94.6 (2011-03-27 18:20:3

[web2py] Re: GAE 1.4.3 has support for mysql and sqlite?

This is not a an April's Fool but I cannot say much more yet. On Apr 2, 4:03 pm, Carl wrote: > As you're replying to this on April 2nd I guess it's not an AFool :) > > Excellent news for the Web2py platform; I look forward to the full > story in due course. > > On Apr 2, 4:47 pm, Massimo Di Pierr

[web2py] Re: GAE 1.4.3 has support for mysql and sqlite?

As you're replying to this on April 2nd I guess it's not an AFool :) Excellent news for the Web2py platform; I look forward to the full story in due course. On Apr 2, 4:47 pm, Massimo Di Pierro wrote: > I guess this partially releases me from the Non Disclosure Agreement. > > I have been testin

[web2py] Re: GAE 1.4.3 has support for mysql and sqlite?

I guess this partially releases me from the Non Disclosure Agreement. I have been testing this since December under contract with Google. I have a web2py version that runs on GAE with MySQL. It supports MySQL and the Datastore at the same time. Automatic migrations work too. I will release it as

Re: [web2py] Re: GAE 1.4.3 has support for mysql and sqlite?

From: https://groups.google.com/forum/#!topic/google-mysql-tools/Bc7P5SIRCVE/discussion [This message is being sent to the google-mysql-tools Google group, which has been inactive for a very long time. If you no lon

[web2py] Re: GAE 1.4.3 has support for mysql and sqlite?

haven't seen any news either. it's probably an indication that they are at least testing it. cfh

[web2py] Re: gae RFC

In the end the GAE SDK is a python module. We could just have a web2py admin button to download the latest one form the official repository. On Mar 17, 6:38 pm, Albert Abril wrote: > What about implements it as a plugin as Jonathan said? > It's a good idea and we don't have to download the extra

Re: [web2py] Re: gae RFC

What about implements it as a plugin as Jonathan said? It's a good idea and we don't have to download the extra 7Mb. On Fri, Mar 18, 2011 at 12:35 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > This is an excellent point. > > On Mar 17, 4:33 pm, howesc wrote: > > I use GAE a lot,

[web2py] Re: gae RFC

This is an excellent point. On Mar 17, 4:33 pm, howesc wrote: > I use GAE a lot, and the thing that worries me about bundling with web2py is > that when GAE updates they detect that your dev_appserver.py and appcfg.py > are running an out of date version.  so far they don't stop you from running

[web2py] Re: gae RFC

I use GAE a lot, and the thing that worries me about bundling with web2py is that when GAE updates they detect that your dev_appserver.py and appcfg.py are running an out of date version. so far they don't stop you from running the old version but they could. I would not want web2py to be brok

[web2py] Re: gae RFC

On this topic I am happy to go with the wisdom and overview of more experienced developers of this GREAT framework. The debates in these forums are excellent learning. My main hiccup with GAE has been the use of bigtable for images and document storage. Thanks to ( a few ) excellent posts and sl

[web2py] Re: gae RFC

I also lean towards GAE being separate. I'm already a bit nervous on what the impact is of GAE support in the core framework.

Re: [web2py] Re: gae RFC

Hi, I am new to web2py and have chosen it for the gae support. Obviously for someone like me building in the sdk would be very handy. However, there are obvious disadvantages too (size and release cycles are 2): Just wondering if instead of bundling the whole sdk into web2py the admin controller

Re: [web2py] Re: gae RFC

On Mar 16, 2011, at 7:09 PM, Kevin Ivarsen wrote: > I'm biased in that I don't do any GAE development, but even though it's > "only" 7MB, it seems like a big jump relative to the size of the current code > base. If you exclude the "examples" directory under applications, the web2py > source tree

[web2py] Re: gae RFC

I'm biased in that I don't do any GAE development, but even though it's "only" 7MB, it seems like a big jump relative to the size of the current code base. If you exclude the "examples" directory under applications, the web2py source tree comes in at about 5 megs. I really like the lightweight

[web2py] Re: gae RFC

If the user does not download the full SDK, we would not be supporting all the GAE functions (for example I removed the bulk upload APIs). Basically we would include dev_appserver and ability to deploy. We would have to upgrade when/if it breaks. On Mar 16, 6:36 pm, Martín Mulone wrote: > +1. No

[web2py] Re: GAE and cursors

i have not used cursors directly. instead i use the DAL and sort on timestamp usually. when i complete the task, i post a new task the the queue with the last processed timestamp as an argument. Note that you will still have to deal with items that have a duplicate timestamp, but i have been

[web2py] Re: GAE support, specifically Reddish

Ah, that makes perfect sense. Thanks for your help.

[web2py] Re: GAE support, specifically Reddish

Reddish is really old, had some bugs and were never fixed. I have been rewriting it and I will post it eventually. Massimo On Feb 17, 7:37 am, Paul Clarke wrote: > I'm interested using web2py on GAE for a few upcoming projects and > thought that I'd have a play with the Reddish appliance to get

[web2py] Re: GAE or EC2?

Forgot to mention this, it may be interesting for you: http://stackoverflow.com/questions/791447/windows-azure-vs-amazon-ec2-vs-google-app-engine

[web2py] Re: GAE or EC2?

Hi James Here are a few personal opinions, (although my assumptions may be wrong or out of date): GAE 1. web2py targets the GAE platform and a lot of effort is put into this brand of 'No-Sql'. The web2py lead developer has access to forthcoming enhancements and so it should function very well in

[web2py] Re: GAE database namespace

i agree with massimo about tickets matching app namespacei also agree that it might be hard for admin to know how to deal with that. if each app i have uses a different postgres db, how does admin know where to look? cfh

[web2py] Re: GAE database namespace

I feel the opposite. tickets should be in the namespace of the app. So the problem is how does admin know what the namespace should be? On Feb 14, 9:23 am, howesc wrote: > sounds like we would want tickets to automagically go to the same namespace > as admin.  though i must admit i don't use the

Re: [web2py] Re: GAE local running oddity

On Feb 14, 2011, at 7:28 AM, howesc wrote: > is this a new bug in the sys.path handling? it has not be a problem for me, > and i think i am using it as recently as 1.91.6. > > also, are you restarting GAE each time you change those files? GAE > dev_appserver caches a bunch of stuff. i find th

[web2py] Re: GAE local running oddity

is this a new bug in the sys.path handling? it has not be a problem for me, and i think i am using it as recently as 1.91.6. also, are you restarting GAE each time you change those files? GAE dev_appserver caches a bunch of stuff. i find that if i am editing any of the web2py core files, mod

Re: [web2py] Re: GAE database namespace

sounds like we would want tickets to automagically go to the same namespace as admin. though i must admit i don't use the ticket system on GAE, i just read the log messages from the console on localhost and from the "logs" like of the admin screen on production. namespaces are a new add, and p

[web2py] Re: GAE and sending email

I have also experienced problems with the reply to field. Some info here: http://code.google.com/p/googleappengine/issues/detail?id=2802 Also there are the restrictions on who you can set as the sender which you probably already know about: http://code.google.com/appengine/docs/python/mail/sendin

Re: [web2py] Re: GAE database namespace

On Feb 12, 2011, at 1:41 PM, Massimo Di Pierro wrote: > > Good point. This is a bug. The tickets must be in the same > namespace... Can you please open an issue on google code? Done. I'm listed as the owner, but unless the fix is simply to strip out the namespace (which worked for me), I'm not

[web2py] Re: GAE database namespace

Good point. This is a bug. The tickets must be in the same namespace... Can you please open an issue on google code? On Feb 12, 3:38 pm, Jonathan Lundell wrote: > I'm trying now to get the trunk running locally in the GAE local server, and > again getting tickets, and have a question about the G

[web2py] Re: GAE Query

if your domain is bob.com, you cannot map http://bob.com to GAE, but you can map http://www.bob.com to GAE. so you just have to manage your sub-domains properly. (yes, "www" is considered a sub-domain) cfh

[web2py] Re: GAE timeout when wsgihandler.py is missing

I went to remove wsgihandler.py to check the logs and reloaded the page, but the timeout issue wasn't showing up. I made some changes to the html files to make sure that the changes made it online, and it loaded quickly. Maybe the issue was on the GAE side? Either way, it looks like it's gone.

[web2py] Re: GAE Query

So if using GAE on a subdomain for a homepage would use redirect users to the subdomain? I think i am even more confused now1 On Feb 7, 4:57 pm, howesc wrote: > yes you have to set your GAE app on a subdomain.  but that is the *only* > supported configuration that i know of.  google does not allo

[web2py] Re: GAE Query

yes you have to set your GAE app on a subdomain. but that is the *only* supported configuration that i know of. google does not allow mapping of "naked domains" as they call it to a GAE app.

[web2py] Re: GAE timeout when wsgihandler.py is missing

I suggest checking the logs for any clues. Slow running often = exceptions are happening. On Feb 5, 6:12 pm, Charles Law wrote: > I am uploading an app to GAE. Through some experimentation I've found > that if I don't include wsgihandler.py, the app loads very slowly. It > feels like it's looking

[web2py] Re: GAE timeout when wsgihandler.py is missing

This is very odd. The file wsgihandler.py is never called is you start web2py with gaehandler.py (what is normal behavior on GAE). massimo On Feb 5, 5:12 pm, Charles Law wrote: > I am uploading an app to GAE. Through some experimentation I've found > that if I don't include wsgihandler.py, the a

[web2py] Re: GAE Query

I think I understand that. I have GAE on my primary domain, I have one sub domain with a very basic site that I was referring all traffic to before I was ready to deploy my web2py app. app.yaml is set to ignore all applications except my website app. routes.py is set to have my website app as the d

[web2py] Re: GAE Query

this depends on many factors including: * DNS config for the domain and sub-domains * app.yaml * routes.py if you have the GAE app on 1 subdomain, and other web services on another subdomain that is fine. if all traffic is going to the same sub-domain which is mapped to GAE, GAE will service

[web2py] Re: GAE only issue extra status info as text on top of page

sounds like you got it right. i have seen similar behavior on GAE with print statements. they seem to show in the console on dev, but in the browser on production. try using the logging package instead of print statements to avoid that problem. cfh

[web2py] Re: GAE only issue extra status info as text on top of page

I had left a print statement in the code that I was using to debug an issue. When I removed the print statement, the application ran fine on GAE. I do not know if this was the root cause, or if there was something about the deployment (used GAE SDK tool in both cases) Can anyone share why (as I

[web2py] Re: GAE belongs (how to map long list)

BELONGS works. ~BELONGS does not on GAE I think. On Jan 30, 1:51 pm, "Arun K.Rajeevan" wrote: > Oops, I made an assumption "it worked for me with python sdk for appengine > using dev_appserver.py" > > That was wrong. > > BELONGS is broken in gae. > db(~db.languages.id.belongs(db()._select(db.word

[web2py] Re: GAE belongs (how to map long list)

Oops, I made an assumption "it worked for me with python sdk for appengine using dev_appserver.py" That was wrong. BELONGS is broken in gae. db(~db.languages.id.belongs(db()._select(db.words.lang, distinct=True))).select() causes dev_appserver.py to print out File "/home/kra/Evolve/Works/Py

[web2py] Re: GAE belongs (how to map long list)

I know it's an old post Christian, but when time comes I need it to save me.

[web2py] Re: GAE belongs (how to map long list)

No it doesn't. I deployed application using belongs in GAE, because it worked for me with python sdk for appengine using dev_appserver.py But it didn't when I upload it to appengine. I lost two days wondering. Nothing is logged on appengine logs. Then I changed it to manually selecting each

[web2py] Re: GAE belongs (how to map long list)

I use belong on GAE quite frequently these days. Arun - you found an outdated post. :( christian

[web2py] Re: GAE belongs (how to map long list)

It is supported by DAL. It maps into OR on GAE. Is it not? On Jan 27, 3:29 pm, "Arun K.Rajeevan" wrote: > Hi, > > I know belongs is not supported on GAE > > Fromhttp://www.web2py.com/AlterEgo/default/show/248 > > *it's clear that we have to convert

[web2py] Re: GAE belongs (how to map long list)

I did it myself. Thanks

[web2py] Re: GAE Flow doesn't seems work. (fixed & closed)

Actually the problem was something I really do not expected. items.append(DIV(DIV(*[data[item]], _id = 'wrap'), _id = 'ui-tabs-'+str(i))) needed to be items.append(DIV(DIV([data[item]], _id = 'wrap'), _id = 'ui-tabs-'+str(i))) No star (*) needed!!!

[web2py] Re: GAE Flow doesn't seems work.

It's just that I didn't put entire code block here. This statement resides inside a for block as for i,item in enumerate(data.keys()): so clearly i and item are available in the scope (this code works well with rocket server and local dev_appserver.py and problem is only when I upload it to G

[web2py] Re: GAE Flow doesn't seems work.

I guess this solves the problem right? item and i are undefined. On Jan 25, 10:58 pm, "Arun K.Rajeevan" wrote: > PS: after selecting rows in the controller > there is one more statement > > result= rows if rows else 'No result'

[web2py] Re: GAE Flow doesn't seems work.

PS: after selecting rows in the controller there is one more statement result= rows if rows else 'No result'

[web2py] Re: GAE shows error

never mind, I got it working, by modifying candidate =db(db.words.word.lower()==trans_form.vars.word.lower())(db.words.lang==trans_form.vars.languages).select().first() to candidate = db(db.words.lang==trans_form.vars.languages).select().find(lambda x:x.word.lower()==trans_form.vars.word.low

[web2py] Re: GAE shows error

GAE does not allow this query: db.words.word.lower()==trans_form.vars.word.lower() In SQL this would be ... WHERE LOWER(words.word) = ' value of trans_form.vars.word.lower() ' but GAE has no LOWER. On Dec 31, 4:54 am, "Arun K.Rajeevan" wrote: > Once again my application runs fine on suppl

[web2py] Re: GAE shows error

I'm using Version 1.91.5 (2010-12-28 21:52:10)

[web2py] Re: GAE shows problem.

Thank you for suggestion. It worked in 1.89.x. But problem is resolved now. And for the benefit of others, I get past it by running *dev_appserver.py*with *-c* option. So, the data already there may be caused problem. I changed DB a little bit. -c option clears datastore.

[web2py] Re: GAE shows problem.

for now do this instead: db(db.languages).select(cache=(cache.ram,3600)).sort(lambda a: a.full)]* mind that unless you redefined cache.ram as GAE memcache the caching will not work. On Dec 23, 1:41 pm, "Arun K.Rajeevan" wrote: > see GAE error message. (it runs perfectly fine, if web2py run stan

[web2py] Re: GAE shows problem.

The problem is that the query is missing. Do you know if this worked in 1.89.x? On Dec 23, 1:41 pm, "Arun K.Rajeevan" wrote: > see GAE error message. (it runs perfectly fine, if web2py run stand alone) > And was running ok, till previos hour. > What I can track is *init/controllers/default.py:ind

[web2py] Re: GAE issue with !=

it works, and the != test that i tried also works. i wonder if it has to do with how i tested the constuction? my test was of a dynamic query built like: def build_query(field, op, value): """ Builds the web2py query object for a given field """ if op == 'equals': return field == value elif op ==

[web2py] Re: GAE issue with !=

Please give it one more try. On Dec 8, 5:42 pm, howesc wrote: > actually, not the same issue, different error, same line. :(

[web2py] Re: GAE issue with !=

actually, not the same issue, different error, same line. :(

[web2py] Re: GAE issue with !=

hmm, same issue: ERROR 2010-12-08 23:38:06,535 restricted.py:151] Traceback (most recent call last): File "/home/cfhowes/tools/web2py_src/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/cfhowes/tools/web2py_src/web2py/applications/pump/controllers/defaul

[web2py] Re: GAE issue with !=

Please try again. You do not need to copy dal.py over sql.py. As of yesterday they are the same in trunk. Massimo On Dec 8, 4:13 pm, howesc wrote: > i just pulled from trunk, copied dal.py to sql.py, and did not get past > logging in to my app to test for you. i got this error: > > ERROR 2010-12

<    1   2   3   4   5   6   >