WampServer

Hi,

1 - Windows version used: Win7 enterprise, 64bit
2 - Version WampServer: 2.5, tried both 32bit or 64bit but same problem
3 - Apache Version: 2.4.9
4 - PHP Version:5.5.12
5 - MySQL Version: 5.6.17
6 - What color is the WampServer icon (in the notification area of the taskbar): green

you can read my question from here: [stackoverflow.com]

Fundamentally apache is crashing while I execute the following code:

$conn->query("SET @res = ''";

$mysqli=$conn;
if (!($stmt = $mysqli->prepare("CALL retrieve_matches(5,3, 16, 2, false, @res)")) {
echo "Prepare failed: (" . $mysqli->errno . " " . $mysqli->error;
}

if (!$stmt->execute()) {
echo "Execute failed: (" . $stmt->errno . " " . $stmt->error;
}

do {
if ($res = $stmt->get_result()) { //Apache crash on this call
printf("---\n";
var_dump(mysqli_fetch_all($res));
mysqli_free_result($res);
} else {
if ($stmt->errno) {
echo "Store failed: (" . $stmt->errno . " " . $stmt->error;
}
}
} while ($stmt->more_results() && $stmt->next_result());

Apache is crashing with error:
AH00428: Parent: child process 9628 exited with status 255 -- Restarting.

I checked windows event and I found httpd.exe is crashing caused by php5ts.dll

The same code above that make Apache crashing is working correctly if I just change the number in input of the stored procedure like:

if (!($stmt = $mysqli->prepare("CALL retrieve_matches(5,6, 16, 2, false, @res)")) {

but I Tried from MySQl workbench and both calls are working fine...

Do you have any suggestion what I should do? I'm currently stucked with development

What versions of Apache / MySQL / PHP is the system where this does work using?

Is that system Windows or a *nix?

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Thanks, but I believe I answered those questions at the beginning of my post. Please let me know if I can add any more info.

Thanks

No you answered where the code DOES NOT WORK.

I wanted to know where the code DOES WORK

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

sorry, didn't notice. The code work in the same exact environment when I just change a value in the CALL.

Well as we have no idea what the stored proceedure is doing its not much help in working out what might be wrong if all we know is a parameter change makes it work.

Sorry, need more information

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-