It only happens in version 1.99.7

in 1.99.1 works perfect

Only happens when the table or (i don't know if model) has a float or 
decimal field

That's what i ran:

In [66]: rows = db().select(db.fc_pago.ALL)
---------------------------------------------------------------------------
KeyError                                  Traceback (most recent call last)
/home/wasuaje/Documentos/desarrollo/web2py2/applications/flota/models/plugin_jqgrid.py
 
in <module>()
----> 1 rows = db().select(db.fc_pago.ALL)

/home/wasuaje/Documentos/desarrollo/web2py2/gluon/dal.pyc in select(self, 
*fields, **attributes)
   7576         adapter = self.db._adapter
   7577         fields = adapter.expand_all(fields, 
adapter.tables(self.query))
-> 7578         return adapter.select(self.query,fields,attributes)
   7579 
   7580     def delete(self):

/home/wasuaje/Documentos/desarrollo/web2py2/gluon/dal.pyc in select(self, 
query, fields, attributes)
   1318         limitby = attributes.get('limitby', None) or (0,)
   1319         rows = self.rowslice(rows,limitby[0],None)
-> 1320         return self.parse(rows,fields,self._colnames)
   1321 
   1322     def _count(self, query, distinct=None):

/home/wasuaje/Documentos/desarrollo/web2py2/gluon/dal.pyc in parse(self, 
rows, fields, colnames, blob_decode)
   1615                         colset = new_row[tablename]
   1616                     colset[fieldname] = value = \
-> 1617                         
self.parse_value(value,field.type,blob_decode)
   1618 
   1619                     if field.type == 'id':

/home/wasuaje/Documentos/desarrollo/web2py2/gluon/dal.pyc in 
parse_value(self, value, field_type, blob_decode)
   1494         else:
   1495             key = regex_type.match(field_type).group(0)
-> 1496             return self.parsemap[key](value,field_type)
   1497 
   1498     def parse_reference(self, value, field_type):

KeyError: 'float'


my model
#--------
db.define_table('fc_pago',
    Field('id','integer'),
    Field('fecha','date'),
    Field('total','double'), #tryed with decimal or float here in mysql is 
float
    Field('descripcion','string'),    
    Field('mt_persona_id','integer'),
    migrate=False)

db.fc_pago.mt_persona_id.requires = 
IS_IN_DB(db,db.mt_persona.id,'%(nombres)s %(apellidos)s' )
db.fc_pago.mt_persona_id.represent=lambda val: db.mt_persona[val].nombres



Database Mysql 

mysql  Ver 14.14 Distrib 5.5.22, for debian-linux-gnu (i686) using readline 
6.2

What's going on here?

Reply via email to