[web2py] Re: I would like to log of all SQL commands web2py sends to SQLite. Is it possible?

2019-03-16 Thread Anthony
Also, if you set DAL(..., debug=True), I believe all SQL commands will be logged to the "pyDAL" logger. Anthony On Saturday, March 16, 2019 at 5:57:47 PM UTC-4, Anthony wrote: > > Commands issued during migration operations are already saved to > /databases/sql.log. If you want all commands (i.

Re: [web2py] Re: Using lambda in Field constructor for default

2019-03-16 Thread Eliezer (Vlad) Tseytkin
Got it, thank you! On Sat, Mar 16, 2019, 11:29 AM João Matos wrote: > Check this > > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=computed+field#Computed-fields > > > sexta-feira, 15 de Março de 2019 às 20:58:39 UTC, Vlad escreveu: >> >> I am missing someth

[web2py] Re: Using lambda in Field constructor for default

2019-03-16 Thread Anthony
Also, when "default" is a function, it does not take any arguments. Anthony On Saturday, March 16, 2019 at 11:29:50 AM UTC-4, João Matos wrote: > > Check this > > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=computed+field#Computed-fields > > > sexta-feira,

[web2py] Re: I would like to log of all SQL commands web2py sends to SQLite. Is it possible?

2019-03-16 Thread Anthony
Commands issued during migration operations are already saved to /databases/sql.log. If you want all commands (i.e., queries), note that on each request, there is db._timings, which is a list of tuples, where the first element of each tuple is the SQL command issued and the second element is th

[web2py] Re: id field is added by web2py to grid's orderby. Does anyone know why? And how to remove it?

2019-03-16 Thread João Matos
No, I just didn't know the reason. Thanks for the explanation. sábado, 16 de Março de 2019 às 21:44:09 UTC, Anthony escreveu: > > On Saturday, March 16, 2019 at 3:06:07 PM UTC-4, João Matos wrote: >> >> Hello, >> >> I was checking the SQL statements used by web2py and found that the id >> field o

[web2py] Re: id field is added by web2py to grid's orderby. Does anyone know why? And how to remove it?

2019-03-16 Thread Anthony
On Saturday, March 16, 2019 at 3:06:07 PM UTC-4, João Matos wrote: > > Hello, > > I was checking the SQL statements used by web2py and found that the id > field of a table is always added to the orderby when using a grid (didn't > test in other forms). > Even if the grid definition doesn't includ

[web2py] I would like to log of all SQL commands web2py sends to SQLite. Is it possible?

2019-03-16 Thread João Matos
Hello, I would like to log of all SQL commands web2py sends to SQLlite. Is it possible? Thanks, JM -- 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

Re: [web2py] Re: Poweredby error

2019-03-16 Thread Daniel Guilhermino
Hi Massimo, I just checked and it's working perfectly now! Many thanks, long life and prosper to you and Web2py! Best regards. Daniel Guilhermino Em sexta-feira, 15 de março de 2019 00:50:38 UTC-3, Massimo Di Pierro escreveu: > > I will look into this asap. > > On Monday, 11 March 2019 05:15:

[web2py] id field is added by web2py to grid's orderby. Does anyone know why? And how to remove it?

2019-03-16 Thread João Matos
Hello, I was checking the SQL statements used by web2py and found that the id field of a table is always added to the orderby when using a grid (didn't test in other forms). Even if the grid definition doesn't include a orderby argument, web2py always adds the ORDER BY id. Does anyone know why

[web2py] Re: error 'module' object has no attribute 'pbkdf2_hmac' when trying to add user (Ver 2.18.4)

2019-03-16 Thread Stephan
It's not possible to login as an existing user, either. all after upgrading to VER 1.18.4 Am Freitag, 15. März 2019 17:11:07 UTC+1 schrieb Stephan: > > Hello there, > > > when trying to add a user in the empty user table via appadmin, I get this > error: *'module' object has no attribute 'pbkdf2

[web2py] Re: Using lambda in Field constructor for default

2019-03-16 Thread João Matos
Check this http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=computed+field#Computed-fields sexta-feira, 15 de Março de 2019 às 20:58:39 UTC, Vlad escreveu: > > I am missing something very simple here, but can't unstuck myself: > > This is what I want to have in

[web2py] Re: Web2py install script python 3/Apache/Ubuntu

2019-03-16 Thread Mamisoa Andriantafika
This script works with python 3 but is under nginx: https://raw.githubusercontent.com/arisobel/web2py_scripts/master/setup-web2py-nginx-p3-uwsgi-ubuntu.sh Le samedi 16 mars 2019 13:12:06 UTC+1, Mamisoa Andriantafika a écrit : > > Sorry this does not work for me. > > Did you manage to get a serv

[web2py] Re: Web2py install script python 3/Apache/Ubuntu

2019-03-16 Thread 黄祥
perhaps you can share the error log (web server or web2py) tested before in 2018 is worked ref: https://groups.google.com/forum/#!topic/web2py/IFasLOdWsbI best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source cod

[web2py] Re: Web2py install script python 3/Apache/Ubuntu

2019-03-16 Thread Mamisoa Andriantafika
Sorry this does not work for me. Did you manage to get a server working with python 3 and apache? Le samedi 16 mars 2019 12:37:02 UTC+1, 黄祥 a écrit : > > think on line 164 and 165 is the culprit, should be > sudo -u www-data *python3* -c "from gluon.widget import console; > console();" > sudo -u

[web2py] Re: Web2py install script python 3/Apache/Ubuntu

2019-03-16 Thread 黄祥
think on line 164 and 165 is the culprit, should be sudo -u www-data *python3* -c "from gluon.widget import console; console();" sudo -u www-data *python3* -c "from gluon.main import save_password; save_password(raw_input('admin password: '),443)" best regards, stifan -- Resources: - http://web

[web2py] Error after edit project

2019-03-16 Thread Константин Комков
After I edit project (write or delete any strings) I have got error from time to time like that: Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. Traceback (most recent call last): File ".\gluon\restricted.py", line 219, in restricted exec(ccode, environment) File "C:\inetpub\wwwroot\application

[web2py] selecting with IS_IN_DB()

2019-03-16 Thread mostwanted
Hi guys, i am trying out the IS_IN_DB() validator for the first time, in my research i cant really find out what i am looking for so i was hoping someone with better understanding would assist me. I have 2 tables, one for locations and the other for people and where they come from, I have creat

[web2py] Re: Web2py install script python 3/Apache/Ubuntu

2019-03-16 Thread Mamisoa Andriantafika
Hi, I uses the 2nd link (python 3) you gave to get it work with apache on ubuntu server 18.04. The first is for nginx. But I still get that web2py is running on 2.7 version of python? Le samedi 16 mars 2019 01:46:30 UTC+1, 黄祥 a écrit : > > might we know which script that you used ? > > check

[web2py] Error in app which cause error in web2py 2.18.4

2019-03-16 Thread Константин Комков
Web2py 2.18.4 give me to save project with error and after that I can not edit it in app. I have dict: {21: '\xd0\x94\xd0\xb8\xd0\xbf\xd0\xbb\xd0\xbe\xd0\xbc \xd0\xbe \xd0\xb2\xd1\x8b\xd1\x81\xd1\x88\xd0\xb5\xd0\xbc \xd0\xbf\xd1\x80\xd0\xbe\xd1\x84\xd0\xb5\xd1\x81\xd1\x81\xd0\xb8\xd0\xbe\xd0\xbd