[web2py] Specific validation on custom auth user table

Hello, I am new in python and web2py also. I tryed to create a custom auth because I have a project and it is needing a lot validation on user creation action. I need to validate the birthdate and it is needing to be >= 18 from today. So, I tried to create a requires like: custom_auth_table.d

[web2py] Problems with DAL and mysql

Hello everybody! I am developing using directly to Mysql. For testing with some scripts, I was using python interpreter and defining only tables that it was needed. But I have a problem today, when I went to appadmin to check some data, I lost the tables, I mean, I had 18 tables and passed to

[web2py] Deploy with postgresql

Hi people! I just almost in go-live. So, I tried to create a Postgresql database and starting to configure some config tables for my appliacation, but I had the error below. Traceback (most recent call last): File "/home/andre/Dropbox/Projetos/web2py/applications/87k/controllers/appadmin

[web2py] Re: Deploy with postgresql

much! BR Em segunda-feira, 5 de setembro de 2016 04:33:49 UTC-3, Niphlod escreveu: > > seemingly no response was given to a simple "how many records are there". > sure the tables have been created ? > > On Sunday, September 4, 2016 at 3:55:54 PM UTC+2, Morganti wrote:

[web2py] Re: Deploy with postgresql

for > production use). > > > On Monday, September 5, 2016 at 12:17:18 PM UTC+2, Morganti wrote: >> >> Hi! >> >> In appadmin the tables are there but, checking in pgadmin3 them aren´t >> there. Looks like they were not being created. But, the database is

[web2py] Using jquery and ajax to change form input fields

Hi guys, I have some extra felds no auth_user. I need to complete some fields after one filled in. I am able to read this field using jquery..blur and using ajax to collect these fields from a external webservice and putting the results on hidden div and input fiedls. Now I need to use these i

[web2py] Re: Using jquery and ajax to change form input fields

tting it. Thanks a lot your supporting. Best regards André Em sexta-feira, 27 de janeiro de 2017 18:00:57 UTC-2, Val K escreveu: > > you do an *ajax *request and *immediately * try to use ajax-results > look for $.ajax() in jQuery docs > > On Friday, January 27, 2017 at 5:48:59 PM UTC

[web2py] Re: Using jquery and ajax to change form input fields

de 2017 19:36:24 UTC-2, Val K escreveu: > > str() - doesn't work with uincode - try > unicode(session.cep['logradouro']) or unicode(session.cep['logradouro'], > 'utf-8') > > On Friday, January 27, 2017 at 11:51:49 PM UTC+3, Morganti wrote:

[web2py] Re: Using jquery and ajax to change form input fields

changed from 'utf-8' to > 'latin-1' > > On Saturday, January 28, 2017 at 4:07:32 PM UTC+3, Morganti wrote: >> >> Hi, >> >> Your suggestion was not enouth, still not running, but, I used the idea >> and studied more and got the solution. >

[web2py] Helping with dropdown list using query

