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