[web2py] Re: Problem with DAL query self join

2012-09-20 Thread Massimo Di Pierro
If you send me the models I wil try it. On Thursday, 20 September 2012 09:40:01 UTC-5, Pradeeshnarayan wrote: > > I have rechecked again. There is a valid field rlord in tbl_objects. > > You can see the field 'tbl_objects.rlord' in the 6th line of SQL query. > SQL is working fine. > > In the erro

[web2py] Re: Problem with DAL query self join

2012-09-20 Thread Pradeeshnarayan
I have rechecked again. There is a valid field rlord in tbl_objects. You can see the field 'tbl_objects.rlord' in the 6th line of SQL query. SQL is working fine. In the error description I have noticed a difference. " File "/var/www/vhosts/astrozon/web2py/applications/astrozon/controllers/hor

[web2py] Re: Problem with DAL query self join

2012-09-20 Thread Massimo Di Pierro
I do not not know but in the DAL query I see: db.tbl_objects.rlord In the original query I see tbl_objects.horid and tbl_alt_objects.rlord but not tbl_objects.rlord. I do not know the model but I suspect you simply have some typos. On Thursday, 20 September 2012 06:35:31 UTC-5, Pradeeshnarayan

Re: [web2py] Re: Problem with DAL and Postgres

2011-02-08 Thread Bernardo Botella Corbí
Hi Massimo, tested like that, and still the same error. Bernardo 2011/2/8 Massimo Di Pierro > Your problem is that this: > > Field('password', 'password', '''length=512, ''', readable=False, > label='Password'), > > should be > > Field('password', 'password', length=512, readable=False, > labe

Re: [web2py] Re: Problem with DAL and Postgres

2011-02-08 Thread m momin
stop message services

[web2py] Re: Problem with DAL and Postgres

2011-02-08 Thread Massimo Di Pierro
Your problem is that this: Field('password', 'password', '''length=512, ''', readable=False, label='Password'), should be Field('password', 'password', length=512, readable=False, label='Password'), On Feb 8, 2:36 am, Bernardo Botella Corbí wrote: > Hi Massimo, > > please find attached the o

Re: [web2py] Re: Problem with DAL and Postgres

2011-02-07 Thread Bernardo Botella Corbí
Dear Massimo, I've been busy today. I'll post it as soon as possible. thanks for your help, Bernardo 2011/2/7 Massimo Di Pierro > I am very puzzled. > > In gluon/dal.py there is this line: > > field.length = min(field.length,self._db and > self._db._adapter.maxcharlength or INFINITY) > > can y

[web2py] Re: Problem with DAL and Postgres

2011-02-07 Thread ron_m
Why is this line Field('password', 'password', '''length=512, ''', readable=False, label='Password'), should be Field('password', 'password', length=512, readable=False, label='Password'),

[web2py] Re: Problem with DAL and Postgres

2011-02-07 Thread Massimo Di Pierro
I am very puzzled. In gluon/dal.py there is this line: field.length = min(field.length,self._db and self._db._adapter.maxcharlength or INFINITY) can you print field.length before and field.length after this statement? Massimo On Feb 7, 3:06 am, Bernardo wrote: > Sure Massimo, here it goes: >

[web2py] Re: Problem with DAL and Postgres

2011-02-07 Thread Bernardo
Sure Massimo, here it goes: db.define_table(auth.settings.table_user_name, Field('first_name', length=128, default=''), Field('last_name', length=128, default=''), Field('username', length=128, default=''), Field('email', length=128, default='', unique=True), Field('password',

[web2py] Re: Problem with DAL and Postgres

2011-02-06 Thread Massimo Di Pierro
Can you show your custom auth_user. I am still puzzled by the error. On Feb 6, 4:21 pm, Bernardo Botella Corbí wrote: > Yes, the error is on my custom auth_user table. So, Do I reduce the leght > numbers? > > Bernardo > > 2011/2/6 Massimo Di Pierro > > > > > > > > > Do you have a custom auth_use

Re: [web2py] Re: Problem with DAL and Postgres

2011-02-06 Thread Bernardo Botella Corbí
Yes, the error is on my custom auth_user table. So, Do I reduce the leght numbers? Bernardo 2011/2/6 Massimo Di Pierro > Do you have a custom auth_user table? Is seems to miss a length > attribute and default to a number too large. I changed the default to > 32768 in trunk but I am not sure. >

[web2py] Re: Problem with DAL and Postgres

2011-02-06 Thread Massimo Di Pierro
Do you have a custom auth_user table? Is seems to miss a length attribute and default to a number too large. I changed the default to 32768 in trunk but I am not sure. On Feb 6, 3:13 pm, Bernardo wrote: > Dear all, > > I am using web2py 1.91.6 and last version of Ubuntu. A model which > works per

[web2py] Re: problem with dal

2011-01-15 Thread luifran
Thank you, I've fixed it with: actividad_id=actividad[0].id riesgo_id=riesgo[0].id On 15 ene, 12:45, Massimo Di Pierro wrote: > perhaps > > (db.actividades_riesgos.riesgos==riesgo) > > should be > > (db.actividades_riesgos.riesgos==riesgo.first().id) > > On Jan 15, 5:24 am, luifran wrote: > >

[web2py] Re: problem with dal

2011-01-15 Thread Massimo Di Pierro
perhaps (db.actividades_riesgos.riesgos==riesgo) should be (db.actividades_riesgos.riesgos==riesgo.first().id) On Jan 15, 5:24 am, luifran wrote: > db.define_table('actividades_riesgos',Field('actividades',db.actividades),F > ield('riesgos',db.riesgos)) > > actividad=db(db.actividades.nombre=