the dreaded white screen

[jenpen]

Just now upgrading from 139h to 153.

Playing it safe, I took a back-up of the site files and uploaded them into a /store subfolder. Checked the store and admin, all fine.
Then I uploaded all the new v153 files into that folder, and corrected the configure files for the /store/ path.

White screens for store and admin.

I suspect I need to upgrade the database but I've forgotten how to do that.

Any pointers? Other ideas?

[mc12345678]

How about following some directions, try these: http://www.zen-cart.com/entry.php?3-...d-of-upgrading

[DrByte]

White screens for store and admin.

What's it recording as the cause of the blank screens? http://www.zen-cart.com/content.php?124-blank-page

[jenpen]

Thanks, I'll try it.

[jenpen]

Hmm, I've hit a dead-end.

I got a long way forward, it was all looking good. I ran zc_install, it all went ahead. But it created a new, empty database. I thought, that's fine, so I imported my DB back-up SQL file into it - SQL error. Also fine, I deleted that DB, created a new one with the same name, user, password, imported the DB back-up into that. All went well.

BUT... then the DB needed upgrading, so I went back and ran zc_install again. OK, but when I clicked on Database Upgrade, it wouldn't accept my admin password. I tried the new temporary one, then the one I had changed it to. It's not accepting either. And if I try to open the admin log-in to get a new admin password sent to me, it just says "database upgrade required. please run the 1.3.9-to-1.5.0 upgrade via zc_install" - which is what I'm trying to do...

Is there some other way of getting/resetting the admin password?

[DrByte]

Sigh.
Lemme guess ... you're running an old version of PHP, right?

[jenpen]

PHP Version: 5.3.29 (Zend: 2.3.0)

[DrByte]

Use phpMyadmin and go to the admin table in your database, and look at the entry for your admin user. What are the first 10 characters of the encrypted password it's got there? (It's safe to post those, as nobody can use that information for anything ... I'm just looking for a pattern to know what it's done to your data.)

[jenpen]

Thanks... a2efab6917

[DrByte]

The password info you posted indicates that it hasn't upgraded the password methods yet, which means your data hasn't been altered. That's good. It also means your original admin password probably still will work (if you haven't asked it to email a new one ... and don't do that except as a last resort).

You haven't yet posted whether there are any new errors in myDebug-xxxxx.log files in the /logs/ folder. In the absence of that information it's hard to tell what exactly your server is having trouble with. But since it seems to take hours to dialog back and forth here, maybe making this small change might help?
Edit /includes/classes/class.zcPassword.php
Around line 49 you have this:

    if (version_compare($phpVersion, '5.3.7', '<')) {
      require_once (DIR_FS_CATALOG . DIR_WS_FUNCTIONS . 'password_compat.php');
    } elseif (version_compare($phpVersion, '5.5.0', '<')) {
      require_once (DIR_FS_CATALOG . DIR_WS_CLASSES . 'vendors/password_compat-master/lib/password.php');
    }

Try changing it to this:

    if (version_compare($phpVersion, '5.3.7', '<')) {
      require_once (realpath(dirname(__FILE__)) . '/../functions/password_compat.php');
    } elseif (version_compare($phpVersion, '5.5.0', '<')) {
      require_once (realpath(dirname(__FILE__)) . '/vendors/password_compat-master/lib/password.php');
    }