No, I did tell you yesterday that I'd gotten into phpMyAdmin, and gotten stopped because it wouldn't accept the password. It was a step I tried early in the afternoon, then reported it late last night when you got snarky about my refusing to look at the 'I Lost It' page...which I had not refused to look at, and had tried several times to follow.

For the rest: I just don't know. I can't run anything in phpMyAdmin, because I can't get it to accept a password, so I can't run the code you keep mentioning. Nor can I see what prefix might exist, or how many tables I have in the database. It has me totally locked out because it won't accept the cPanel's un/pw.

And the Install Sql Patches page within Zencart says not to upgrade the database from there, so I haven't done anything on that page, for fear of screwing something up even worse. Is that where you want me to run the code you listed above? Or should I be running it in phpMyAdmin?

If you're able to login to your ZC admin, run the above SQL in the install sql patches of the ZC admin. It is not an install script. It will create a new user with the username Admin and password admin. Do not test logging in with it yet proceed with the zc_install process by having the zc 1.5.3 version of the admin directory that is named/renamed admin and ensuring that the admin/includes/configure.php file either autogenerates the path to the admin directory(default method of ZC 1.5.x) or that specifically has the path to the site and the directory admin.

The issue with not being able to access myphpadmin can be resolved through your host.

Still no joy. I entered:

DELETE FROM admin WHERE admin_name = 'Admin'; INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level) VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

into the Install SQL Patches window...and got the following error:

WARNING: An Error occurred, please refresh the page and try again.

mc12345678:

See, the zc_install procedure like Dr. Byte was saying requires the admin directory to be named admin. Further, when accessing the admin panel, it expects to not be named admin, and at the same time whether it isnamed admin or not, the system expects zc_install to only "briefly" exist otherwise there are actions prevented until it is removed...

So,if during the time that you had zc_install in place aand the admin directory wasn't named admin, then shouldn't have been able to even get so far with the zc_install procedure and no wonder there was difficulty...
For simply using zc_install to do the database-upgrade, the name of the admin folder is irrelevant, as it never needs the admin folder during just a db upgrade.

DK_Scully:

Still no joy. I entered:

DELETE FROM admin WHERE admin_name = 'Admin'; INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level) VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

into the Install SQL Patches window...and got the following error:

WARNING: An Error occurred, please refresh the page and try again.

The specific error generated is in either the cache or logs directory off of the site as a myDEBUG prefixed file. Please post that result. Right now there are too many variables to identify what is going on/status of this upgrade. Also, while at it, please visit the version area of your admin panel and post what ZC reports for the database and software versions. This is typically listed just before allof the server setting tables.

DK_Skully,
What is your PHP version? If it's lower than PHP 5.3.8, do you have the option to switch it to something newer for this site?

mc12345678:

The specific error generated is in either the cache or logs directory off of the site as a myDEBUG prefixed file. Please post that result. Right now there are too many variables to identify what is going on/status of this upgrade. Also, while at it, please visit the version area of your admin panel and post what ZC reports for the database and software versions. This is typically listed just before allof the server setting tables.

[28-Oct-2014 12:27:37] PHP Fatal error: Class 'zcPassword' not found in /home/carnal1/public_html/zencart/includes/autoload_func.php on line 79

Also...

Server Information
Server Host: volt.websitewelcome.com (192.185.2.189) Database Host: localhost (127.0.0.1)
Server OS: Linux 3.12.24 Database: MySQL 5.5.40-36.1
Server Date: 10/30/2014 10:18:31 Database Date: 10/30/2014 10:18:31
Server Up Time: 10:18:31 up 22:43, 0 users, load average: 0.04, 0.01, 0.00 HTTP Server: Apache
PHP Version: 5.2.17 (Zend: 2.2.0) PHP Memory Limit: 256M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 64M POST Max Size: 64M
Database Data Size: 23,117 kB Database Index Size: 1,683 kB

Zen Cart 1.5.3
Database Patch Level: 1.5.0
v1.5.0 [2012-04-28 15:32:41] (Fresh Installation)
v1.5.0 [2012-04-28 15:32:41] (Fresh Installation)
PHP Version 5.2.17

DrByte:

DK_Skully,
What is your PHP version? If it's lower than PHP 5.3.8, do you have the option to switch it to something newer for this site?

PHP version 5.4.32

No, if you look at your prior post, you're really using PHP 5.2.17.
Do you have the ability to switch it to 5.4.32 for this site?

