[web2py] MySQL DB reads have stopped working for one table in a background process

2012-07-24 Thread David Phillips
On the eve of delivering a project to a client, I've come up against a problem that has me stumped. select() statements on one of my mysql tables have stopped working. My application is a web2py web server and a background process (also called a homemade task queue in the web2py book). They

Re: [web2py] MySQL DB reads have stopped working for one table in a background process

2012-07-25 Thread David Phillips
I think you have hit on the issue. I added a db.commit() call before I attempted to read from the table and the read was successful. Thanks so much. David On Jul 24, 2012, at 11:16 PM, Massimo Di Pierro wrote: > First of all we need to establish there is a problem and this is not the > expec