Re: [web2py] web2py 2.16.1 and login menu on mobile systems NOT WORKING

2018-04-23 Thread Andrea Fae'
Hmm...I don't know if there are any people working on this. Can you send me what I can change on web2py (I think layout.html, etc) to fix this specific problem? Thank you Il giorno lunedì 23 aprile 2018 02:16:15 UTC+2, Carlos Cesar Caballero ha scritto: > > Yes, I usually use a newer bootstrap

Re: [web2py] Re: web2py 2.16.1 and login menu on mobile systems NOT WORKING

2018-04-23 Thread 黄祥
> > I'm sorry. What is "in trunk"? > it means you should try the fixed version from the github repo itself by: git clone --recursive https://github.com/web2py/web2py.git best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: web2py 2.16.1 and login menu on mobile systems NOT WORKING

2018-04-23 Thread Paolo Caruccio
This issue has been already fixed in trunk. Please see: https://github.com/web2py/web2py/issues/1828 https://github.com/web2py/web2py/issues/1886 If you don't want to download the updated version of layout.html file and prefer to manually correct the problem please see

Re: [web2py] Re: web2py 2.16.1 and login menu on mobile systems NOT WORKING

2018-04-23 Thread andfae
I'm sorry. What is "in trunk"? Il Lun 23 Apr 2018, 13:17 Paolo Caruccio ha scritto: > This issue has been already fixed in trunk. Please see: > > https://github.com/web2py/web2py/issues/1828 > > https://github.com/web2py/web2py/issues/1886 > > If you don't want to

[web2py] create users manually

2018-04-23 Thread Yebach
Hello I would like to create or import users into auth_users table and then send them e-mails with temp passwords that they could change to login into my app. I know it is not the most secure way but so far this is the only solution. How could I achieve that? Or what would be the best way to

[web2py] Re: 1 field with 2 different represent

