Re: [web2py] Re: Switching database backend from sqlite to mysql

2018-02-04 Thread JONATHAN BURKERT
Adding the line `db._adapter.reconnect()` to the top of the function seems to have solved the problem. Thanks so much for the help. On Sun, Feb 4, 2018 at 4:02 AM, LoveWeb2py wrote: > Hi Massimo, > > Thank you for responding. Do you have an example? I am having the same > struggle. > > Thank you

[web2py] Re: Switching database backend from sqlite to mysql

2018-02-04 Thread LoveWeb2py
Hi Massimo, Thank you for responding. Do you have an example? I am having the same struggle. Thank you again. On Sunday, February 4, 2018 at 12:46:08 AM UTC-5, Massimo Di Pierro wrote: > > I believe the problem is that pydal is designed to not allow db to be > shared among multiple threads to

[web2py] Re: Switching database backend from sqlite to mysql

2018-02-03 Thread Massimo Di Pierro
I believe the problem is that pydal is designed to not allow db to be shared among multiple threads to avoid concurrency issues. Every thread should make its own db object or, if you pass db around, you should call db.reconnect in each thread. On Saturday, 3 February 2018 22:14:41 UTC-6, jbur..

[web2py] Re: Switching database backend from sqlite to mysql

2018-02-03 Thread jburker
The attached file contains the code that is generating the error, line 4 specifically is called out in the traceback, but if I comment this line out I get the same error from the next line that is querying the database. If I start a web2py shell, I can copy and paste the offending line into the

[web2py] Re: Switching database backend from sqlite to mysql

2018-02-03 Thread LoveWeb2py
Can you share some of your code from the controller where you're receiving the error? On Friday, February 2, 2018 at 7:31:59 AM UTC-5, jbu...@wgu.edu wrote: > > > I currently have a mysql database that is defined using pydal and used by > several other applications. I am trying to use Web2py to