ID: 8434
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Duplicate
Bug Type: IIS related
Operating System: Win 2K Server
PHP Version: 4.0.4
New Comment:
we're having nearly the same problem in our company. we're using iis 4
with nt, not 2k... shortly after a reboot the whole iis crashes (sort
of). we are using asp and php in different webs. asp is down if the iis
crashes. after deactivating mysql the server will work again... that's
what we've encountered here today. i would be glad if someone could
mail me some more information regarding this ACCESS VIOLATION topic...
Previous Comments:
------------------------------------------------------------------------
[2001-04-16 06:33:56] [EMAIL PROTECTED]
ANother Access violation in IIS bug.
-James
------------------------------------------------------------------------
[2001-01-08 10:05:52] [EMAIL PROTECTED]
Well, that _is_ a good question: I have absolutely no idea which
instruction causes the problem !
As said in my report, the error can appear on any of my 30+ scripts on
the site. The error does not have a preference for any of the scripts
either. It just appears _randomly_ on any of the scripts at a random
time and at random frequency. I sometimes have the error 2 to 5 times a
day, and sometimes it will not appear for 2 days at all. I know that
doesn't help you much, but that's about as precise as I can be.
That's why I gave you all the information necessary to rebuild an exact
copy of 1 of my scripts and see _if_ you get the error at all. It will
be necessary though that you test it on the same platform as I run it:
Win 2K Server with IIS 5.0 and PHP-4.0.4 as ISAPI (php4isapi.dll). The
database runs on a separate server (Win NT4 Server SP6).
Hope you find a clue where to start looking (as a novice, I'd say in
the .DLL). If you need any further information, do not hesitate !
Greetings,
Steven
------------------------------------------------------------------------
[2001-01-08 08:59:28] [EMAIL PROTECTED]
can you please cut down the code to the min. needed to reproduce it?
------------------------------------------------------------------------
[2000-12-27 07:27:56] [EMAIL PROTECTED]
Still having same bug in PHP-4.0.4 Win ISAPI module...
Randomly showing error "PHP has encountered an Access Violation at
01292466" (the number changes every time the error occurs) upon call to
PHP ISAPI engin. The error can occur on any of my 30+ scripts on this
site.
This problem persists since at least 3.0.3pl1. When will this nightmare
be over ?? I have to switch back to a CGI environment, which slows down
PHP execution far too much...
Restarting IISAdmin does get the engine running properly again... until
the next "Access Violation"...
Almost all of the bug reports concerning this error have not even been
assigned to anyone. Does this mean you're not going to try to get rid
of this problem ?
If you have any questions regarding the script below, do not hesitate
to contact me!
All in all: thanks for bringing us PHP and keep up the good work !
Steven VAN POECK
One piece of code on which the error occurs:
--------------------------------------------
include( "common.php" );
// Call session (if any)
session_save_path("tmp");
session_start();
// Empty basket
$sql = "DELETE FROM panier WHERE client_id='$user'";
mysql_pconnect( $db_host, $db_user, $db_pass );
$result = mysql_db_query( $db_dag, $sql );
check_error( $result );
// Set user state to "D" (deconnected)
$sql = "UPDATE client SET state='D' WHERE id='$user'";
mysql_pconnect( $db_host, $db_user, $db_pass );
$result = mysql_db_query( $db_dag, $sql );
check_error( $result );
// destroy session (if any)
session_destroy();
// Get highest client ID
$sql = "SELECT MAX(id) AS max_id FROM client";
mysql_pconnect( $db_host, $db_user, $db_pass );
$result = mysql_db_query( $db_dag, $sql );
check_error( $result );
$data = mysql_fetch_object( $result );
$last_client = $data->max_id;
// Define new client ID
if( substr($last_client, 1) < 50000000 ){
$numero_client = P50000101; /* For very first client */
}else{
$numero_client = "P".(substr($last_client, 1) + 1);
}
// Get password of the day
$today = date("Y-m-d", time());
$mdp = create_pass();
// Define timestamp for expiration time
$exp_time = time()+1800;
$sql = "INSERT INTO client VALUES( '$numero_client', PASSWORD('$mdp'),
'$today', '$today', '0', 'DP', '$exp_time', 'C')";
mysql_pconnect( $db_host, $db_user, $db_pass );
$result = mysql_db_query( $db_dag, $sql );
check_error( $result );
// Initialise session
session_save_path( "tmp" );
session_register("user");
$user = $numero_client;
session_register("key");
$key = $mdp;
session_register("type");
$type = "p_";
session_register( "cadeau_1" );
$cadeau_1 = 0;
// Send user to the site
header(
"Location:/pcgi/display_rubr.php?".SID."&rubr=".urlencode(${$type."rubr_def"})
);
-------------------------------------------------------
The function "create_pass()":
-------------------------------------------------------
function create_pass(){
global $db_host, $db_user, $db_pass, $db_adm;
$alpha = array('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k',
'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v',
'w', 'x', 'y', 'z');
$n = 0;
$flag = 0;
// Select all passwords
$today = date("Y-m-d", time());
$sql = "SELECT * FROM mdp_jour";
mysql_pconnect( $db_host, $db_user, $db_pass );
$result = mysql_db_query( $db_adm, $sql );
while( $data = mysql_fetch_object( $result ) ){
// Verify if today's password already exists
// If so, use that one
if( date("Y-m-d", time()) == $data->date ){
$pass = $data->mdp;
$flag = 1;
}
}
if( $flag != 1){
// No password for today yet
// So have to make one
while( $n < 4 ){
reset( $alpha );
mt_srand((double)microtime()*1000000);
$pass = mt_rand(0, 25);
$password .= $alpha[$pass];
$n++;
}
// Select all passwords
$sql = "SELECT * FROM mdp_jour";
mysql_pconnect( $db_host, $db_user, $db_pass );
$result = mysql_db_query( $db_adm, $sql );
while( $data = mysql_fetch_object( $result ) ){
// Verify if created password already exists
// If so, recreate another password
if( eregi( $data->mdp, $password ) ){
create_pass();
}
}
// If not, generated password is unique. Write to DB
if( $flag == 0 ){
$pass = $password;
$sql = "INSERT INTO mdp_jour VALUES('', '$today', '$password')";
mysql_pconnect( $db_host, $db_user, $db_pass );
$result = mysql_db_query( $db_adm, $sql );
check_error( $result );
}
}
return $pass;
}
----------------------------------------------------------
You'll need 2 databases:
DB1 ($db_dag in the script):
------- Table "panier":
Field Type Null Key Default Extra Privileges
id int(11) unsigned
zerofill PRI auto_increment
select,insert,update,references
client_id varchar(10) 0
select,insert,update,references
produit_ref varchar(50)
select,insert,update,references
produit_prix_ttc float(5,2)
unsigned 0 select,insert,update,references
prix_gift enum('1','0') 1
select,insert,update,references
produit_n int(3) unsigned 0
select,insert,update,references
expire int(13) 0 select,insert,update,references
-------- Table "client":
Field Type Null Key Default Extra Privileges
id varchar(10) PRI
select,insert,update,references
pass varchar(255)
select,insert,update,references
crea date 0000-00-00
select,insert,update,references
mod date 0000-00-00
select,insert,update,references
visits int(5) unsigned
zerofill MUL 0 select,insert,update,references
type enum('DP','DAG') DP
select,insert,update,references
expire int(13) 0 select,insert,update,references
state enum('C','D') D
select,insert,update,references
DB2 ($db_adm in the script):
------- Table "mdp_jour":
Field Type Null Key Default Extra Privileges
id int(5) unsigned zerofill 0
select,insert,update,references
date date 0000-00-00
select,insert,update,references
mdp char(5) select,insert,update,references
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=8434&edit=1
