Bug #12914 php5 with phpMyAdmin won't browse tables, Apache crash
Submitted: 31 Aug 2005 15:59 Modified: 31 Aug 2005 16:08
Reporter: Andre Bruijn Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:php5 OS:Windows (xp)
Assigned to: CPU Architecture:Any

[31 Aug 2005 15:59] Andre Bruijn
Description:
phpMyAdmin has a 'browsing tables' problem after update to php5, and even Apache crashes.
The error.log says: [notice] Parent: child process exited with status 3221225477 -- Restarting. 

Signature of failure window:
szAppName : Apache.exe     szAppVer : 2.0.48.0     szModName : php5ts.dll     
szModVer : 5.1.0.0     offset : 00005b1c

After updating from php4(4.3.10.10) to php5 (5.0.0.4) I met the problem.
I tried also php5 version 5.1.0.0. but that gives me no result.
What I still can do is creating a table and inserting a row, but I cann't browse.
All other php applications work fine.
I do have the problem with versions phpMyAdmin 2.5.6 and version 2.6.3-pl1.
For MySql I used only mysql-4.0.18. The Apache version is 2.

This is the query:
http://localhost/phpMyAdmin/sql.php?lang=en-iso-8859-1&server=1&db=adressenboek&table=adre....

php&back=tbl_properties_structure.php&sql_query=SELECT+%2A+FROM+%60adressen%60

After clearing the Apache status window for 3 times I do get 3 restarts; you can see this on the error.log:
[Tue Aug 30 18:00:22 2005] [notice] Parent: child process exited with status 3221225477 -- Restarting.
[Tue Aug 30 18:00:22 2005] [notice] Parent: Created child process 2072
[Tue Aug 30 18:00:23 2005] [notice] Child 2072: Child process is running
[Tue Aug 30 18:00:23 2005] [notice] Child 2072: Acquired the start mutex.
[Tue Aug 30 18:00:23 2005] [notice] Child 2072: Starting 250 worker threads.
[Tue Aug 30 18:00:28 2005] [notice] Parent: child process exited with status 3221225477 -- Restarting.
[Tue Aug 30 18:00:29 2005] [notice] Parent: Created child process 5244
[Tue Aug 30 18:00:29 2005] [notice] Child 5244: Child process is running
[Tue Aug 30 18:00:29 2005] [notice] Child 5244: Acquired the start mutex.
[Tue Aug 30 18:00:29 2005] [notice] Child 5244: Starting 250 worker threads.
[Tue Aug 30 18:00:33 2005] [notice] Parent: child process exited with status 3221225477 -- Restarting.
[Tue Aug 30 18:00:34 2005] [notice] Parent: Created child process 1816
[Tue Aug 30 18:00:34 2005] [notice] Child 1816: Child process is running
[Tue Aug 30 18:00:34 2005] [notice] Child 1816: Acquired the start mutex.
[Tue Aug 30 18:00:34 2005] [notice] Child 1816: Starting 250 worker threads.

When not any row is found in the table, the error does not happen.

httpd.conf:
PHPIniDir "C:/php"
LoadModule php5_module "c:/php/php5apache2.dll" 
Addtype application/x-httpd-php .php

php.ini:
memory_limit = 16M
extension_dir = "c:/php/ext" (I tried too: "c:/php/ext/")
extension=php_gd2.dll
extension=php_mysql.dll

Someone any idea?
Andre Bruijn

How to repeat:
I do not have an idea
[31 Aug 2005 16:08] Jorge del Conde
Hi!

Please take this issue up with the PHP guys