Re: [web2py] Re: new setup-web2py-nginx-uwsgi-ubuntu.sh

2013-01-23 Thread paolo.vall...@gmail.com
Just tested, it works, I've already upgraded the production server too :-P I would suggest to add it (maybe as a comment) to the script. Thanks, Paolo 2013/1/22 Niphlod > maybe I have a fix . > Can you please test it ? > assuming an example of routes.py like > > myapp = dict(languages=['en', 'i

Re: [web2py] Re: new setup-web2py-nginx-uwsgi-ubuntu.sh

2013-01-23 Thread Niphlod
ok, I'll test it more @home and then add a commented section to the script PS: that site you posted . turn off response.optimize_js = 'inline' pleeease :P On Wednesday, January 23, 2013 11:19:34 AM UTC+1, Paolo valleri wrote: > > Just tested, it works, I've already upgraded the production se

[web2py] Possible bug in date format widget

2013-01-23 Thread António Ramos
Hello i my web2py_ajax.html i see var w2p_ajax_date_format = "{{=T('%Y-%m-%d')}}"; But in a sqlform.factory generated form if i select a day in the widget it pastes the date as 01-01-2013 ignoring the format however if i change the format to var w2p_ajax_date_format = "{{=T('%Y*/*%m*/*%d')}}"

[web2py] Saving language files

2013-01-23 Thread António Ramos
Hello I live in Portugal, and i have to edit my language files sometimes. After editing i have to scroll all way down to save the file. Can you place a "follow me" save button instead? Thank you António --

[web2py] Sqlform.smartgrid does not show link to uploaded file

2013-01-23 Thread António Ramos
Hello my code form=SQLFORM.factory(db.trabalhador,db.t_docs, submit_button="Gravar", fields=['nome','bi','ncart','ncartval','apt_medica','apt_medicaval','val_formacao','f_doc'], table_name='trabalhador') and in my view on of the fields "apt_medica" is an upload type field.

[web2py] Re: Possible bug in date format widget

2013-01-23 Thread Niphlod
check the source of your page (or print somewhere in it {{=T('%Y-%m-%d')}}). '%Y-%m-%d' is just a *placeholder *for the T operator: that T() translates whatever value it's assigned to the key '%Y-%m-%d' . that little line in web2py_ajax.html "passes" the *translated *value to the javascript

[web2py] Re: is bug? sqlform.factory

2013-01-23 Thread www.diazluis.com
thanks for the reply I understood the point of view. only had the doubt. I thought it could be a mistake. but at this point, is, that the matter be referred to the database. --

[web2py] Re: anyserver.py not working properly for gevent

2013-01-23 Thread Massimo Di Pierro
Thank you for bringing this up. It is a serious issue. I think I have fixed this in trunk in anyserver. Can you check my solution is acceptable? On Wednesday, 23 January 2013 01:09:48 UTC-6, JimK wrote: > > Since gluon.main and gluon.fileutils are being imported before > gevent's monkey.patch_al

[web2py] Re: Saving language files

2013-01-23 Thread Massimo Di Pierro
Please open a ticket about this. On Wednesday, 23 January 2013 05:33:45 UTC-6, Ramos wrote: > > Hello > > I live in Portugal, and i have to edit my language files sometimes. > > After editing i have to scroll all way down to > save the file. > > > Can you place a "follow m

[web2py] Re: SQLFORM.grid with multiple LEFT OUTER JOINs

