What changed? Did you upgrade? What web2py version? When you say the select does not work anymore, dwhat do you mean? Does it lock or do you get a traceback? Which database driver? People have reported problems with pymysql but not with mysqldb.
On Tuesday, 24 July 2012 19:42:29 UTC-5, David Phillips wrote: > > 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 share the database. > The web server writes to the table from within an HTTP request, and several > seconds later, I attempt to read the record in my background process. > > Up until yesterday, I didn't have any trouble reading from this or any of > the tables. And now, all the others work fine. I can still write and read > from the misbehaving table from the web server. > > I am at a loss. I'm not sure where to look to diagnose the problem. Any > pointers would be gratefully received. > --