Could you try to print the value of sqlrows.colnames in sqlhtml? What database are you using?
2014-03-10 18:22 GMT+01:00 drayco <[email protected]>: > With the change, this is the result > > File "/home/drayco/web2py/applications/movil/controllers/cobros.py" > <https://sys.luzo.mx/admin/default/edit/movil/controllers/cobros.py>, line > 335, in pagos > select(db.pagos.id.count()), headers={db.pagos.id.count():'Total Pagos'}) > File "/home/drayco/web2py/gluon/sqlhtml.py", line 2929, in __init__ > > columns = > ['.'.join(sqlrows.db._adapter.REGEX_TABLE_DOT_FIELD.match(c).groups()) for c > in sqlrows.colnames] > AttributeError: 'NoneType' object has no attribute 'groups' > > > But the problem persist, do you have other idea? > > And repeat, that kind of code works in web2py 2.8.3 > > El viernes, 7 de marzo de 2014 14:00:40 UTC-6, drayco escribió: > >> All code work with web2py 2.8.3 but when we upgrade to web2py 2.9.4, we >> use extensive SQLTABLE and in this moment we have a lot of errors similar to >> >> File "/home/drayco/webapps/newconfig/web2py/gluon/sqlhtml.py", line 2929, in >> __init__ >> columns = >> ['.'.join(sqlrows.db._adapter.REGEX_TABLE_DOT_FIELD.match(c).groups()) for c >> in sqlrows.colnames] >> AttributeError: 'NoneType' object has no attribute 'groups' >> >> >> This is our code >> >> totalPagos = SQLTABLE(db((db.pagos.created_on>inicio)&(db.pagos.created_ >> on<fin)).\ >> select(db.pagos.id.count()), >> headers={'COUNT(pagos.id)':'Total Pagos'}) >> >> What can we do? >> >> Can you help me please? >> > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
