Fixed in trunk. Please check it.
On Oct 12, 11:59 am, Massimo Di Pierro <massimo.dipie...@gmail.com>
wrote:
> Please open a ticket. Looks like a bug but it can be fixed in 12hrs.
>
> On Oct 12, 10:31 am, chris_g <chrisgu...@gmail.com> wrote:
>
>
>
>
>
>
>
> > I am trying to define a custom type on a MySQL db and I get the error
> > below. My motivation is to store data in Bigint rather than Integer.
>
> > bigint = SQLCustomType(
> > type = 'integer',
> > native = 'bigint',
> > )
>
> > db.define_table('s1',
> > Field('target_id', bigint)
> > )
> > db.s1.insert(target_id=55142201924)
>
> > I presume that I don't need to specify an encoder or a decoder.
> > The table creation is fine, but subsequent insert statements fail.
> > Once the tables are created, I can replace bigint with 'integer' and
> > everything works smoothly.
> > But I'm wondering if I am missing something crucial in my db.py .
>
> > Traceback (most recent call last):
> > File "/home/www-data/web2py.1.99.2/gluon/restricted.py", line 194,
> > in restricted
> > exec ccode in environment
> > File "/home/www-data/web2py.1.99.2/applications/groupiedev/models/
> > db.py", line 84, in <module>
> > db.s1.insert(target_id=55142201924)
> > File "/home/www-data/web2py.1.99.2/gluon/dal.py", line 4976, in
> > insert
> > return self._db._adapter.insert(self,self._listify(fields))
> > File "/home/www-data/web2py.1.99.2/gluon/dal.py", line 880, in
> > insert
> > query = self._insert(table,fields)
> > File "/home/www-data/web2py.1.99.2/gluon/dal.py", line 876, in
> > _insert
> > values = ','.join(self.expand(v,f.type) for f,v in fields)
> > TypeError: sequence item 0: expected string, int found
