Thanks Yan, i will use your example if i cant fix this. I can confirm the problem on Version 2.15.3-stable+timestamp.2017.08.07.12.51.45.
This is dal declaration working fine on previous versions db = DAL("mysql://myuser:mypassw@localhost/myapp", pool_size = 10, check_reserved=False, migrate = True) # db._adapter.types = copy.copy(db._adapter.types) db._adapter.types['boolean']='TINYINT(1)' db._adapter.TRUE = 1 db._adapter.FALSE = 0 And to reproduce the problem, create a table with a boolean field and insert a record: data = {"user": 1, "visible": True} db.app_links.insert(**data) C:\Users\User\Desktop\myapp\gluon\contrib\pymysql\cursors.py:166: Warning: ( 13 66, u"Incorrect integer value: 'T' for column 'visible' at row 1") result = self._query(query) C:\Users\User\Desktop\myapp\gluon\contrib\pymysql\cursors.py:166: Warning: ( 13 66, u"Incorrect integer value: 'T' for column 'configurable' at row 1") result = self._query(query) 6L I dont remember having this problem before. Is it a bug? -- 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.