, in widget options = requires[0].options() File "/home/andre/Dropbox/Projetos/web2py/gluon/validators.py", line 600, in options self.build_set() File "/home/andre/Dropbox/Projetos/web2py/gluon/validators.py", line 575, in build_set fields = [table[k] for k in self

[web2py] Invalid view even created it before

Hello, I am started to learn web2py some weeks ago. After created some controllers and models using the generic view. I tried to deploy to PythonAnywhere to test it and, of course, I know or use disable generic only localhost or create the specific views. First I tried to disable the localhost

[web2py] Re: Helping with dropdown list using query

Hi, Thanks your helping. I got it running as expected. BR Morganti Em sexta-feira, 22 de abril de 2016 15:45:53 UTC-3, 黄祥 escreveu: > > pls try : > db.servicos_feitos.servico_feito.requires = > IS_IN_DB(db((db.servico_oficina.id_salao == auth.user_id) & > (db.servico_of

Re: [web2py] Invalid view even created it before

So, what is it missing? Thanks in advance. BR Morganti Em segunda-feira, 25 de abril de 2016 06:57:18 UTC-3, Johann Spies escreveu: > > Hallo André > > On 25 April 2016 at 11:49, Morganti > > wrote: > > >> Hello, >> >> I am started to learn web2py some

Re: [web2py] Invalid view even created it before

No! I saved the view in the .../view folder, no I moved it to .../view/default Thanks a lot your support! Best regards Morganti Em segunda-feira, 25 de abril de 2016 09:08:34 UTC-3, Anthony escreveu: > > And the path to the view is /views/default/novo_cliente.html? > > On Mond

[web2py] Error using Postgres

Hello, I have a VPS using ubuntu 16.04, nginx, Postgres and web2py 2.16.1. I tried to execute one controller that populate some tables and got the error below. Then, I used that command to create a csv file with all tables and uploaded it in my desktop using SQLITE and no error were found. Th

Re: [web2py] Error using Postgres

...@gmail.com > Brasil > > > 2018-02-22 12:40 GMT-03:00 Morganti >: > >> Hello, >> >> I have a VPS using ubuntu 16.04, nginx, Postgres and web2py 2.16.1. >> >> I tried to execute one controller that populate som

Re: [web2py] Error using Postgres

to do it. Thanks a lot your support! Best regards Andre Em quinta-feira, 22 de fevereiro de 2018 18:30:17 UTC-3, Dave S escreveu: > > > > On Thursday, February 22, 2018 at 8:29:43 AM UTC-8, Morganti wrote: >> >> Hi, thanks your time. >> >> How can I check it? If I tr

Re: [web2py] Error using Postgres

now. It is there and we distribute it but we will remove it in the next > version. > I run into lots of problems with it, even with simple apps. psycopg2 works > instead. > > > On Friday, 23 February 2018 04:57:41 UTC-6, Morganti wrote: >> >> Hi Dave, >> >>

Re: [web2py] Error using Postgres

s André Em domingo, 25 de fevereiro de 2018 21:02:54 UTC-3, Massimo Di Pierro escreveu: > > If it finds psycopg2 it should be using it over pg8000. Is t possible you > have two versions of python installed? > > > > On Sunday, 25 February 2018 04:46:57 UTC-6, Morganti wrote: >

Re: [web2py] Error using Postgres

Hi, The last command before the error in line 54 'for row in rows:' is a selection using 'iterselect'. I changed the 'iterselect' to 'select' and no more errors. Thanks Massimo, Ovidio and Daves. Best regards André Em terça-feira, 27 de fevereiro d

[web2py] Error in all functions that I use SQLFORM.grid

Hi people, I have an application that is being used in production almost one year. Today I was making an update in local development environemnt and got the error below. I tried to use other functions where the SQLFORM.grid is used too and got the same error. Traceback (most recent call last)

[web2py] Help with an error:

Hi guys, I am having the error below: Número do Ticket 187.122.40.48.2018-08-14.20-50-49.b4d5d6f0-071d-4f6b-aec3-1c662eb5ea0c function sum(character varying) does not exist LINE 1: SELECT SUM("ov_home"."valor") FROM "ov_home" WHERE ((("ov_ho... ^ HINT: No function matches the given name and a

[web2py] Re: Help with an error:

quot;valor" a numeric field? > > On Tuesday, August 14, 2018 at 8:13:44 PM UTC-4, Morganti wrote: >> >> Hi guys, >> >> I am having the error below: >> >> Número do Ticket >> >> 187.122.40.48.2018-08-14.20-50-49.b4d5d6f0-071d-4f6b-aec3-1c662e

[web2py] Re: ipython notebook and web2py

Hi, I am using the web2py version 2.15.4 and used the these intructions to use web2py with ipython. I am having the error below: if request.global_settings.web2py_version < "2.14.1": > 9 raise HTTP(500, "Requires web2py 2.13.3 or newer") 10 11 ## if SSL/HTTPS is properly confi

[web2py] Re: ipython notebook and web2py

1]. > strip() > > # Create the web2py environment. > environment = gluon.shell.env(app, import_models=True, c=controller, > dir=os.path.join(web2py_path, 'applications', app)) > folder = environment['request'].folder > if controller: >

[web2py] How to use IS_NOT_IN_DB

Hi, I am creating a form with SQLFORM.factory. I have a field 'username' and Field('username','string',requires=[IS_NOT_EMPTY(), IS_NOT_IN_DB(db,'auth_user.username')] and when try to use I am having the error: Validation error, field:username What's wrong? Thanks BR André -- Resources

Re: [web2py] Re: RuntimeError: table appears corrupted

Hi, I had these error now and I was not changing anything in scheme models. I just changed the logo file in models/menu.py. Is there any idea the reason of it? Thanks BR André Em sábado, 29 de dezembro de 2012 05:51:42 UTC-2, Richard Penman escreveu: > > Thanks - that did it. > > Any idea what

[web2py] Multiply forms per page

Hi guys, I created 2 forms like: form_e = SQLFORM.factory( Field('endereco', 'string', requires=IS_EMPTY_OR(IS_IN_SET(lista_enderecos,zero=None)),default=lista_enderecos[0]) ) form_h = SQLFORM.factory( Field('endereco','string',label='Home', requires=IS_EMPTY_OR(IS_IN_SET(l

[web2py] Re: Multiply forms per page

Guys, problem resolved. I got back an older backup and that is normal. Thanks André Em sexta-feira, 29 de dezembro de 2017 16:19:03 UTC-2, Morganti escreveu: > > Hi guys, > > I created 2 forms like: > > form_e = SQLFORM.factory( > Field('endereco', &#

[web2py] Getting error with login_bare

Hello friends, I am trying to user JWT but I am having a problem with login_bare. After some errors trying to use the solution suggested here https://groups.google.com/forum/#!topic/web2py/hWWMXazeEuc I tried to run manually the command: new_user = auth.login_bare('u...@email.com', 'my_pass')