Thank you Leonel, I actually have a very complex query, and it ran into the error I mentioned. In my query I have: db(query).select(other_fields, aggregate, groupby=...etc..., orderby=...etc ...)
and I ran into the error. So I tried to identify if it was my complex query throwing the error, my model or some other part, and over 4 hours (too long, I know...) I narrowed down to the aggregate, I tested specifically to the example provided by the web2py book. It still gave the same error. In my normal use-case, I have a "query", but it's still good to know and add to the book that it is deprecated. On Friday, July 14, 2017 at 8:17:11 AM UTC+8, Leonel Câmara wrote: > > Note this is deprecated: > > row = db().select(max) > > Calling db() like that without a query will break common filters for > instance. > -- 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.
