Can't upgrade db: Admin Password Required- but won't accept my password

[mc12345678]

Correct vanilla install, nothing more than a single module, and 2 templates with their modules ...
I hope the password script validation uses Encode base 64 otherwise I need to encode 1 into whatever encoder ZC uses ...

BTW I used PHPmyAdmin for that ...

So are you saying that you had some sort of additional password encrypter using the earlier zC version? If that's the case, then thatshould be incorporated to your upgrade process and new cart. The install is expecting the password to exist as it normally is in ZC. The other option I would think would be to use the default "admin" password for resetting the password.

[DivaVocals]

ok I just RESET my Password created a new one and same thing ....

Did you try the suggested fix posted in THIS thread???????

[icecold]

I did and it didn't work even with my new password, and just in case the upgraded fix ... so I wiped out everything ... and started from scratch, no big deal as it's less time, just to delete everything and start fresh, for a demo store without any products, and just one template and 1 contribution, it will be live soon ;) ... I hope

[icecold]

So are you saying that you had some sort of additional password encrypter using the earlier zC version? If that's the case, then thatshould be incorporated to your upgrade process and new cart. The install is expecting the password to exist as it normally is in ZC. The other option I would think would be to use the default "admin" password for resetting the password.

Well I just had the chance to watch the Zcpassword.php file and realized it's a completely different algorithm anyways, so I decided to start from scratch, now I have the demo site up and running fine ... Soon will be my new store ...

[earmsby]

I did the whole testing in a separate directory and had no problems with the database upgrade. But now that I'm in the process of upgrading the database that had been the live DB while I was testing, I ran into the password problem. I uploaded the "fix" but now get a white screen upon upgrading and the database does not upgrade. Seems like I've hit a dead end. Have I missed something here?

[earmsby]

Several posts in this thread refer to a " 'includes/classes/class.zcPassword.php' patch" and indicate that "patch" solved the problem. But in reading through this thread, I can't see what is involved in this. There seems to be an off-shoot in this thread that had to do with a problem logging into admin rather than upgrading the DB and maybe I missed the steps to try thinking the suggestion had to do with that.

I'm really frantic at this point because I spent a week working in a test environment and everything was fine. Now I put my client's store into maintenance mode thinking it would only take a half hour or so to do the final steps. But been banging up against a wall for an hour now.

Argh!

[earmsby]

Ok, I read through the relevant posts a few more times to understand what to do. I'm putting this here more clearly in case others have the problem too.

This is how to solve the problem when a) the DB upgrade does not accept your password and b) you get a blank screen after replacing the fixed file that DrByte posted.

1. Download the replacement file for zc_install > includes > functions > general.php
2. upload the file above into your zc_install directory on your server
3. Open the file CATALOG/includes/classes/class.zcPassword.php [replace CATALOG with your store directory name]
4. comment out line 52 "require_once (DIR_FS_CATALOG . DIR_WS_CLASSES . 'vendors/password_compat-master/lib/password.php');"
5. add a line below "require_once (DIR_FS_CATALOG . "includes/classes/" . 'vendors/password_compat-master/lib/password.php');" and save to your server
6. run the DB upgrade again

That worked for me and if I'm reading other's posts correctly it worked for a bunch of other folks too.

What I don't know is whether editing that line in the class file will screw up anything else down the line. Perhaps others involved in writing the upgrade and the original files can speak to that. So far I haven't seen any problems occurring with the fix but ???

[DrByte]

What I don't know is whether editing that line in the class file will screw up anything else down the line. Perhaps others involved in writing the upgrade and the original files can speak to that. So far I haven't seen any problems occurring with the fix but ???

If you undo the changes you made to class.zcPassword.php after you've done the database upgrade, there will be no problems.

We're investigating a way to make changes only to zc_install code so that you won't have to touch the class.zcPassword file.

[DrByte]

If one of you has a test environment and is willing to test an additional change, I'd be grateful.
(All my testing using PHP 5.2.17, 5.3.28, 5.4.31, 5.5.17 has not been able to recreate the same symptom when using the hotfix I published earlier, but I think the following may help...)

/zc_install/includes/functions/general.php (NOTE: this assumes you're using the updated one I posted earlier in this thread, because there are more changes later in the file that I've not quoted here)
Near the top of the file you'll see these lines. Add the one I've highlighted in red/bold:

  if (!defined('TABLE_UPGRADE_EXCEPTIONS')) define('TABLE_UPGRADE_EXCEPTIONS','upgrade_exceptions');
  if (!defined('DIR_WS_CLASSES')) define('DIR_WS_CLASSES', 'includes/classes/');
  require('../includes/classes/class.zcPassword.php');

[NWCE]

Hi Dr.Byte,

I have tried your suggested fix as you gave in your above post #59 by adding in the line in red, in the appropriate part of the general.php file. I was previously having the same issue as others where I was getting only a white screen when trying to update my database. After applying this line to the general.php file and then trying to update my database, I check the appropriate database update box, fill in my username and password, and then click the Update Database Now button and it just loops me back to this same page. No errors, no sign of it updating, nothing. I tried it a couple of times just to be sure it wasn't my user error.

My server stats are: Linux
Php version - 5.3.28
My SQL version - 5.5.36-cll
Architecture - x86_64

Hope this helps you to figure something out. Please let me know if you have any questions.

Jeff