Can you use db._timings to grab the generated SQL, both under 2.9.11 and 2.16.11, to see what the differences are?
Anthony On Saturday, May 12, 2018 at 11:20:50 AM UTC-4, 98uj...@gmail.com wrote: > > After update from web2py 2.9.11 (mysql 5.6.37) to web2py 2.16.11 (mysql > 5.6.40) the SQLFORM.smartgrid shows zero results and at the top right > displays a message: Query Not Supported: (1066, "Not unique table/alias: > 'labprice'"). > This same code works in 2.9.11: > db.labprice._common_filter = lambda query: > db.labprice.lp_term_date==None > db.labour._common_filter = lambda query: db.labour.lab_term_date==None > left=db.labprice.on(db.labour.lab_id==db.labprice.lp_lab_id) > orderby=[db.labour.lab_description] > form > =SQLFORM.smartgrid(db.labprice,left=left,fields=fields,headers=headers,paginate='all',maxtextlengths=maxtextlengths,maxtextlength=40, > > buttons_placement='left',links_placement='left',deletable=False,orderby=orderby,linked_tables=['repair']) > Enter code here... > > Any help in making it work in the newer version of web2py will be > appreciated. > Thanks > > -- 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.
