ID: 8434
Updated by: jmoore
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Duplicate
Bug Type: IIS related
PHP Version: 4.0.4
Assigned To:
Comments:
ANother Access violation in IIS bug.
-James
Previous Comments:
---------------------------------------------------------------------------
[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
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=8434&edit=2
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
