RE: [PHP-DB] Corrupted query results in memory.

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