I pushed a revision that should allow you todo:
DAL(..., driver_args={'cursor_buffered': True})"
(UNTESTED!)
On Saturday, 15 February 2020 03:32:05 UTC-8, Giovanni B. wrote:
>
> 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:password@127.0.0.1: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 web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/058feb5e-977b-47a2-91d4-bea6c3d6600a%40googlegroups.com.
