Upgrading

I'm in the process of upgrading from1.3.8b to 1.5.1. I'm working on a Mac. I've installed Text Wrangler to compare files for changes.

I'm a newbie so I expect this may turn out to be a really dumb question. Here goes:

There are about 1600 files to compare and evidently Text Wrangler can only compare files, not folders when used in conjunction with Dreamweaver. My question is: do I have to compare every single file, or is there a list somewhere of the files which may have been changed/altered or a list of files which would not be changed?

I'm using the Classic template and don't think there are any add-ons. I do see the zx138a_php53 patch for the security issue with 1.3.8. The site only uses Paypal for payments.

I've inherited this site and am tasked with the upgrade. Therefore, I don't know exactly what has been or not been done with the site.

Thanks!

1. Here are some suggested tools for Mac and other operating systems: http://www.zen-cart.com/wiki/index.php/Useful_Tools

2. You really *should* compare YOUR site's files against the ORIGINAL v138a files to first determine the changes your staff have made to the site. Then, once you're armed with that VERY important information, you can relatively easily reconstruct those changes onto the latest version.
(The changes your staff made will be far fewer than what the ZC developers did in the span of 6+ years between the versions you're upgrading through.)

3. http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading

Forgive me if this is a very dumb question (but remember, I'm very new and insecure!). If I understand your reply, I need to check all 1500+ files with TextWrangler to see what, if any differences exist for every single file? Then, whatever changes I find, I correct the code in the upgrade (currently /zentest1/) and then everything should look like the 1.3.8 version's webstore?

And--how do I get the 1.3.8 products into the new upgrade version? I've imported the database (and it says it was successful) but in the test store I don't see anything from the webstore. I'm using the classic template and the structure is the same, so that makes me slightly more comfortable (but only slightly!)

Thanks for your patience.

I upgraded from 1.3.8 to 1.5.1. by carefully following the upgrade instructions. I have reached the Successful Install page. I can open the test site and things appear to function as expected. I'm slogging my way through almost 1600 files with TextWrangler to compare changes as per this forums advice. It has taken me over 12 hours to compare all the different lines of code in just the includes files that appear on both the old and new versions. There's still new files and old files not in the new version to parse. (I swear it would take less time to start from scratch! I must be missing something here.) In any event...

It occurs to me that maybe something is still not right or finalized with the upgrade. Everything on the test site is from the template (classic) and none of the original webstore's products, categories, etc. show up. I believe I've uploaded the database (I made a copy of the original, renamed it and used that copy in the install and upgrade.

How do I get the products, categories, etc. into the test site? What am I missing here? I have searched the forum and the web and I'm not finding any answers. Keep in mind that I inherited this site, am a newbie to zencart (for the most part), understand a little bit about code and css stylesheets. I've been learning a lot from the forums but also am getting more and more certain that I cannot do this upgrade--it's just too complex and there are too many files. I have no notes from the original install so that is no help.

Thanks for whatever you can do to help.

[Note: I have been able to customize the home page with the store's logo, but that's about it.]

You might want to read the documentation in the /docs directory of the new Zen Cart that you are installing ...

Then, search the FAQs, WIKI and forum for the word:
upgrade

There are a number of references to how to upgrade that should assist you in the Upgrade processes ...

bluelion:

I believe I've uploaded the database (I made a copy of the original, renamed it and used that copy in the install and upgrade.

If you imported the old data into the new database and THEN ran zc_install to do a NEW install (not selecting "upgrade") then you wiped out the contents of that imported data.
That's why the upgrade guide says for setting up a test site that you first do a new install and then import the data into that new database, and then run the database-upgrade.

Thank you so much for following this query--I'm sure you are very tired of the same old issues cropping up over and over.

Can you figure out what I am doing wrong?

Here's what I have done (four times now!) and I have followed, as carefully as possible, the Install and Upgrade instructions provided in this forum:

Install zc 1.5.1. Run zentest/zc_install. For the database, I select a copy of my 1.3.8's database, not the original one. Reach the success page.

Change config. files in admin and Includes from 444 to 755.

Run zc_install again. When I get to the Zen Cart Setup - Database Upgrade, I have the following info:

Upgrade sniffer predicts: ***No upgrade required***

(When I have done nothing, therefore, except hit the update cfg. button, my data is still not loaded.)

I check: Upgrade DB from 1.3.8 to 1.3.9, 1.3.9 to 1.5.0, 1.5.0 to 1.5.1

Leave New Table-Prefix blank

Enter Admin user name and password.
Update Database Now.

is this what's wiping my data? If so, do I just check the "done with updates" ?

Thanks for the handholding. I'm so frustrated and intimidated by this process and desparate to get it working. (Also, as a side note, I can no longer access the 1.3.8a version's admin center. This was the issue that brought me to doing the upgrade--I worked for a couple of weeks with Ajeh's help through the forum without success. My webstore owner is getting concerned, understandably, although the only payment module activated was paypal, so she should be able to get order info via PayPal instead of going through admin.)

Additional question: I have read and reread your posting. (And believe me, I have read the documentation for install and upgrade so many times I think I have it memorized.) I guess I just don't understand the obvious:

You wrote:

That's why the upgrade guide says for setting up a test site that you first do a new install and then import the data into that new database, and then run the database-upgrade.

When I go through the new install and come to the database setup page, what db should I load?

Can I just go into the config. php files and change the initially loaded db to the original one from 1.3.8 and have it work? It couldn't be that easy, could it?

I don't understand how to import the old database and have it overwrite whatever is currently in place.

Sorry for being so dense...I think this really is rocket science!

I have made some small progress but still no products. I started over and have once again gotten to the success page. I created a new database (zentest6), copied the old database into it, changed the config. files in admin and includes to reflect the new db name, and lo and behold, now the "store" no longer shows the demo products, and admin no longer shows Bill Smith as the first and only customer.

BUT:

I have no products, customer data, images, etc. The webstore is the Zencart Classic template. I can live with that if I can just get the products back...I don't mind rebuilding the template. (Remember, I inherited this site and don't know exactly what was done, added on, etc., but I figure not much was changed as the original store is very similar to the Classic template.)

I promise you I've read and re-read the install and upgrade instructions.

What do I do next to get the products, customer data, etc. in place? (For what it's worth, I checked the original db and customer and product info is there, so at least I haven't managed to lose that!).

Once again, thank you for any help you can give me. If it's possible to be specific (not just "read the install and upgrade info) that would be great.

Product images are just files on your server, located in the /images/ folder.
So, if you're moving everything to a new directory, then you'll need to move or copy your /images/ folder and subfolders to that new location in order to see them.

If your configure.php file has set the DB_XXXXX settings to point to the correct new database and correct table-prefix, then all your data should be displayed. But that supposes that the specified database actually contains the data. It sounds like you've pointed yours to an empty database created by installing ZC without demo products.

Your earlier post confirms this:

bluelion:

Install zc 1.5.1. Run zentest/zc_install. For the database, I select a copy of my 1.3.8's database, not the original one. Reach the success page.

You used zc_install to install overtop of your "copy of my 1.3.8's database", effectively wiping out its contents.

bluelion:

Run zc_install again. When I get to the Zen Cart Setup - Database Upgrade, I have the following info:

Upgrade sniffer predicts: ***No upgrade required***

no-upgrade-required because you just installed a new set of data overtop of your old database.

So, while I respect that you've said you've read the upgrade instructions a thousand times, I'll clarify again: it tells you to install ZC into that new database, and THEN import your old database contents into that database, and then run zc_install again to ask it to do the upgrade.

Thank you so much for replying so quickly. I thought I had done exactly what it said to do but I guess I don't understand. I have now uploaded the old images folder to the new test site.

To avoid overwriting the db, could you please clarify if this is the correct procedure:

I go to Cpanel and create a new database. Zentest7. I don't copy the old database into it. It is basically empty.

Run new zc_install. name db zentest7. Select the box to load demo data and products.

when success is reached (being optimistic and hopeful here!), what is next?

Go to configure php's in includes and admin, change db zentest7 to old db copy, then run the second install?

When I get to the bottom of the page offering me the Upgrade Database option, I choose that?

Do I then upgrade by version (1.3.8 to 1.3.9, etc.) or ??? (So far, sniffer has always said db was up to date. If that is still the case, do I then click "done with updates"?

Please know I appreciate your extraordinary patience. I know this is very tedious for you and I appreciate all this help.

bluelion:

To avoid overwriting the db, could you please clarify if this is the correct procedure:

I go to Cpanel and create a new database. Zentest7. I don't copy the old database into it. It is basically empty.

Run new zc_install. name db zentest7. Select the box to load demo data and products.

when success is reached (being optimistic and hopeful here!), what is next?

Confirm that you can see the demo products when visiting the site.

bluelion:

Go to configure php's in includes and admin, change db zentest7 to old db copy, then run the second install?

Yes

bluelion:

When I get to the bottom of the page offering me the Upgrade Database option, I choose that?

Yes

bluelion:

Do I then upgrade by version (1.3.8 to 1.3.9, etc.) or ??? (So far, sniffer has always said db was up to date. If that is still the case, do I then click "done with updates"?

Well, it should tell you that there are several versions to upgrade through, and pre-check the boxes.
If it doesn't, then your configure.php is still pointing to the wrong db_xxxx settings.



In your old store, what's the DB_PREFIX value in your /includes/configure.php file? Be sure to use that in your new store too.
What's the URL where this can be seen?

DrByte:

Confirm that you can see the demo products when visiting the site.
YesYesWell, it should tell you that there are several versions to upgrade through, and pre-check the boxes.
If it doesn't, then your configure.php is still pointing to the wrong db_xxxx settings.

I am beginning to understand. I finally reached the database upgrade page WITH versions checkmarked to upgrade. BIG SMILE!

Next issue: it will not accept my admin password. I have gone through the complete install twice, and VERY carefully made note of the admin password. I have tried both the one used in the initial set up, and the new password with admin renamed. Neither works.

I have tried it in a different browser.
I have tried shutting down the browser, clearing history, and re-installing.

[QUOTE=DrByte;1239564]In your old store, what's the DB_PREFIX value in your /includes/configure.php file? Be sure to use that in your new store too. What's the URL where this can be seen?

In the old store, the prefix zen_ was used (based on the config.php file) so I used that in the latest installs. I had not done that before. Thanks for that tip!

The store URL is: www.dancingtothespiritofthewood.com.

Any thoughts on why the password won't work and what to try next?

(so close, and yet so far!!!!) And thank you yet again. Your reply helped enormously.

it needs the admin password for your OLD store (since that's the data it now has in the database)

UPDATE: I went back and tried again, and used the password from the 1.3.8 webstore. I figure it must somehow be attached to the original database, although it is not the db password. Anyway, the items are now showing up in the test store.

Next issue is going to be to get the images there; I have copied the image folder from the original site to the test site but images are not showing up yet.

I'll keep working on it, but you have any suggestions as to why the images are not showing I would be most appreciative.

I'm so happy with this finally working--it's been a long long three weeks of trying to figure things out. I know I'm far from done (and I'm sure you wish I were!) but at least I can see products. Thanks so so much.

bluelion:

UPDATE: I went back and tried again, and used the password from the 1.3.8 webstore. I figure it must somehow be attached to the original database, although it is not the db password. Anyway, the items are now showing up in the test store.

Next issue is going to be to get the images there; I have copied the image folder from the original site to the test site but images are not showing up yet.

I'll keep working on it, but you have any suggestions as to why the images are not showing I would be most appreciative.

I'm so happy with this finally working--it's been a long long three weeks of trying to figure things out. I know I'm far from done (and I'm sure you wish I were!) but at least I can see products. Thanks so so much.

Like DrByte said

DrByte:

it needs the admin password for your OLD store (since that's the data it now has in the database)

I know you said Linda tried to help you get log back in to your old admin with no success. Linda probably advise you to reset the admin password. If you did then the old database password would be User Name: Admin and the password would be: admin
You can try that

Got it! THAT WORKED! Standing ovation for Dr. Byte!!!!

I'll get to work on the images problem; I have uploaded the images folder from the old site to the test site. In the old site, they were in the Images folder (public html/images). In the test site, I copied the Images folder to zentest/Images. They are now showing up in the Images subfolder of the Images folder in Zentest3. In that subfolder are also items such as attributes, categories, banners, etc. The images are not in a separate folder but rather as separate files listed after the folders.

Questions:

1. I suspect the problem is that the config. page in admin and includes is not specific enough. It says:

define('DIR_WS_IMAGES', 'images/');

Do I change that to: 'images/images/');

2. If that's not it, any idea what I do need to change? I looked at the configure php's for the old site and it matches the DIR_WS_IMAGES', 'images/'. I'll bet you knew that already.

Thanks again...wish I had a bigger word than "thanks" for all your help.

countrycharm:

Like DrByte said



I know you said Linda tried to help you get log back in to your old admin with no success. Linda probably advise you to reset the admin password. If you did then the old database password would be User Name: Admin and the password would be: admin
You can try that

Hi CountryCharm. Thank you so much for your suggestion--I didn't get it until after I'd gotten the tip from Dr. Byte. I really appreciate your input and help. I'm getting there, but it is agonizing! Thanks too for keeping an eye on the postings!

UPDATE: (last one for the day, I promise)

I changed the directory define('DIR_WS_IMAGES', 'images/' to images/images and I'll be darned if the images now appear.

Tomorrow I'll go through the whole site and make sure everything is working, and then try and take it live.

Thank you again and again. I really didn't think I could do this. Wow.

bluelion:

UPDATE: (last one for the day, I promise)

I changed the directory define('DIR_WS_IMAGES', 'images/' to images/images and I'll be darned if the images now appear.

Tomorrow I'll go through the whole site and make sure everything is working, and then try and take it live.

Thank you again and again. I really didn't think I could do this. Wow.

The reason you had to use define('DIR_WS_IMAGES', 'images/' to images/images is because you put your image folder inside the image folder.