2018-04-23 Thread Leonel Câmara
Represent can return anything you want. You can make your represent function return a dict, list, tuple or whatever, there you can have the telephone represented as a whatsapp link and as a regular telephone link. from gluon.storage import Storage import urllib def phone_representer(value,

[web2py] Re: 1 field with 2 different represent

2018-04-23 Thread Anthony
> > Then in a view you could do something like: > > {{=record.mobile_phone.whatsapp}} > Keep in mind that the represent function is not applied when adding an individual field to the view like that -- you would need to use the rows.render() method, or something like:

[web2py] Re: Login not working on smartphone - no the same menu layout

2018-04-23 Thread Nico de Groot
Maybe the same error (and fix) as in https://groups.google.com/forum/m/?utm_source=digest_medium=email#!topic/web2py/j07rLhwFaqA -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

Re: [web2py] Re: SyntaxError: table already defined: definition

2018-04-23 Thread Anthony
On Sunday, April 22, 2018 at 3:48:14 PM UTC-4, Maurice Waka wrote: > > *module:#define code* > > from gluon import current > from pydal import DAL, Field > db = current.db > As noted here

Re: [web2py] Re: web2py 2.16.1 and login menu on mobile systems NOT WORKING

2018-04-23 Thread Anthony
On Monday, April 23, 2018 at 7:35:35 AM UTC-4, Andrea Fae' wrote: > > I'm sorry. What is "in trunk"? > That just refers to the master branch on Github (I think the term "trunk" is more commonly used in the context of the Subversion version control system to represent the "main line" of

Re: [web2py] Re: SyntaxError: table already defined: definition

2018-04-23 Thread Anthony
On Sunday, April 22, 2018 at 7:23:45 PM UTC-4, Maurice Waka wrote: > > I solved the thread.local error by declaring the > rows=db(db.health).select() as a global object in my code. > That's OK in a model (but not at the top level of a module) if you really need it on every request, but wasteful

Re: [web2py] Re: Get rows by id list keeping the order

2018-04-23 Thread Carlos Cesar Caballero Díaz
Thanks Leonel, that sounds interesting, I will take a look. Greetings. El 23/04/18 a las 11:30, Leonel Câmara escribió: I would make a function that automatically generated case statements for the orderby | defmake_orderby(idlist):     result="CASE" fori,el inenumerate(idlist):        

Re: [web2py] Re: web2py 2.16.1 is OUT

2018-04-23 Thread Carlos Cesar Caballero Díaz
Hi, after replacing there are no changes, the message appears again. I have also noted that in my system is happening with python 2.7 too. El 23/04/18 a las 11:48, Richard Vézina escribió: In gluon/fileutil.py Richard On Mon, Apr 23, 2018 at 11:47 AM, Richard Vézina

Re: [web2py] Re: web2py 2.16.1 is OUT

2018-04-23 Thread Richard Vézina
In gluon/fileutil.py Richard On Mon, Apr 23, 2018 at 11:47 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > The python3 welcome.w2p creation issue?? > > I think it a dependency issue that might be obufuscated by _compat.py > > You can try to replace this line : > >

Re: [web2py] Re: web2py 2.16.1 is OUT

2018-04-23 Thread Richard Vézina
The python3 welcome.w2p creation issue?? I think it a dependency issue that might be obufuscated by _compat.py You can try to replace this line : w2p_pack('welcome.w2p', 'applications/welcome') By w2p_pack('welcome.w2p', 'applications', 'welcome') And report here if it help... Richard On

[web2py] Re: Get rows by id list keeping the order

2018-04-23 Thread Leonel Câmara
I would make a function that automatically generated case statements for the orderby def make_orderby(idlist): result="CASE" for i, el in enumerate(idlist): result += " WHEN id = %d THEN '%d' " % (el, i) result += " ELSE id END ASC" return result I have not tested

Re: [web2py] Re: web2py 2.16.1 is OUT

2018-04-23 Thread Carlos Cesar Caballero Díaz
I have the same issue, using the current master branch in Ubuntu. Greetings. El 21/04/18 a las 08:21, Richard Vézina escribió: Actually I can't reproduced... It could it be a permission error?? Try to clone it fresh some where you have full access with this command : git clone --recursive

[web2py] Re: Insert not inserting data

2018-04-23 Thread Leonel Câmara
If you put it into a controller web2py automatically commits the transaction. If you're doing this from the command line you need to to db.commit() -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

Re: [web2py] Re: web2py 2.16.1 is OUT

2018-04-23 Thread Carlos Cesar Caballero Díaz
Ok, I have found the issue: Traceback (most recent call last):   File "/home/carlos.caballero/test/w2ptest/gluon/fileutils.py", line 270, in create_welcome_w2p     os.unlink('NEWINSTALL') FileNotFoundError: [Errno 2] No such file or

Re: [web2py] Re: web2py 2.16.1 is OUT

2018-04-23 Thread Richard Vézina
Yeah this file is not there when we clone web2py... But I just check and it's there when you download web2py build from web2py.com... What's weird is that I didn't have the issue... Richard On Mon, Apr 23, 2018 at 12:39 PM, Carlos Cesar Caballero Díaz < carlos.caball...@cfg.jovenclub.cu> wrote:

Re: [web2py] Re: web2py 2.16.1 is OUT

2018-04-23 Thread Richard Vézina
I guess we could had a simple "try" there... Richard On Mon, Apr 23, 2018 at 1:26 PM, Richard Vézina wrote: > Yeah this file is not there when we clone web2py... But I just check and > it's there when you download web2py build from web2py.com... > > What's weird

Re: [web2py] Re: web2py 2.16.1 is OUT

2018-04-23 Thread Richard Vézina
Actually it already inside a try... And it only logging an error... Should this be an error or a warning?? I guess this is done for the appadmin to allow it to create new app as it base on welcome... The welcome template is provision at first web2py run once install and derived from the welcome

Re: [web2py] bulk update...

2018-04-23 Thread Richard Vézina
Note to my self : Yes it possible... db(db.table.id > 0).update(field_to_be_updated=db.table. some_other_table_field*db.table. another_table_field) Doh! Richard On Mon, Apr 23, 2018 at 2:58 PM, Richard wrote: > Hello, >

[web2py] Re: Insert not inserting data

2018-04-23 Thread Kenneth
This is in an normal controller, no command line. And still it is not working. Everything around it works. And I can't understand how MySQL ID auto increment is getting higher and higher but no data is entered. Almost like data is inserted but deleted right away. I even tried putting in the

[web2py] bulk update...

2018-04-23 Thread Richard
Hello, Do we (if not : could we) support this use case : db(db.table.id > 0).update(field_to_be_updated=some_other_table_field*another_table_field) db.commit() So we don't have to : rows = db(db.table.id > 0).select(db.table.ALL) for row in rows: db(db.table.id = row.id).update(...) ???

Re: [web2py] Multiple domains nginx/uwsgi?

2018-04-23 Thread Richard Vézina
It depends, are you going to have SSL certificates??, 1 or multiples?? If you reuse the same I suggest you configure your different site with individual subdomain name and create a single certificate for all the subdomain. If you have single certificate, so multiple certificate for same IP, you

[web2py] Multiple domains nginx/uwsgi?

2018-04-23 Thread pbreit
What's the current advice on running multiple domains on one server having setup with this script: https://github.com/web2py/web2py/blob/master/scripts/setup-web2py-nginx-uwsgi-ubuntu.sh -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Query JSON Field

2018-04-23 Thread jacqueline . welham
Hello, I'm wondering if there is a way to query a JSON object once its been inserted into a SQLite table? I have a Program table with a column : Field('performance_json', type='json') and I'm trying to query based on this JSON's data within a simple JSON object

Re: [web2py] Multiple domains nginx/uwsgi?

2018-04-23 Thread Richard Vézina
The most complicated part is to properly craft the OpenSSL command to properly get you SSL certificate to be signed, but if you use Lets Encrypt, I guess it easier then... I answer an other thread recently with the command that I had use for multiple subdomain certificate, that I had work an lot

[web2py] Re: Insert not inserting data

2018-04-23 Thread Anthony
Can we get more context? What does the real code look like (I assume you don't really have a line at the top level of a controller file that inserts the same hard-coded record on every request to the controller)? How are you determining that no new records are inserted but the id is

Re: [web2py] Multiple domains nginx/uwsgi?

2018-04-23 Thread pbreit
I was thinking something like that. I occasionally run across the uwsgi "vassals" thing and was wondering if I should be doing that. Just started using Lets Encrypt (with Digital Ocean HowTo) which seems to be working OK. Will see upon renewal. Thx. -- Resources: - http://web2py.com -

[web2py] Re: 1 field with 2 different represent

2018-04-23 Thread 黄祥
thanks all, will try it best regards, stifan On Monday, April 23, 2018 at 10:06:52 PM UTC+7, Anthony wrote: > > Then in a view you could do something like: >> >> {{=record.mobile_phone.whatsapp}} >> > > Keep in mind that the represent function is not applied when adding an > individual field to

[web2py] Re: Query JSON Field

2018-04-23 Thread Anthony
On Monday, April 23, 2018 at 9:18:02 PM UTC-4, jacqueline.wel...@gmail.com wrote: > > Hello, > > I'm wondering if there is a way to query a JSON object once its been > inserted into a SQLite table? > I have a Program table with a column : > > Field('performance_json', >