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
