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
