#40727 [Opn->Fbk]: Apache 2.2.4 + PHP/5.2.1 (same #40229)

ID: 40727 Updated by: tony2001@php.net Reported By: t_wiedmann at t-online dot de -Status: Open +Status: Feedback Bug Type: PDO related Operating System: window server 2003 PHP Version: 5.2.1 New Comment: Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If the script requires a database to demonstrate the issue, please make sure it creates all necessary tables, stored procedures etc. Please avoid embedding huge scripts into the report. Previous Comments: ------------------------------------------------------------------------ [2007-03-06 12:03:59] t_wiedmann at t-online dot de sorry, but I cannot show you this code, PLSQL, tables.. I think, it's some PDO problem if there is $stmt->bindParam(':p12', $nStatus, PDO::PARAM_INT | PDO::PARAM_INPUT_OUTPUT, 22 ); without any correspondent named parameters (':p12') in $sQuery. Many thanks Thomas ------------------------------------------------------------------------ [2007-03-06 10:45:11] tony2001@php.net I don't see any crash there and your code does not work - I don't have your PL/SQL procedures, tables etc. ------------------------------------------------------------------------ [2007-03-06 08:20:58] t_wiedmann at t-online dot de Please look a this sample. It shows some ORACLE/PLSQL access. Maybe I fix the problem. There are two mistakes in the code: (1) without this, Apache will crash (2) maybe some problem, first use of $nStatus without $nStatus = null; Hope this helps, Thomas ------------------------------------------------------- $sQuery = ''; $sQuery = $sQuery . 'BEGIN '; $sQuery = $sQuery . ' myTable.Read(:p1); '; $sQuery = $sQuery . ' myTable.GetnGroup_id(:p2); '; $sQuery = $sQuery . ' myTable.GetnStatus(:p12); '; // (1) I forgot this Line $sQuery = $sQuery . 'END; '; $stmt = $dbh->prepare($sQuery); if ($stmt) { $stmt->bindParam(':p1', $df_nWorkflow_id, PDO::PARAM_INT | PDO::PARAM_INPUT_OUTPUT, 22 ); $stmt->bindParam(':p2', $df_nGroup_id, PDO::PARAM_INT | PDO::PARAM_INPUT_OUTPUT, 22 ); $stmt->bindParam(':p12', $nStatus, PDO::PARAM_INT | PDO::PARAM_INPUT_OUTPUT, 22 ); // (2) $nStatus no init to NULL $stmt->execute(); $stmt->closeCursor(); $stmt = null; } --------------------------------------------- ------------------------------------------------------------------------ [2007-03-05 15:46:04] tony2001@php.net Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. ------------------------------------------------------------------------ [2007-03-05 13:33:32] t_wiedmann at t-online dot de Description: ------------ I get the same problem mit Apache 2.2.4 like #40229. Apache restart with: [Mon Mar 05 13:21:16 2007] [notice] Parent: child process exited with status 3221225477 -- Restarting. [Mon Mar 05 13:21:16 2007] [notice] Apache/2.2.4 (Win32) PHP/5.2.1 configured -- resuming normal operations [Mon Mar 05 13:21:16 2007] [notice] Server built: Jan 9 2007 23:17:20 Reproduce code: --------------- * Apache 2.2.4 * PDO * PHP/5.2.1 * Oracle 10g * Window Server 2003 Expected result: ---------------- No restart Actual result: -------------- Apache restart - connection failed ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=40727&edit=1