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

laurelsstitchery:

And I got it to work finally. THanks! :)

doing what??? Might help others if you post what YOU did..

DivaVocals:

doing what??? Might help others if you post what YOU did..

Yes! Sorry I meant to include that. When I read through the 'includes/classes/class.zcPassword.php' patch posted earlier in the thread, I thought (and this is what I get for thinking) that it meant to comment out that line, but after going back and reading it another 100 times, I realized that I was meant to comment out that line and paste in the other line. Like I said, too much thinking gets me in trouble. I'm all upgraded and testing now. Thanks for all the help! :)

HI,
I am currently experiencing the same problem. it is no doubt related to the following line of code:

define('DIR_WS_INCLUDES', '../includes/');

which is line 39 in:

zc_install/includes/modules/pages/database_upgrade/header_php.php

now, why this only fails on the the class.zcPassword class and not on other classes, well you got me.

not really sure why this would get redefined here.

carlwhat:

HI,
I am currently experiencing the same problem. it is no doubt related to the following line of code:

define('DIR_WS_INCLUDES', '../includes/');

which is line 39 in:

zc_install/includes/modules/pages/database_upgrade/header_php.php

now, why this only fails on the the class.zcPassword class and not on other classes, well you got me.

not really sure why this would get redefined here.

Humans.. not infallible.. probably a typo..

DivaVocals:

Humans.. not infallible.. probably a typo..

i'm not sure it's a typo, although it very may well be...

it exists in the upgrade to v1.5.1 as well; and it's curious that the zcPassword class (which i believe is new) is the only class that is failing.

I just did an install of 1.5.3 yesterday using the original download package adding the zip patch to be able to use the admin password of the databaase to be upgraded and did not have any problems with the upgrade the database aspect of the process. I do not know if there was a difference in the files of the original package plus the zip file and the current package. I did see as I was reconstructing the site that there was a plugin installed (master password) that modified some of the area discussed above.

This leads me to ask in relation to the attempted "upgrade" how vanilla is/was the install/upgrade on which difficulty has been found?

After reading all this thread I found I couldn't find a solution to the problem in ZC_install to upgrade my v151 db, to the current v153 ... I've done everything, from repatching the general.php function as suggested by DrByte in the thread, to wipe out completely the admin password and enter a single '1' ... using 'MQ==' a base64 encode in the db ... Nothing works, I am getting the same error,>>> ' Admin Password required to proceed with upgrade more info ... '

BTW here's my Info
Server Name host
cPanel Version 11.42.1 (build 24)
Apache version 2.2.23
PHP version 5.2.17
MySQL version 5.1.73-cll
Architecture i686
Operating system linux

Any ideas?
Should I wipeout the whole thing and start over?

icecold:

After reading all this thread I found I couldn't find a solution to the problem in ZC_install to upgrade my v151 db, to the current v153 ... I've done everything, from repatching the general.php function as suggested by DrByte in the thread, to wipe out completely the admin password and enter a single '1' ... Nothing works, I am getting the same error,>>> ' Admin Password required to proceed with upgrade more info ... '

BTW here's my Info
Server Name host
cPanel Version 11.42.1 (build 24)
Apache version 2.2.23
PHP version 5.2.17
MySQL version 5.1.73-cll
Architecture i686
Operating system linux

Any ideas?
Should I wipeout the whole thing and start over?

Other than a recently identified paypal mod, if you have downloaded thelatest 1.5.3, the zc_install should present you with the ability to upgrade when that option is selected. Be sure that the username and password is the associated information from the old database. You said this was a vanilla install, correct?

mc12345678:

Other than a recently identified paypal mod, if you have downloaded thelatest 1.5.3, the zc_install should present you with the ability to upgrade when that option is selected. Be sure that the username and password is the associated information from the old database. You said this was a vanilla install, correct?

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 ...

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

icecold:

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.

icecold:

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

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

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

mc12345678:

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 ...

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?

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!

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 ???

earmsby:

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.

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');
[B] if (!defined('DIR_WS_CLASSES')) define('DIR_WS_CLASSES', 'includes/classes/');[/B]
require('../includes/classes/class.zcPassword.php');

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