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
