[web2py] Re: Web2py freezing

2016-10-24 Thread piero crisci
Hi massimo and thanks fot the hint I tried with rocket from cmd line and this is result from Apache ab command line. I got the same result i have with APACHE WSGI as you can see below *MY APP WITH ROCKET * This is the command launch C:\web2py>python web2py.py *No handlers could be found for logg

[web2py] SQLFORM grid search : Get ids of filtered records

2016-10-24 Thread Madhavi
Hi, I am new to web2py and am working on application with a SQLFORM grid with the search feature along with selectable option. I added extra buttons to my grid to set a boolean value for selected records using selectable feature, and added another button to set a boolean value for all the reco

[web2py] Re: Deployment question

2016-10-24 Thread Massimo Di Pierro
Rocket is a multithreaded server and pandas is not thread safe (http://pandas.pydata.org/pandas-docs/stable/gotchas.html) be very careful with it. On Tuesday, 16 August 2016 13:19:42 UTC-5, Dave S wrote: > > > > On Tuesday, August 16, 2016 at 8:50:51 AM UTC-7, Jim S wrote: >> >> Hi >> >> I cur

[web2py] Re: Web2py freezing

2016-10-24 Thread Massimo Di Pierro
Something is very wrong here and I do not know what it is. Why are you suing apache with WSCGI. This is not a recommended configuration. We do not support Apache any more and we never supported WSCGI. Can you try rocket and nginx? On Monday, 24 October 2016 10:47:49 UTC-5, piero crisci wrote: >

[web2py] Re: how to deploy in GAE

2016-10-24 Thread Massimo Di Pierro
wget http://web2py.com/examples/static/web2py_src.zip unzip web2py_src.zip cd web2py cp examples/app.example.yaml app.yaml cp handler/gaehandler.py gaehandler.py EDIT app.yaml and replace "yourappname with" your application name deploy with cd .. appcfg.py update web2py or with gcloud

[web2py] CouchDB support

2016-10-24 Thread Robert F
Still on the learning curve regarding Web2py but would like to know how to use the CouchDB DAL interface. CouchDB is mentioned in the support docs but does not appear during start up in list of database adapters found. For example I get: Database drivers available: psycopg2, pymysql, imaplib,

[web2py] Add direct link in grid to edit page for connected table

2016-10-24 Thread Nicola Clementel
Hi, I have several tables connected in the following way: db.define_table('table_1', Field('name',unique=True)) db.define_table('table_2', Field(), . Field('ref_t1','reference table_1',requires=IS_IN_DB(db,db.table_1.id,'%(name)s'))) db.define_table('table_3'

[web2py] Tornado

2016-10-24 Thread William
How to run my own tornado file on web2py. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Goog

Re: [web2py] Re: Deployment question

2016-10-24 Thread Jim Steil
Yes, it's crazy. I have 2 ubuntu 14.04 servers that work fine, pandas 0.18 (I have other issues with 0.19.0 so haven't moved there yet, but still had the same behavior when I tested). But, any new Ubuntu 14.04 servers I install won't work. Any time i try 16.10 or 16.04 (which is what i want to u

[web2py] Re: How to cleanly pass FPDF output object to os Download/Save dialogue box

2016-10-24 Thread Peter
Just to close this off. I think I am in a bit of a catch 22.. Because the behaviour *is exactly what I want *i.e. stream goes straight to download option, I don't get the open/save dialogue so can't change the setting and after reading this (possibly related Firefox bug report)* https://

Re: [web2py] Re: change the size of a text field in a form

2016-10-24 Thread Richard Vézina
F5 or Ctrl+R or delete cache may help sometimes... But it hards to know what you may doing wrong without any code... Richard On Mon, Oct 24, 2016 at 12:56 PM, Steven Vannoy wrote: > This is exactly what I'm trying to do, none of the suggestions below has > changed my form view at all. Must be d

[web2py] What kind of application is web2py good for designing and what kind of application it isn't as good?

2016-10-24 Thread Mike Stephenson
for example, you may compare chatting and other kinds. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribe

[web2py] What kind of application is web2py for designing and what kind of application it isn't as good?

2016-10-24 Thread Mike Stephenson
for example, you may compare chatting and other kinds. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribe

[web2py] Migrate integer field to string type

2016-10-24 Thread Ian W. Scott
I'm using Postgresql and I need to migrate the data type of a field from "integer" to "string". Will it work to just change the field type in the model table definition? What will happen to the existing "integer" data? Any problems foreseen? Thanks, Ian -- Resources: - http://web2py.com - ht

[web2py] Re: change the size of a text field in a form

2016-10-24 Thread Steven Vannoy
This is exactly what I'm trying to do, none of the suggestions below has changed my form view at all. Must be doing something wrong. I'm trying to avoid using a custom.widget so I don't have to specifically layout everyone of my fields, there are over 30, but I want them to be a fixed width so

Re: [web2py] Re: Deployment question

2016-10-24 Thread Richard Vézina
You right, I forgot... But you may try by raising the limit... Is there any open issue for pandas about that... This is not normal... If I remember it does that only in web2py environment? If the issue occurs on import pandas as pd why I don't have it?? I have : limit-as 512 I have pandas 0.19.0

Re: [web2py] Hide flash message after some elapsed time instead of on click

2016-10-24 Thread Marc Smith
Thank you, that did the trick. --Marc On Fri, Oct 21, 2016 at 5:00 PM, Scott Hunter wrote: > You need single-quotes around > flash.fadeOut("slow") > > Otherwise, as you have seen, it gets executed immediately instead of after a > delay. > > > On Tuesday, October 18, 2016 at 9:35:30 AM UTC-4, Mar

Re: [web2py] Re: use jquery mobile with image upload functionality in web2py - is a hack is necessary?

2016-10-24 Thread Rob Paire
Ah that is a good, elegant solution; thank you for sharing. I did not know of this trick before. On Oct 21, 2016 4:54 PM, "Johnny Lupino" wrote: > Hi, > > It's been some time after you had posted your problem, but I found out > another way of fixing it, since I could not find "//event.preventDef

[web2py] Re: Web2py freezing

2016-10-24 Thread piero crisci
I update the version and i tried also on a WINDOWS 7 with the same configuration. Here is the difference beetwen the WINDOWS SERVER 2012R2 and WINDOWS 7 with the same configuration *APACHE* *Server version: Apache/2.4.23 (Win64)* *Server built: Oct 1 2016 08:28:43* *Distributed by: The A

Re: [web2py] Re: Deployment question

2016-10-24 Thread Jim Steil
Thanks for the comment Richard - At the point it crashes I don't believe it is an issue with my app. It crashes on - import pandas as pd - so, I don't think it is anything I'm doing in my code. -Jim On Mon, Oct 24, 2016 at 9:48 AM, Richard Vézina wrote: > I suggest you try to raise the limit..

Re: [web2py] Re: Deployment question

2016-10-24 Thread Richard Vézina
I suggest you try to raise the limit... I don't know why it get in the configuration file, but I read it could be use to prevent memory leaks. It's also help preventing app from eating all the memory before crash the system... You maybe better understand why you code need so much memory and try to

[web2py] Re: update_or_insert does not return id of record ?!

2016-10-24 Thread Anthony
It returns the id if a record is inserted, but not if updated (this allows you to distinguish between the two cases). Anthony On Monday, October 24, 2016 at 9:05:56 AM UTC-4, Ramos wrote: > > hello i noticed that > db.mytable.update_or_insert(...) > does not return the id of the record updated

[web2py] Re: order by the greater of 2 fields

2016-10-24 Thread Anthony
On Monday, October 24, 2016 at 7:11:29 AM UTC-4, Anthony Smith wrote: > > Hi all, > > I have table with 2 fields, withhold _until_date and esi_withhold_until. > > Is is it possible to order by so the the greater of the 2 fields was at > the top of the list. > I think there are various ways to ach

[web2py] Re: order by the greater of 2 fields

2016-10-24 Thread Anthony
On Monday, October 24, 2016 at 8:55:23 AM UTC-4, 黄祥 wrote: > > pls try (not tested) > myorder = db.mytable.withhold_until_date | db.mytable.esi_withhold_until > db().select(db.mytable.ALL, orderby = myorder) > That will order by withhold_until_date, with esi_withhold_until breaking any ties -- it

[web2py] update_or_insert does not return id of record ?!

2016-10-24 Thread António Ramos
hello i noticed that db.mytable.update_or_insert(...) does not return the id of the record updated or created Is this correct ? i would be nice to have it reurned Regards António -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: order by the greater of 2 fields

2016-10-24 Thread 黄祥
pls try (not tested) myorder = db.mytable.withhold_until_date | db.mytable.esi_withhold_until db().select(db.mytable.ALL, orderby = myorder) ref: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer best regards, stifan -- Resources: - http://web2py.com - http://web2py.c

[web2py] order by the greater of 2 fields

2016-10-24 Thread Anthony Smith
Hi all, I have table with 2 fields, withhold _until_date and esi_withhold_until. Is is it possible to order by so the the greater of the 2 fields was at the top of the list. cheers Anthony -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2p

[web2py] Re: Grid export csv

2016-10-24 Thread Niphlod
never ever pull web2py AND pydal master's and merge (unless you really know what you're doing). When using "master", at most, use web2py's one, which has the correct pointers to pydal's specific commits. Any commit later than 15aug should work fine ^_^ On Friday, October 21, 2016 at 10:54:31 P

