[web2py] Re: 2.17.2 is out

2018-12-06 Thread Massimo Di Pierro
Can I ask for a patch? On Tuesday, 27 November 2018 09:42:35 UTC-8, Web2_3py wrote: > > for web2py version 2.17.2 > > On Sunday, November 25, 2018 at 8:17:08 PM UTC+3, Web2_3py wrote: >> >> >> *export_to_csv_file* >> >> >> under python2 , no problem >> >> under python3 , the following problem >> >

[web2py] Re: Is it possible to share cache between two differente web2py applications?

2018-12-06 Thread Massimo Di Pierro
thanks On Monday, 26 November 2018 06:49:36 UTC-8, Lisandro wrote: > > Thanks Massimo! > I've recently noted that the fix I did was incomplete. > > I've sent a new pull request with the new code: > https://github.com/web2py/web2py/pull/2059 > > Regards, > Lisandro. > > El domingo, 18 de noviembre

[web2py] Re: How to get tickets in DB working

2018-12-06 Thread Massimo Di Pierro
I opened a ticket about this until I can evaluate this further. But at the very list what you proposed should be an option. https://github.com/web2py/web2py/issues/2062 On Friday, 23 November 2018 01:06:26 UTC-8, appjar...@gmail.com wrote: > > I had to modify Web2Py as follows to get tickets stor

Re: [web2py] Re: PostgreSQL log flooded with "could not receive data from client: Connection reset by peer" messages;

2018-12-06 Thread Tadas U
Sorry, yes, postgres is 9.3 by the way, forgot to mention On Fri, 7 Dec 2018, 09:46 Massimo Di Pierro What do you mean by "20 schedulers"? 20 workers? 20 tasks? > > On Sunday, 18 November 2018 10:46:35 UTC-8, Tadas U wrote: >> >> Web2py version: Version 2.14.6-stable+timestamp.2016.05.10.00.21.4

[web2py] Re: PostgreSQL log flooded with "could not receive data from client: Connection reset by peer" messages;

