Hi Massimo,
tested like that, and still the same error.
Bernardo
2011/2/8 Massimo Di Pierro <massimo.dipie...@gmail.com>
> 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í <estem...@gmail.com> wrote:
> > Hi Massimo,
> >
> > please find attached the output you asked for. I must say that it works
> > using mysql.
> >
> > regards,
> > 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
> >
> >
> >
> > output.txt
> > 66KViewDownload
