[PHP] MySQL update killed my login...

2006-01-03 Thread William Stokes 
Hello,

My ISP updated their MySQL DB to 5.0.18 and that killed my login procedure 
which was OK yesterday. Any ideas how to start to debug this?

The login updates 2 fields in users table row where username and password 
macthes. This is the code:


if (!$query = mysql_query(update tbl_users set sess_id='$sess_id', 
sess_id_start='$date'
where md5(usr_name)='$usr_name' and password=PASSWORD('$password') 
,$connection))
{
header(Location: http://www.domain.net/loginscreen.php;);
exit;
}
else
{
Do Login and stuff...

This worked until today. I called the ISP and they confirmed that there was 
a database update yesterday.

-Will

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] MySQL update killed my login...

2006-01-03 Thread M 
It seems the upgrade was from Mysql 4.0. PASSWORD() function changed 
between 4.0 and 4.1, it uses longer hashes now. You can still use 
OLD_PASSWORD() function instead.


William Stokes wrote:

Hello,

My ISP updated their MySQL DB to 5.0.18 and that killed my login procedure 
which was OK yesterday. Any ideas how to start to debug this?


The login updates 2 fields in users table row where username and password 
macthes. This is the code:



if (!$query = mysql_query(update tbl_users set sess_id='$sess_id', 
sess_id_start='$date'
where md5(usr_name)='$usr_name' and password=PASSWORD('$password') 
,$connection))

{
header(Location: http://www.domain.net/loginscreen.php;);
exit;
}
else
{
Do Login and stuff...

This worked until today. I called the ISP and they confirmed that there was 
a database update yesterday.


-Will



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] MySQL update killed my login...

2006-01-03 Thread William Stokes 
Thanks!

-W

M [EMAIL PROTECTED] kirjoitti 
viestissä:[EMAIL PROTECTED]
 It seems the upgrade was from Mysql 4.0. PASSWORD() function changed 
 between 4.0 and 4.1, it uses longer hashes now. You can still use 
 OLD_PASSWORD() function instead.

 William Stokes wrote:
 Hello,

 My ISP updated their MySQL DB to 5.0.18 and that killed my login 
 procedure which was OK yesterday. Any ideas how to start to debug this?

 The login updates 2 fields in users table row where username and password 
 macthes. This is the code:


 if (!$query = mysql_query(update tbl_users set sess_id='$sess_id', 
 sess_id_start='$date'
 where md5(usr_name)='$usr_name' and password=PASSWORD('$password') 
 ,$connection))
 {
 header(Location: http://www.domain.net/loginscreen.php;);
 exit;
 }
 else
 {
 Do Login and stuff...

 This worked until today. I called the ISP and they confirmed that there 
 was a database update yesterday.

 -Will
 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php