Lost connection to MySQL server during query

bvogt

This seems to be a mysterious error. I'm getting this error using the various configuration details listed below. I've done extensive searching, but nothing I find relates to what I'm seeing.

This is a consistent error, not an occasional one.

I've got several small websites using the MySQL installation; none of which are having this problem.

Any ideas would be greatly appreciated.

Some details:
PHP is configured with the appropriate path the MySQL
MySQL process is not crashing or being killed
PHP 4.1.1 with MySQL 3.23.54 On AIX
SQL Query: DELETE from members where MemberNumber = 789
Error: Lost connection to MySQL server during query

thanks.

bastien

can you show code? is it a timeout error?

bvogt

It's not a timeout error...the page loads okay.

Here's the code:

<?php

//Open connection to the database
if ($db == ''){
$db = mysql_pconnect($host, $user, $pw);
}
mysql_select_db("astda") or die("Cannot open database 'astda.' Error: ".mysql_error($db));

$confirmation = '';
foreach ($GLOBALS["HTTP_POST_VARS"] as $key => $value) {
if ($key != 'Submit') {

empty($SQLStr);
empty($result);

print "processing $key... \n";

$SQLStr = "SELECT * FROM members where MemberNumber = $key";
$result = mysql_query($SQLStr) or die ("Cannot read contacts table. SQL: SQLStr Error: ".mysql_error($db));
$row = mysql_fetch_row($result);
$confirmation .= $confirmation . "Member " . $value . "d: " . stripslashes($row[2]) . ", " . stripslashes($row[0]) . " " . trim(stripslashes($row[1])) . " MemberID $key.$i \n";

empty($SQLStr);
empty($result);
if ($value == 'approve') $SQLStr = "UPDATE members set flag = '' where MemberNumber = $key";
if ($value == 'delete') $SQLStr = "DELETE from members where MemberNumber = $key";

if ($SQLStr != '') $result = mysql_query($SQLStr) or die ("Cannot update contacts table. SQL: $SQLStr Error: ".mysql_error($db));
mysql_free_result ($result);
}

}
?>

alokganguly

i have the same probs
if u get the solution plz send me .
at alokganguly@rediffmail.com