Re: Apache crashes every time I call mysqli_fetch_assoc()

-------- Original Message -------- Subject: [PHP-DB] Apache crashes every time I call mysqli_fetch_assoc() From: Bonger O <bongero@gmail.com> To: php-db@lists.php.net Date: 9.7.2008 19:32

Hi, I have set up an environment on my Vista laptop comprising of Apache 2.2, MySQL Server 5.1 and Php 5.2.5. I'm using a simple php program that I found in a PHP/SQL book. The PHP program queries a MySQL table and traverses the results array of the query and should display on screen. However, there seems to be a problem with my environment and as every time I run the program I get the error "*Apache HTTP server stopped working and was closed*". Below is the code I am using, but I have managed to narrow the problem down to *$row = mysqli_fetch_assoc($result);* For some reason this is causing the crash. Would there be any reason that this function cant be found perhaps? I really have no clue!!! I had similar problem running Apache 2.2, MySQL 5.1 and PHP 5.2.6. - I had crash everytime I tried to connect to MySQL. When I executed the script with php.exe it worked okay so I think there is some error in php5apache2_2.dll. I played with various versions of PHP and Apache but the error remained, entries in event log were still the same:

Application Failure Apache.exe 2.0.63.2 in php5ts.dll 5.2.6.6 at offset 0000abda Application Failure httpd.exe 2.2.9.0 in php5ts.dll 5.2.7.7 at offset 0000abda I havent found any solution (there are few bug reports on php.net) but they were closed because the bug was not "reproducable". I downgraded to MySQL 5.0 and everything works fine now.