3.6.1 to 3.7.2 upgrade - passwords not showing

[synchro]

Hi All,

 

I recently did an upgrade to version 3.7.2 from 3.6.1, and the password in the clients profile is not showing. The password is set in the database.

 

Has anyone else had this problem, or know anything to try to fix this?

 

Thanks

[WisTex]

I have the same problem. Upgraded from 3.6.2 to 3.7.1 to 3.7.2.

[WisTex]

Customers cannot login anymore to the Client Area. It says password is invalid. When customers request a password to be e-mailed to them, they get the e-mail, but the password is gibberish and does not work either.

[Stroh]

I'm encountering this same issue right now.

[synchro]

I have submitted a support ticket. If they give a fix to it, I'll post it.

[synchro]

I got a response - pretty quick I might say:

 

<blockquote>Hi David,

 

This can occur when you run the upgrade to 3.7 before all the new versions files for 3.7.1 have completed uploading. To resolve the issue, you would need to restore your DB backup from prior to the upgrade and then re-run the upgrade script.

 

Regards,

 

Matt</blockquote>

 

I'm pretty sure all the files were uploaded, so I have asked him if there are any other causes (and too much has happened to restore the database)

[synchro]

Matt wrote back to me, and that seems like that reason. I'm just guessing, but perhaps the encryption has changed and so the passwords no longer work, and would have been decoded and recoded with the new crypt should all the files have been present.

 

We did a test to confirm this, by looking at a client who would not have logged in, set the password to what it was first set as, and the value changed in the database.

[papak011]

We have the same problem and pretty sure that all files uploaded.

 

What's the solution? Restore database?

 

Mike

[synchro]

If you can, restore the database and be completely certain the files are uploaded first. Other than that, run the above script to reset all passwords. I'm sure that we had uploaded the files, but we were too far along to restore the database to find out if another upgrade fixed it.

[synchro]

It would help if I posted the script:

 

<?php

 

include("dbconnect.php");

include("includes/functions.php");

 

$result = mysql_query("SELECT * FROM tblclients");

while ($data = mysql_fetch_array($result)) {

$clientid = $data["id"];

$length = 8;

$seeds = 'abcdef0123456789';

$str = null;

$seeds_count = strlen($seeds) - 1;

for ($i = 0; $length > $i; $i++) {

$str .= $seeds[rand(0, $seeds_count)];

}

$userpassword = encrypt($str);

$result2 = mysql_query("UPDATE tblclients SET password='$userpassword' WHERE id='$clientid'");

}

 

?>