2013-01-23 Thread Jim S
Just updated to the latest version and am still having this problem. To be specific, I can do this: query = (db.feedLoad.deliverOn==datetime.datetime.today())&(db.feedLoad. siteId==1) left = [db.feedOrder.on(db.feedLoad.feedLoadId==db.feedOrder.feedLoadId), db.feedOrderLine.on(db.feedOrder.fe

[web2py] Re: SQLFORM.grid with multiple LEFT OUTER JOINs

2013-01-23 Thread Jim S
Oh, and the problem is that the grid only displays the data from the primary table. The join 'works', but there is no data for the joined tables in the grid. -Jim On Wednesday, January 23, 2013 8:53:55 AM UTC-6, Jim S wrote: > > Just updated to the latest version and am still having this probl

[web2py] Re: SQLFORM.grid with multiple LEFT OUTER JOINs

2013-01-23 Thread Massimo Di Pierro
Which version? I thought we fixed this in trunk. On Wednesday, 23 January 2013 08:54:38 UTC-6, Jim S wrote: > > Oh, and the problem is that the grid only displays the data from the > primary table. The join 'works', but there is no data for the joined > tables in the grid. > > -Jim > > On Wedne

Re: [web2py] Re: SQLFORM.grid with multiple LEFT OUTER JOINs

2013-01-23 Thread Jim Steil
2.4.1-alpha.2+timestamp.2013.01.23.08:17:15 Just updated this morning. -Jim On Wed, Jan 23, 2013 at 8:55 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Which version? I thought we fixed this in trunk. > > > On Wednesday, 23 January 2013 08:54:38 UTC-6, Jim S wrote: >> >> Oh, and t

[web2py] Re: Re-enable admin interface

2013-01-23 Thread Wonton
About upload a packed project to the server without admin access I guess is ok just uploading via FTP the project (application) directory to web2py applications subdirectory, am I wright? On Tuesday, January 22, 2013 5:56:13 PM UTC+1, Wonton wrote: > > Thanks, I will try this. > > Anyway, is the

[web2py] Re: bug in smartgrid groupby

2013-01-23 Thread Mark
It is great to know. Thanks! On Tuesday, January 22, 2013 5:03:08 PM UTC-5, Massimo Di Pierro wrote: > > This this been fixed in trunk some time ago. > > On Friday, 18 January 2013 11:21:20 UTC-6, Mark wrote: >> >> For web2py 2.2.1. >> >> When I use groupby in smartgrid, the number of records foun

[web2py] Re: Grid with multiple left joins

2013-01-23 Thread Mark
I also hope this can be done. In sqlhtml.py, simply change following code: if left is not None: tablenames += db._adapter.tables(left) into: if left is not None: if isinstance(left, (list)): for l in left: tablenames +=

Re: [web2py] Re: anyserver.py not working properly for gevent

2013-01-23 Thread Jim Kellas
Yes, that looks good and my test passed successfully. Jim From: Massimo Di Pierro Reply-To: Date: Wednesday, January 23, 2013 6:48 AM To: Subject: [web2py] Re: anyserver.py not working properly for gevent Thank you for bringing this up. It is a serious issue. I think I have fixed this in

Re: [web2py] Re: new setup-web2py-nginx-uwsgi-ubuntu.sh

2013-01-23 Thread paolo.vall...@gmail.com
In the meanwhile I discovered that if you upload a file greater than 1M, I tried with a 1.5M, you will get a 413 error. In order to avoid this error for file not so big, I suggest you to add the directive *client_max_body_size *and to set it at something more 'common' for me few MB is already ok. s

[web2py] Re: Re-enable admin interface

2013-01-23 Thread Niphlod
yep. w2p files are just a tar.gz of the applications/theapp folder . On Wednesday, January 23, 2013 4:39:49 PM UTC+1, Wonton wrote: > > About upload a packed project to the server without admin access I guess > is ok just uploading via FTP the project (application) directory to web2py > applicat

Re: [web2py] Re: new setup-web2py-nginx-uwsgi-ubuntu.sh

2013-01-23 Thread niphlod
uhm. this is outside the scope of the location I mean... probably you'd like to turn on gzip too, but that is a feature to enable on nginx "main" conf, not in the "web2py" one Anyway, did you put this setting inside the file /etc/nginx/sites-available/web2py and it just works ok ? 2013/

Re: [web2py] Re: new setup-web2py-nginx-uwsgi-ubuntu.sh

2013-01-23 Thread paolo.vall...@gmail.com
yep, I've added it under the location / and it worked. You are right it might be placed in the main configuration, on the other hand today at work I was blocked because unable to upload files greaten than 1M. From my point of view we should at least mention it. For what concerns gzip is that on ubu

[web2py] update easy_install

2013-01-23 Thread Derek
running: easy_install web2py - it installs version 2.1.1 - can you make this install the latest stable version? --

Re: [web2py] update easy_install

2013-01-23 Thread Richard Vézina
wget http://web2py.com/examples/static/web2py_src.zip Latest stable. Then you unzip it where you want. On Wed, Jan 23, 2013 at 3:53 PM, Derek wrote: > running: easy_install web2py - it installs version 2.1.1 - can you make > this install the latest stable version? > > -- > > > > --

[web2py] How do I use web2py to make a simple GUI?

2013-01-23 Thread Kaare Mikkelsen
Hi, the answer to this question may well be that I should leave web2py alone and use something else, so I had better start explaining what I'm trying to do. I'm sorry if my post comes across as long-winded, feel free to skip to the question at the bottom: I want to make a small app for a specia

[web2py] Edit button behavior with sqlform.grid and multiple joins

2013-01-23 Thread Jason Martens
Hello All, I have a SQLFORM.grid with multiple joins that looks something like this: query = (db.locations.id == 10) & (db.rooms.id == db.locations.room_id) & (db.other.id == db.rooms.other_id) SQLFORM.grid(query) The problem is the edit button defaults to the other table, and I want it to g

[web2py] install web2py + Apache + opensuse

2013-01-23 Thread Mauricio Gallo Ocampo
Anyone know of manual to install web2py + Apache + Opensuse --

Re: [web2py] update easy_install

2013-01-23 Thread Derek
I know how to get the latest version. I was just mentioning that when I run easy_install, it tries to install an older version. Perhaps Massimo can submit the new version to pip. On Wednesday, January 23, 2013 2:22:30 PM UTC-7, Richard wrote: > > wget http://web2py.com/examples/static/web2py_src

[web2py] How do I use web2py to make a simple GUI?

2013-01-23 Thread Kaare Mikkelsen
Hi, it is possible that the answer to this question turns out to be that I'm using the wrong tool altogether, so I'll start by describing what I wish to accomplish. If you just want to skip to the question, jump to the bottom. I wish to make a small app that does a somewhat simple calculation w

[web2py] SQLFORM.smartgrid: TSV & CSV export with hidden cols only shows visible cols

2013-01-23 Thread François Delpierre
When using the CSV export with hidden cols or the TSV export with hidden cols, I have none of the hidden columns in the view. Here is the SQLFORM being used: def index(): form = SQLFORM.smartgrid( db.t_bsc, onupdate=auth.archive, linked_tables=['t_bsc', 't_device

Re: [web2py] update easy_install

2013-01-23 Thread Richard Vézina
Did you try pip? Richard On Wed, Jan 23, 2013 at 4:56 PM, Derek wrote: > I know how to get the latest version. I was just mentioning that when I > run easy_install, it tries to install an older version. Perhaps Massimo can > submit the new version to pip. > > > On Wednesday, January 23, 2013 2

Re: [web2py] How do I use web2py to make a simple GUI?

2013-01-23 Thread Richard Vézina
This site may help you : http://killer-web-development.com/ If you search in the group mailing list you will find many thread citing a bunch of ressources. Richard On Wed, Jan 23, 2013 at 5:03 PM, Kaare Mikkelsen wrote: > Hi, it is possible that the answer to this question turns out to be that

[web2py] Re: How do I use web2py to make a simple GUI?

2013-01-23 Thread François Delpierre
Hi Kaare, I'm not sure I fully understand your need. But, if all you need is a simple web app to make a calculation from some fields and get one or more answers, Web2Py is probably the right tool for doing it. One of your wish is to have this app correctly displaying on your mobile phone browse

Re: [web2py] install web2py + Apache + opensuse

2013-01-23 Thread Richard Vézina
On Wed, Jan 23, 2013 at 12:09 PM, Mauricio Gallo Ocampo < magallo...@gmail.com> wrote: > nual to install web2py + Apache + Opensuse This should be easy once you install OpenSuse and Apache, you need to install web2py in /home/www-data for example... Then the difference with Ubuntu will be the

[web2py] How to put both login and register forms on one page...

2013-01-23 Thread sasogeek
how do I put the login and register forms on one page... so that a user is logged in if they click the login button (if they've entered correct email and password) and are signed up if they click the register button with form data for a new account? --

Re: [web2py] Re: sqlform.grid does not delete record

2013-01-23 Thread António Ramos
Strange, i did not add arg as you suggested and today the delete button works. Yesterday it was not working. Thank you for your time António 2013/1/22 Niphlod > SQLFORM.grid uses args to determine what to do. you are using > request.args(0) in your query without letting know the grid that the >

[web2py] Re: Sqlform.smartgrid does not show link to uploaded file

2013-01-23 Thread António Ramos
Please delete this post, if possible. the subject is wrong. Its SQLFORM.factory does not show link to uploaded files 2013/1/23 António Ramos > Hello > > my code > > > form=SQLFORM.factory(db.trabalhador,db.t_docs, > submit_button="Gravar", > > fields=['nome','bi','ncart','ncartval','

[web2py] Re: Register action using info from POST

2013-01-23 Thread Mark Li
I have decided to use validate_and_insert with web2py's REST methods db.auth_user.validate_and_insert(**fields) Testing so far, I was able to add a user even though the email and password fields were empty in the POST call. I altered my api action so that it checks whether or not the email and

[web2py] SQLFORM.factory and uploaded files. where is the link?

2013-01-23 Thread António Ramos
Hello I dont know how to show the link to the uploaded files using SQLFORM.factory my code form=SQLFORM.factory(db.trabalhador,db.t_docs, submit_button="Gravar", fields=['nome','bi','ncart','ncartval','apt_medica','apt_medicaval','val_formacao','f_doc'], table_name='trabalh

[web2py] Re: Auth login with Firefox

2013-01-23 Thread villas
Still struggling with Firefox login. When I render the built-in login form, the formkey should be the same as that which is saved in the session file. At least I think that is what is supposed to happen. It seems to happen OK with other browsers. Using Firefox the keys are different and th

[web2py] error in alwaydata ?

2013-01-23 Thread samuel bonilla
i am trying this command in alwaysdata hosting with ssh, for up my web2py application, but i get this error: http://forum.alwaysdata.com/viewtopic.php?id=1859 chmod +x web2py/web2py.fcgi chmod: cannot acess 'web2py/web2py.fcgi' : no such file or directory help me ? --

[web2py] How do I change meta tags on each page ?

2013-01-23 Thread GeeksRule
If I change the meta-tags in the layout, then all pages have the same meta-tag values. I want to change the content inside the meta tags for each page. e.g. *description* or the *og:title* e.g. But when I do the above, it change the *response.description* on the main page and after that it rem

[web2py] Displaying form errors after successful submission?

2013-01-23 Thread Ragtime AllTime
I think I may be going about this wrong, but I want to throw new form errors if something happens after doing form.accepts(...). I'm not using SQLFORM or CRUD, just the FORM(). The scenario is something like this: The user enters payment information correctly, but when I charge the card, the c

[web2py] Re: How do I change meta tags on each page ?

2013-01-23 Thread GeeksRule
This is interesting ! I think the problem is happening since a new page is actually not getting generated when I click on a link -- Jquery-Mobile ?? When a link is being clicked I see that the resulting URL is http://domain.com/*#*/function/9025 That "*#*" probably means a link on the same page !

[web2py] Re: How do I change meta tags on each page ?

2013-01-23 Thread GeeksRule
Found it ! I've to set all my links as data-ajax="false" to avoid the links sharing the same meta-tags ! On Wednesday, 23 January 2013 22:18:19 UTC-5, GeeksRule wrote: > > This is interesting ! > I think the problem is happening since a new page is actually not getting > generated when I click o

Re: [web2py] How to put both login and register forms on one page...

2013-01-23 Thread Bruno Rocha
return dict(register=auth.register() , login=auth.login()) {{=register}} {{=login}} Em 23/01/2013 20:39, "sasogeek" escreveu: > how do I put the login and register forms on one page... so that a user is > logged in if they click the login button (if they've entered correct email > and password)

[web2py] Re: Displaying form errors after successful submission?

2013-01-23 Thread Ragtime AllTime
I think I got it: I can use onvalidate and set the form.errors when the exception is tripped. That way, the form is never successfully submitted. Although now I have the problem where the form errors are displayed twice for fields that have their own validate function set. For example, setting

[web2py] Re: Displaying form errors after successful submission?

2013-01-23 Thread Anthony
If you want to check the credit card before accepting the form and inserting the record into the db, you might consider an onvalidationfunction instead. Otherwise, if you just want to add an error message to a particular form field, yo

[web2py] Re: Register action using info from POST

2013-01-23 Thread Anthony
You might consider looking at the auth.register() code: http://code.google.com/p/web2py/source/browse/gluon/tools.py#2168 Another option might be to generate an auth.register() form and send the formkey to the client to be passed back as a hidden field in the POST call. You can then let the web

[web2py] Re: Register action using info from POST

2013-01-23 Thread Anthony
Or an easier option is to use the auth.get_or_create_user()method, though that doesn't provide the password verification field/validation that the auth.register() function includes (which you may not want anyway). Anthony On W

[web2py] Re: SQLFORM.factory and uploaded files. where is the link?

2013-01-23 Thread Paolo valleri
add upload=URL('default', 'download') should solve the problem. Paolo On Thursday, January 24, 2013 12:11:33 AM UTC+1, Ramos wrote: > > Hello > I dont know how to show the link to the uploaded files using > SQLFORM.factory > > > my code > > > form=SQLFORM.factory(db.trabalhador,db.t_docs, >

[web2py] How to track where the MySql error 2014 is occuring?

2013-01-23 Thread Saurabh Kumar
Hi, I have a Web2py app running on Mysql. In my apache logs, I get to see a lot of mysql errors (error code 2014): Exception _mysql_exceptions.ProgrammingError: (2014, "Commands out of sync; you can't run this command now") How should I proceed to track which part of the code is causing this bu