DrByte:

For simply using zc_install to do the database-upgrade, the name of the admin folder is irrelevant, as it never needs the admin folder during just a db upgrade.

Huh, makes sense. Database information is retrievable by accessing the parallel includes folder and it's configure.php. Good thought ZC team. I've just been doing the extra step unnecessarily then, which also provides a customer distraction that I have averted by briefly placing the store in scheduled maintenance mode.

I hope you guys don't mind me butting in here.

DK_Scully:

1. I only have one login, so I can't log in with a second login. But I did reset my password once I logged in. It hasn't helped.

I find this comment VERY confusing. First you say you can't log in, immediately followed by the comment that you were able to log in and reset the password. How is this possible?

DK_Scully:

2. This only deals with if you lost your login...which I didn't.

I agree that in theory you didn't lose you login password, but if the crypto has changed then technically you have lost it. For example, if your password is "mypassword" it will be stored in the database as something like "21f5b02daa67f46905d0199123eae9d1:b7" using the original crypto and something like "$2y$13$i26A9nBBsi4W.brSudxpI.FDOyUagM5tT7RmZMZTJDaWY9QROoHOK" with the new crypto. IOW, although the plaintext version of the password hasn't changed if you are using the wrong crypto at any given time the password simply won't work. For all intents and purposes it has been lost.

DK_Scully:

As a sidenote, I tried to follow the instructions further down. When I try to log into my phpMyAdmin, I get this error message: #1045 Cannot log in to the MySQL server

This sidenote can be quite significant. There are actually two different usernames & passwords that you need to be aware of. The 1st being the admin username/password to log into the store admin. These are stored in the zencart database. The other pair are required so that the zencart can access the mysql database. This username/password are stored in the zencart configure.php files. When you need to log in using phpmyadmin it is this latter username/password that you need to enter.

In simple terms, when you log into zencart, the zencart code initially connects to the database (using the credentials found in the configure.php files) and once this connection is established a query is made to the database to verify the admin (or customer) user credentials as entered in the zencart login screen(s).

The message "1045 Cannot log in to the MySQL server" when trying to log into phpmyadmin implies that you are probably entering the zencart admin username/password and NOT the mysql server username/password. (Although these can be the same username/password for both, they generally aren't).

Hopefully this helps clarify things rather than add to the confusion.

Cheers
RodG

DrByte:

No, if you look at your prior post, you're really using PHP 5.2.17.
Do you have the ability to switch it to 5.4.32 for this site?

PHP version 5.4.32 is what the site's cPanel says. I don't know how to change that.

DK_Scully:

No, I did tell you yesterday that I'd gotten into phpMyAdmin, and gotten stopped because it wouldn't accept the password. ...
You can try the database credentials stored in "configure.php" (often works for temporary access until the hosting provider can restore access via cPanel to the cPanel account).

Sometimes the cPanel account gets removed from the database server (or the passwords between cPanel and MySQL get out of sync). Your hosting provider should be able to help restore access to phpMyAdmin (via cPanel).

The hosting provider should also be able to help change the version of PHP configured for your website.

Rod:

Without quoting everything you queried...

Yes, I am able to access the zencart admin section without a problem. The "I Lost It" instructions seemed to be telling me that I must log in with a secondary username...which I did not have. Since I couldn't do that, logically the rest of the page falls by the wayside...except that I was finally told I could ignore that step and move on to the second step...which I hadn't done because I was trying to stick to EXACTLY what was being instructed so I wouldn't mess things up further.

I do understand encrypted passwords...but since I can log in without any issue, I don't see how it can be "lost." I still don't...but since I was told to create a new username anyway, I did. For what good it did.

Regarding a different password to access the mysql database...this is the first I've heard about looking in the Zencart configure.php file. Yes, I think I see what you're referring to, on lines 50-57.

Once we can resolve the existing errors, so that I know what to do with that last bit of information, I'll give it a try. Thank you!

Thank you, too, LHungil!

DK_Scully:

I'm in the cPanel. I don't know why I could log into cPanel without an issue but can't use the same username/password to access the phpMyAdmin

cPanel has its own login credentials that are different from the phpMyAdmin/MySQL credentials which are different again than the zencart admin/user credentials.

If that isn't confusing enough, it is also possible for the phpMyAdmin to have a different set of credentials than the MySQL credentials (This generally isn't the case though because the cPanel software tends to synchronize any changes made).

