drayco, correct me if I'm wrong but it looks like you didn't make the change Niphlod suggested.
The error trace shows you still use db.pagos.id.count() rather than the suggested syntax. On Monday, March 10, 2014 1:22:04 PM UTC-4, drayco wrote: > > 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
