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 [email protected].
For more options, visit https://groups.google.com/d/optout.