2018-12-06 Thread Massimo Di Pierro
What do you mean by "20 schedulers"? 20 workers? 20 tasks? On Sunday, 18 November 2018 10:46:35 UTC-8, Tadas U wrote: > > Web2py version: Version 2.14.6-stable+timestamp.2016.05.10.00.21.47 > > AFAIK, the scheduler is responsible, e.x.: > > SETUP (e.x.): > > scheduler.queue_task( > 'test__

[web2py] Re: machine learning

2018-12-06 Thread Massimo Di Pierro
Yes. Th recommended way is that you use the scheduler. You can use web2py to create an interface and you call your module using the scheduler. That way the UI does not have to wait while the computation runs in background. There is an example in the book. On Sunday, 18 November 2018 10:46:35 UT

[web2py] How to create an administration account (Sahana eden)

2018-12-06 Thread Muhammad Ahsan Farooqui
Hi, I have just added an instance of sahana eden. How can I add an admin user to it? I added one user but it is not admin user so I cannot access db etc. Please help. Ahsan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Help with deploy with nginx and ubuntu 18.04

2018-12-06 Thread carlos valdez
Hi, I'm a noob with web2py, I need some help, because I'm trying to put a site online, for a old project developed in web2py 2.9.5. I need use nginx as a app server, I know I need to use uwsgi, but I'm a little confused with the configuration. I used the script setup-web2py-nginx-uwsgi-ubuntu.

[web2py] Problem in Ubuntu 18.04

2018-12-06 Thread carlos valdez
Hi, I have the next problem trying to running web2py, the problem is, I've a old project, the guys used 2.9 framework, I'm trying to run it in ubutuntu 18.04, It seems to work but when I access to de url https://127.0.0.1/, it shows me an error, but, I can't see the error, becouse when I try to

[web2py] multi-level form acceptance

2018-12-06 Thread pradeep chauhan
hi, i want to send form which i created to some person, if that person accepts the application it will be sent to 2nd person for approval and so on..how can i do that? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - ht

[web2py] "web2py.app“ wants access to control “System Events.app“

2018-12-06 Thread John McMaster
Just installed web2py 2.17.2 on Mojave 10.14.1: I get this message: "web2py.app“ wants access to control “System Events.app“. Allowing control will provide access to documents and data in “System Events.app“, and to perform actions within that app. Are there any issues by allowing this? Secur

[web2py] Conditional Checks on output from DB.Select statements?

2018-12-06 Thread arjunmjarun
I am writing a simple web2py application and can't seem to figure out how to run comparison checks on variables from db.select statements. Code is posted below: form = FORM('Enter Member ID: ', INPUT(_type='text', _name='name'), INPUT(_type='submit', _value='submit')) if form.accep

[web2py] upload a photo to your site by >

2018-12-06 Thread Morteza Tabibi
Hello everyone I just started designing web2py I have a problem I can not upload a photo to your site with the command > And my operating system is Linux, thanks for giving me an example guide -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py

[web2py] Re: New production install Ubuntu/nginx/uwsgi - connect to redis

2018-12-06 Thread Jim S
Ok, I appear to have it working: Here's what I did. I need someone much smarter than me to determine whether or not this is wise: Original web2py/gluon/globals.py at line 1230 dd = dict(locked=False, client_ip=response.session_client, modified_datetim

[web2py] Re: New production install Ubuntu/nginx/uwsgi - connect to redis

2018-12-06 Thread Jim S
Yes, same result. I clear history/cookies and still got the message I tried a private window and it happened. Also got the same result testing from a different browser. -Jim On Thursday, December 6, 2018 at 3:37:10 PM UTC-6, Leonel Câmara wrote: > > Does this still happen if you clear the cook

Re: [web2py] DAL issues ....

2018-12-06 Thread Jim Steil
Thanks Ben On Thu, Dec 6, 2018 at 3:42 PM Ben Duncan wrote: > Controller Code: > > def company_login(): > > form = SQLFORM.factory( > Field('username', label = 'User Name', requires=IS_NOT_EMPTY()), > Field('password', 'password', label = > "Password",requires=IS_NOT_EMPTY())

Re: [web2py] DAL issues ....

2018-12-06 Thread Ben Duncan
Controller Code: def company_login(): form = SQLFORM.factory( Field('username', label = 'User Name', requires=IS_NOT_EMPTY()), Field('password', 'password', label = "Password",requires=IS_NOT_EMPTY()), Field('Company', label = 'Court ID', requires=IS_IN_DB(db,db.compa

[web2py] Re: New production install Ubuntu/nginx/uwsgi - connect to redis

2018-12-06 Thread Leonel Câmara
Does this still happen if you clear the cookies in the browser (or use a private window) before visiting the URL? -- 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 Issu

Re: [web2py] DAL issues ....

2018-12-06 Thread Jim S
I'd love to see the final controller code if you have the time? Also, I'm curious as to why you're putting all this in the session. Why not just pass it in the dict being returned to the view? -Jim On Thursday, December 6, 2018 at 2:46:22 PM UTC-6, Ben Duncan wrote: > > Ok, YOU GUYS are awesom

Re: [web2py] DAL issues ....

2018-12-06 Thread Ben Duncan
Ok, YOU GUYS are awesome ... Your replies gave me the insight I needed ! Here is the explanation: A: in the database, the passes were for the "lookup" in the SQLFORM.factory SO there was the confusion there ... B: It seems there is a 2 passes thru the controller (which this group

Re: [web2py] DAL issues ....

2018-12-06 Thread Ben Duncan
The request.vars get set from the SQL form in the controller Removed all the COMMENTS, and in the controller put a print and changed the code: DbRows = db(db.company.company_number==Company_ID).select(db.company.company_name).first() print DbRows['company_name'] session.company_dat

[web2py] DAL issues ....

2018-12-06 Thread Val K
Maybe I don't understand something, but I think that when the controller is requested for the first time there is no any request.vars and request.vars['Company'] too. Just in case: form.process() doesn't interrupt controller execution -- Resources: - http://web2py.com - http://web2py.com/book

Re: [web2py] Re: DAL issues ....

2018-12-06 Thread Jim S
It looks like the second line of your view if reassigning something else to session.company. I don't believe the HTML comment tags are not going to prevent web2py from executing that statement. -Jim On Thursday, December 6, 2018 at 12:22:30 PM UTC-6, Ben Duncan wrote: > > Well I was thinking t

[web2py] Re: DAL issues ....

2018-12-06 Thread Jim S
Can you try passing DbRows to your view and see if that works? return dict(form=form, DbRows=DbRows) Or, throw a print statement in there before session.company_name = DbRows['company_name'] to see if DbRows['company_name'] has a value before sending to the view? -Jim On Thursday, December

Re: [web2py] Re: DAL issues ....

2018-12-06 Thread Ben Duncan
Here is something strange as well - working thru the web2py console, everything works: [web2py@su-postgres-ben-3 web2py]$ python ./web2py.py -S Mec -M web2py Web Framework Created by Massimo Di Pierro, Copyright 2007-2018 Version 2.17.2-stable+timestamp.2018.10.06.18.54.02 Database drivers availab

Re: [web2py] Re: DAL issues ....

2018-12-06 Thread Ben Duncan
Well I was thinking that, BUT: I'm ALMOST convinced there is a bug in the latest web2py: CODE -- Snippet of controllers/default.py session.company = request.vars['Company']

[web2py] Re: New production install Ubuntu/nginx/uwsgi - connect to redis

2018-12-06 Thread Jim S
And another thing...This fails on the server with the rocket webserver as well as with the nginx/uwsgi server. -Jim On Thursday, December 6, 2018 at 11:42:18 AM UTC-6, Jim S wrote: > > Also > > I have another desktop linux machine here running Ubuntu 18.10 and this > all works just fine. T

[web2py] Re: New production install Ubuntu/nginx/uwsgi - connect to redis

2018-12-06 Thread Jim S
Also I have another desktop linux machine here running Ubuntu 18.10 and this all works just fine. The web2py version there is: web2py™ Version 2.17.2-stable+timestamp.2018.10.06.18.54.02 so I tried that on the failing server and it too fails with the same traceback. Same python version, same

[web2py] Re: New production install Ubuntu/nginx/uwsgi - connect to redis

2018-12-06 Thread Jim S
I've narrowed this down a little bit: Here is the code at the top of my db.py: from gluon.contrib.redis_utils import RConn from gluon.contrib.redis_session import RedisSession rconn = RConn(ccfg.redis.server, ccfg.redis.port) sessiondb = RedisSession(redis_conn=rconn, session_expiry=False) sessio

[web2py] Re: DAL issues ....

2018-12-06 Thread Leonel Câmara
What's happening here is that DbRows can become None in this line DbRows = db(db.company.company_number==Company_ID).select(db.company.company_name).first() So when you do DbRows['company_name'] you can get that error. Basically you need to check if DbRows is None and raise HTTP(404) -- Re

[web2py] DAL issues ....

2018-12-06 Thread Ben Duncan
How can something that seems so simple, be so hard? I can't seem to get a SINGLE field from the database from DAL: First is the Error Message (Or on of the many types - but the latest one), then the code What AM I doing wrong here ? Als always, thanks ... Error Message: Error ticket for "Mec"

Re: [web2py] Re: ValueError when deleting row object

2018-12-06 Thread Maurice Waka
Hi Dave. Thanks for the interest. Actually this line was the issue: delete button works if you're displaying [and punching delete for] Dinner > entry, but for a Lunch entry, it gives the error below? > > >> [...] >> > When I want to delete any row under 'LUNCH', I get this error: >> >> ValueError:

[web2py] Re: ValueError when deleting row object

2018-12-06 Thread Dave S
On Wednesday, December 5, 2018 at 6:16:15 AM UTC-8, Maurice Waka wrote: > > I'm trying to delete a certain row among others with this code: > [...] > want to delete a specific selected row > > [image: lunch.png] > row = db(db.diary.id==request.vars.delete).delete()# deletes all > except