Hello!
I'm currently using pyDAL in a stand-alone application and I'm suffering a
problem while trying to interface my code to MySQL databases.
Let's take into account this simple code snippet:
from pydal import DAL, Field
db = DAL('mysql://user:[email protected]:3306/my_db')
db.define_table('my_table', Field('my_field_1', 'id'), Field('my_field_2',
'string'))
It raises the following exception:
mysql.connector.errors.InternalError: Unread result found
Poking around with Google, I have found that the problem can be solved by
setting buffered=True
in the mySQL cursor definition, however I actually don't know how to do
this within pyDAL.
Using Python 3.7.6, pyDAL 20191227.1, MySQL Community Server 8.0.16.
Any suggestions?
Thanks in advance!
--
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/2f2dc004-efa9-4414-8f73-3e6d4be4370c%40googlegroups.com.
