so the simple solution is to disable the button after the call until the results are returned bastien> Date: Fri, 9 Nov 2007 15:02:31 -0500> From: mthayer@xxxxxxxxxxxxxxx> To: php-db@xxxxxxxxxxxxx> Subject: Corrupted query results in memory.> > I posted an issue to the mysql dev forums last week with regards to an> issue we are encountering. The issue as we understood it last week was> simple...after some time (undetermined as of then) query results from> the web app (a PHP/MySQL/Javascript Ajax app.) would come back all> 'wonky.' Upon issuing a mysql-server restart the data would be fine,> and query results back to normal. This morning I figured out how to> replicate the issue. Issue a double request for the mysql result set.> Due to the "Ajaxy" nature of my web app it isn't the same as a double> HTTPRequest of POST, as it is requesting a result set back from the> database twice in a row before the response is collected.> > We run Apache 2.2 on FreeBSD 6.1.x, I am currently running MySQL> 5.0.x....given the fact that I can repeat and reproduce the problem by> either hitting my refresh button twice, or by hitting my javascript/Ajax> button twice before I get my first response....can anyone point me in a> direction to narrow down why my code might be doing this? I am using> PDO with prepared statements and MySQL stored procedures to produce my> result sets... if you asked me yesterday, I'd have said I wasn't doing> any thing that MySQL couldn't handle...but apparently that isn't the> case...> > Max H. Thayer> Software Developer> Center for High-Throughput Structural Biology> > Hauptman-Woodward Medical Research Inst.> 700 Ellicott St.> Buffalo, NY 14203> Phone: 716-898-8637> Fax: 716-898-8660> http://www.chtsb.org <http://www.chtsb.org/> > http://www.hwi.buffalo.edu <http://www.hwi.buffalo.edu/> > _________________________________________________________________ Send a smile, make someone laugh, have some fun! Start now! http://www.freemessengeremoticons.ca/?icid=EMENCA122
