[web2py] Databese error in registration process

2019-03-12 Thread Константин Комков
After updating to web2py 2.18.3 one of users could't be registrated in database. Before that he had error *'ascii' codec can't decode byte 0xd0 in position 0: ordinal not in range(128) *too, but I apply fix by Leonel Câmara and changed: if not isinstance(obj, bytes): to if not hasattr(obj, 'deco

[web2py] Re: Databese error in registration process

2019-03-12 Thread Константин Комков
Maybe error in that string: db.executesql( "execute procedure esp_web_new_user('{0}','{1}','{2}','{3}','{4}',{5})".format( str(form.vars.f),str(form.vars.i),str(form.vars.pser),str(form.vars.pnum),str(form.vars.num),auth.user_id)#auth.user.last_name,auth.user.first_name ) -- Resources: - htt

[web2py] broken fetch in 2.18.3?

2019-03-12 Thread Dave S
In moving my application to 2.18.3 (windows exe kit, stable+timestamp.2019.03.03.23.22.30), I'm getting the following exception: File "applications\badlist\modules\restuff.py", line 51, in restuff bin=fetch(url) File "C:\Users\Dave\web2py_win\web2py_win.2-18-3\web2py\gluon\tools.py", line 46

[web2py] uwsgi not logging when web2py installed on ubuntu 18.04 with nginx with setup script

2019-03-12 Thread Toby
I set up a new DigitalOcean server (Ubuntu 18.04) and ran the install script setup-web2py-nginx-uwsgi-ubuntu.sh It works OK and I can access the admin interface, but I noticed that uwsgi logging is not working. Even once the app is running there is no log file created at /var/log/uwsgi/ Any id

[web2py] Re: Databese error in registration process

2019-03-12 Thread Leonel Câmara
In a web2py shell for your application try: " '{0}' ".format("foo' ") You will get: " 'foo' ' " You can see how this will cause it to have unclosed ' in the strings which then can give you that error. How you fix this is by quoting the string using your DB's dialect " '{0}' ".format(db._ad

[web2py] Update text for GRID buttons - View/Edit etc

2019-03-12 Thread Sarbjit
Hello, I want to change the default text of the buttons visible in SQLFORM.GRID. I am using the following code, but it is not updating the text grid.element(_title='View')['innerHTML']='Details' Any idea on how this can be done? Thanks ! -- Resources: - http://web2py.com - http://web

[web2py] Re: uwsgi not logging when web2py installed on ubuntu 18.04 with nginx with setup script

2019-03-12 Thread Toby
I've narrowed down the problem. The file /etc/init/uwsgi-emperor.conf is not being created because the directory /etc/init doesn't exist. The directory /etc/init doesn't exist because it's for Upstart configuration, and Ubuntu 17.10 and higher don't support upstart

Re: [web2py] Web2py Windows edition with 3.x Interpreter

2019-03-12 Thread Jitun John
Apologies for the delay... I think my program has issues with new version of pydal 19.02, while it works fine on pydal 18.08 Thanks Nico for all the hard work. I will test and let you know soon. On Sunday, March 3, 2019 at 4:54:38 PM UTC+5:30, Nico Zanferrari wrote: > > Good morning! > > I'm p

[web2py] Re: uwsgi not logging when web2py installed on ubuntu 18.04 with nginx with setup script

2019-03-12 Thread Toby
OK, so now I realise that the script setup-web2py-nginx-uwsgi-ubuntu.sh creates init scripts for both upstart and systemd (why? Is that to support multiple versions of Ubuntu?). It writes to the systemd sc

Re: [web2py] Re: Date Picker Widget

2019-03-12 Thread Ben Lawrence
Hi Web2py developers, This thread did not seem to be implemented. Massimo said he will put it into the next release, but should I do it with a push request? regards Ben On Friday, September 9, 2011 at 6:36:02 AM UTC-7, Richard wrote: > > Sure... Do you want the Annet CSS or mine ? > > Richard >

Re: [web2py] Web2py Windows edition with 3.x Interpreter

2019-03-12 Thread Kevin Keller
Whats the problem with pydal John? On Tue, Mar 12, 2019 at 5:37 PM Jitun John wrote: > Apologies for the delay... > I think my program has issues with new version of pydal 19.02, while it > works fine on pydal 18.08 > > Thanks Nico for all the hard work. > I will test and let you know soon. > >

[web2py] Re: uwsgi not logging when web2py installed on ubuntu 18.04 with nginx with setup script

2019-03-12 Thread Toby
Got it working. Here's what I needed to do: 1. Add the following line to the bottom of /etc/uwsgi/web2py.ini *logto = /var/log/uwsgi/uwsgi.log* 2. Comment out this line (by putting a # in front): *StandardError = syslog* in the file /etc/systemd/system/emperor.uwsgi.service The best way to edit t

[web2py] Re: Update text for GRID buttons - View/Edit etc

2019-03-12 Thread Marcelo Huerta
El martes, 12 de marzo de 2019, 11:55:58 (UTC-3), Sarbjit escribió: > > Hello, > > I want to change the default text of the buttons visible in SQLFORM.GRID. > I am using the following code, but it is not updating the text > > grid.element(_title='View')['innerHTML']='Details' > > Any idea

[web2py] Re: Databese error in registration process

2019-03-12 Thread Marcelo Huerta
El martes, 12 de marzo de 2019, 4:13:31 (UTC-3), Константин Комков escribió: > > Maybe something do not work in that string, but before it work without > errors and now I have problem with only one user and I see that 20 users > was be registrated without errors after him also? > > db.executesql

[web2py] Is it possible to sort the grid search fields list?

2019-03-12 Thread João Matos
Hello, Is it possible to sort the grid search fields list? And limit the fields list to the only ones shown in the grid itself? Thanks, JM -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web

[web2py] Re: Is it possible to sort the grid search fields list?

2019-03-12 Thread 黄祥
is the sqlform.grid(sortable=True) doesnt meet your requirement ? ref: http://web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM-grid-signature best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Sour

[web2py] Admin app - File management errors

2019-03-12 Thread guiromero85
Hi, I was trying latest 2.18.3 release, and I think I have found a possible bug. Running Rocket under Python 3.6.0 (Ubuntu) *I can't delete nor upload files*, for example, into /static/images folder. I receive a flash message indicating that was not possible to upload or delete a desired file.

[web2py] Re: Error: Exporting CSV file in SQLFORM.grid

2019-03-12 Thread gilad
Could you share your solution? On Wednesday, January 14, 2015 at 7:31:56 PM UTC+2, Prasad Muley wrote: > > Hello All, > >I've used a SQLFORM.grid for displaying table content. I've > provided export to CSV option in grid. > > My app settings are as below: > > *models/db.py* > > db.define_

[web2py] Re: Mysql 8.0.15

2019-03-12 Thread learthurjoly
Hello ! I have exactly the same problem. Have you found a solution to this problem? My version: 2.18.3-stable+timestamp.2019.03.03.23.22.30 (Running on Apache/2.4.25 (Debian 9 stretch), Python 2.7.13) Le jeudi 14 février 2019 20:09:22 UTC+1, Andrea Fae' a écrit : > > Hello, I'm sorry but I'm no

[web2py] Mysql-Web2py connection failure

2019-03-12 Thread learthurjoly
Hello everyone, I have a problem when I try to connect web2py to a mysql database. I'm using a Debian 9 strech, Web2py 2.18.3-stable + timestamp.2019.03.03.23.22.30 (Running on Apache / 2.4.25, Python 2.7.13) and mysql 8.0.15. I don't have any problem when I use storage.sqlite. But when I try to

[web2py] web2py 2.18.4 is OUT

2019-03-12 Thread Massimo Di Pierro
includes many small fixes, thanks Leonel, Paolo, and everybody who contributed. -- 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

Re: [web2py] Re: Error: Exporting CSV file in SQLFORM.grid

2019-03-12 Thread sandeep patel
I have solved this problem. This problem is occurring because of filter object you have to convert into the list. You have to need some changes in the sqlhtml file. go to gluon/sqlhtml.py change line no : 2688 >From - sfields = reduce(lambda a, b: a + b, [filter(is_searchable, t) for t in tables])

[web2py] Re: web2py 2.18.4 is OUT

2019-03-12 Thread Константин Комков
Thank you! But http://web2py.com/book don't work. -- 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