Yes, it CAN be quite confusing having all these different usernames/passwords, but they each serve a totally different purpose.

Cheers
RodG

And that purpose would be to drive me crazy...and it's such a short drive! :P

Okay, so now what? I'm trying to get hold of HostGator to find out why their cPanel says I'm using one version of php, but ZenCart thinks I'm using another...it's going to be a long wait because they're still trying to dig out from all their servers being down for 4 hours yesterday...which no doubt contributed to the problems I was having. Can anything be done in the meantime?

DK_Scully:

Yes, I am able to access the zencart admin section without a problem. The "I Lost It" instructions seemed to be telling me that I must log in with a secondary username...which I did not have.

I've not read those instructions for a long time, but the way I understand it is that if you DID have a secondary user/login you can (or should be able to) login with those credentials and simply reset the password of the primary user. This is the simplest way to reset the primary password.

DK_Scully:

Since I couldn't do that, logically the rest of the page falls by the wayside...except that I was finally told I could ignore that step and move on to the second step...which I hadn't done because I was trying to stick to EXACTLY what was being instructed so I wouldn't mess things up further.

If you don't have the secondary user, the only(?) option is to reset the password of the primary user. This can only be done using phpMyAdmin (which effectively bypasses all of the zencart security).

DK_Scully:

I do understand encrypted passwords...but since I can log in without any issue, I don't see how it can be "lost."

OK, so now I'm a little confused as to what your actual problem is. Sorry... I think I'll need to go back and read some of the earlier posts, because I'm clearly on a different path than you are. I do agree with what you are saying here though... if you can login without an issue then clearly the password is correct, regardless of the crypto being used.

DK_Scully:

I still don't...but since I was told to create a new username anyway, I did. For what good it did.

Just to confirm, this 'new username' you created was done via ZenCart and it was for a new Admin user correct? Also, you did give it the 'Super User' profile when adding it? Is any/all of this correct? (Just trying to ensure you didn't create a regular user account, or created an account using phpMyAdmin).

Having said that, if you are able to log in as the store admin using the primary account you really don't have a need for a secondary account (although it can be very useful if you do ever 'lose' the password for the primary account (this can happen, for example, if the site gets hacked via an SQL injection exploit resulting in the hacker changing the primary password on you).

DK_Scully:

Regarding a different password to access the mysql database...this is the first I've heard about looking in the Zencart configure.php file. Yes, I think I see what you're referring to, on lines 50-57.

Yes, that sounds about right, and this is typically the same username/password that you'll need for phpMyAdmin (although it is possible for them to get out of sync). If it is of any help, you can check/verify the username from the cPanel "MySQL databases" icon ('privileged users'). You can't check the password from here though, but you can create a new user for the zencart database and specify a new password, which you'll then need to replicate into both the configure.php files.
I suggest you don't need to do this though, because if you can log into the zencart admin then it is safe to assume the the credentials in the configure.php files are indeed correct and therefore don't need changing.

And this bring me back to the stage where I'm not quite following exactly where it is that you are having a problem.

DK_Scully:

Once we can resolve the existing errors, so that I know what to do with that last bit of information, I'll give it a try. Thank you!

Just to repeat, if you can login to the zencart store admin then don't mess with the configure.php login details, because these will be correct (If they weren't Zencart will give a big bold message/warning stating quite clearly that it "Can't connect to the Database"(and it will do this before you can even get to the zencart login screen(s).

Cheers
RodG

Just a thought ... but do you have in:
/public_html

a .htaccess file with something like:

# Use PHP5.4 as default
AddHandler application/x-httpd-php54 .php

If so, do you also have a .htaccess file in the directory you are working in?

Ajeh:

Just a thought ... but do you have in:
/public_html

a .htaccess file with something like:

Use PHP5.4 as default

AddHandler application/x-httpd-php54 .php

> 
> If so, do you also have a .htaccess file in the directory you are working in?

The .htaccess file from my /public_html/ folder reads:

<IfModule mod_suphp.c>
 suPHP_ConfigPath /home/carnal1
 <Files php.ini>
   order allow,deny
   deny from all
 </Files>
</IfModule>

The date on it is 12/25/13 if that matters.  What other folder would you like me to read it from?

I was just wondering if you had anything like that and, if installing in another directory, if you had that ... I have an account with another hosting site and have to do that to get php to run the right version ...

Since you don't ... you can ignore me ... :lookaroun