|
|
Posted by M on 01/03/06 10:57
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
>
Navigation:
[Reply to this message]
|