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 <massimo.dipie...@gmail.com>
> 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 <estem...@gmail.com> wrote:
> > 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', 'password', '''length=512, ''', readable=False,
> > label='Password'),
> > Field('registration_key', length=512, writable=False,
> > readable=False, default=''),
> > Field('reset_password_key', length=512, writable=False,
> > readable=False, default=''),
> > Field('registration_id', length=512, writable=False,
> > readable=False, default=''),
> > Field('imagen', 'upload', requires=IS_IMAGE()),
> > Field('texto_descriptivo', 'text'),
> > Field('activado', 'boolean', default=True, readable=False,
> > writable=False),
> > Field('karma', 'double', default=0, readable=False,
> > writable=False),
> > Field('acepta_registro', 'boolean', requires=IS_IN_SET(['on'],
> > error_message=T('You must accept the license terms.')), label=XML(T('I
> > \'ve read and I accept the ') + A(T('license terms'),
> > _href=URL('default', 'texto_registro'), _target='new')))
> > )
> >
> > On 7 feb, 05:09, Massimo Di Pierro <massimo.dipie...@gmail.com> wrote:
> >
> >
> >
> >
> >
> >
> >
> > > Can you show your custom auth_user. I am still puzzled by the error.
> >
> > > On Feb 6, 4:21 pm, Bernardo Botella Corbí <estem...@gmail.com> 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 <massimo.dipie...@gmail.com>
> >
> > > > > 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 <estem...@gmail.com> wrote:
> > > > > > Dear all,
> >
> > > > > > I am using web2py 1.91.6 and last version of Ubuntu. A model
> which
> > > > > > works perfectly using sqlite database, throws an error when using
> a
> > > > > > postgres database:
> >
> > > > > > ProgrammingError: syntax error at or near "10000000000"
> > > > > > LINE 1: ALTER TABLE auth_user ADD password VARCHAR(10000000000);
> >
> > > > > > posible bug in new DAL?
> >
> > > > > > Thanks a lot for your help,
> > > > > > Bernardo
>