[web2py] Re: Randomly stuck web2py

2016-10-24 Thread Niphlod
see the log to trace any DDos attempts (or stuck requests ) On Friday, October 21, 2016 at 10:54:32 PM UTC+2, Wasim Baig wrote: > > Been using web2py for sometime now, thank you all for making life so easy. > > We use stock web2py src on debian 8, with Rocket and mysql and start them > in screen.

[web2py] Re: tasks hierarchy

2016-10-24 Thread Niphlod
you should use "Jobs" for that. any task queued that needs another task to be executed before it should be linked with thejob.add_deps(dependant, parent) in your case: - cat3 is dependant from cat2 - cat2 is dependant from cat1 read more using the https://github.com/niphlod/w2p_scheduler_test

Re: [web2py] Re: Graph Model (proposal to contribute)

2016-10-24 Thread Andrew Willimott
Has anyone else tried visualising the models with d3js ? I have a mockup working using the force layout. I'd suggest this is a better long term approach than relying on graphviz being installed. (Graphviz has some good layouts though). I can send cleaned up code as a candidate to add to We

[web2py] Re: Is it possible for Web2Py SOAP-Services to give feedback during lenghty operations?

2016-10-24 Thread Oliver Holmes
Great! Will give the queued task a go. Not quite sure how to send the feedback over my SOAP pipeline though. But I'll come up with something. Thanks and cheers! Am Donnerstag, 20. Oktober 2016 19:44:12 UTC+2 schrieb Dave S: > > > > On Thursday, October 20, 2016 at 7:38:16 AM UTC-7, Oliver Holmes