Database upgrade from 1.5.1 to 1.5.3

I installed zencart from my ISP (slap my hand), and it was 1.5.1.

After making just a few customizations, I noticed 1.5.3 was available, so I upgraded. When I ran the installer, it said all I needed to do was upgrade the database. When I clicked on "upgrade database," the screen just went blank and stayed that way. I left if for a while in case it was working in the background, and it never came back.

I reran the installer, and it showed the database was still 1.5.1

So I checked the log files, and found this message:

[16-Sep-2014 12:16:29 America/Denver] PHP Warning: require_once(/home3/rainfor4/public_html/shipsandtrains/../includes/classes/vendors/password_compat-master/lib/password.php): failed to open stream: No such file or directory in /home3/rainfor4/public_html/shipsandtrains/includes/classes/class.zcPassword.php on line 52
[16-Sep-2014 12:16:29 America/Denver] PHP Fatal error: require_once(): Failed opening required '/home3/rainfor4/public_html/shipsandtrains/../includes/classes/vendors/password_compat-master/lib/password.php' (include_path='.:/usr/php/54/usr/lib64:/usr/php/54/usr/share/pear') in /home3/rainfor4/public_html/shipsandtrains/includes/classes/class.zcPassword.php on line 52

I checked, and the file seems to be there.

Any ideas what's wrong?

jehitch:

I installed zencart from my ISP (slap my hand), and it was 1.5.1.

After making just a few customizations, I noticed 1.5.3 was available, so I upgraded. When I ran the installer, it said all I needed to do was upgrade the database. When I clicked on "upgrade database," the screen just went blank and stayed that way. I left if for a while in case it was working in the background, and it never came back.

I reran the installer, and it showed the database was still 1.5.1

So I checked the log files, and found this message:

I checked, and the file seems to be there.

Any ideas what's wrong?

Sounds like you fell for the ISPs auto-upgrade. yes? How new is this store? If you are about to lose lots of data, get your isp to restore your database and your store from one of your backups ASAP. ZC cannot be upgraded in this fashion.

I did the original install from the ISP, but downloaded the upgrade from the source forge link on zen-cart.com.
I'm thinking about just reinstalling the whole thing and starting over. I've only loaded a couple products to test the site at this point.

jehitch:

I did the original install from the ISP, but downloaded the upgrade from the source forge link on zen-cart.com.
I'm thinking about just reinstalling the whole thing and starting over. I've only loaded a couple products to test the site at this point.

To be honest, that is probably best. We PLAN these upgrades and TEST them step by step. This gets complex when you have a bunch of modifications done.

As I made them, I copied the few mods I made in a text file with the file name for each one, so I just reinstalled. Probably only an hour or so lost in mods, less than I spent trying to figure out what I did wrong with the upgrade <sad trombone sound>.
Thanks,
Jim

jehitch:

As I made them, I copied the few mods I made in a text file with the file name for each one, so I just reinstalled. Probably only an hour or so lost in mods, less than I spent trying to figure out what I did wrong with the upgrade <sad trombone sound>.
Thanks,
Jim

Very wise start Jim.

Not only do you need to keep a log of the modifications installed...You need to keep in that log 1)the order they were installed, 2) HOW they are installed 3)parameters you setup once you installed the modifications.

#1 can be VERY important as some mods can only be installed in a certain order (Image Handler v4 and Zen Colorbox is one example).

#2 can simply be copied files into catalog and ran sql via Admin. But sometimes this is where you have to use a tool like WinMerge to compare the old files to the new ones when core file changes are required.

#3 just saves you time!

Good Luck!
Chris

I'm seeing the same behavior as the OP, possibly with a twist. I've got a ZC v1.5.3 installation locally and am now attempting to upgrade the existing ZC 1.3.5 (!) database. I

• Imported the existing database into the v1.5.3 installation's database
• Renamed the /admin directory to (er) /admin
• Renamed the /zc_install directory

and ran the install. I accepted the license agreement and then clicked the "Upgrade Database" button. When the next screen displays, it's "funny" because none of the "Upgrade from xxx to yyy" choices are pre-selected. So, I checked 1.3.5 -> 1.3.6 and clicked the "Go" button ... to be presented with a whitescreen and the following information in a debug-log file:

[12-Oct-2014 09:04:55 America/New_York] PHP Warning:  require_once(C:/xampp/htdocs/xxxx_new/../includes/classes/vendors/password_compat-master/lib/password.php): failed to open stream: No such file or directory in C:\xampp\htdocs\xxxx_new\includes\classes\class.zcPassword.php on line 52

[12-Oct-2014 09:04:55 America/New_York] PHP Fatal error:  require_once(): Failed opening required 'C:/xampp/htdocs/xxxx_new/../includes/classes/vendors/password_compat-master/lib/password.php' (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\scubadoctor_new\includes\classes\class.zcPassword.php on line 52

What caught my eye is the /../ present in the file's path information and then I found that the path structure is being altered by /zc_install/includes/modules/pages/upgrade_database/header_php.php on line 39:

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

This test installation is running a "standard" XAMPP load with PHP 5.4.27 on a Windows 8.1 machine.

Just to follow up ...

I had imported a ZC 1.5.3 database :blush: into the test site's installation; that's why none of the upgrade from/to checkboxes were checked. When I imported the "old" database and ran the upgrade script, the script ran to completion without errors. It was only when I clicked the "Upgrade database" button when the database was already v1.5.3 that the above debug-log file was generated.