How do I upgrade my database from cart 1.3.8a to 1.3.9d?

[rxalex]

I am trying to upgrade my database from cart 1.3.8a to 1.3.9d, I exported the database and then imported into new database. But I got a lot more tables 207 and the front end has no products but the front end looks like it lost a lot of graphics... What is the best way to upgrade the database? I also tried to use the mod back mysql database and copied it to the new shop, restoring didnt do it as recommended by someone.

[frank18]

There are detailed instructions in the docs folder of the zen-cart-v1.3.9d-full-fileset-06032010.zip

Pay special attention to these files in the docs folder of the file set:

2.readme_how_to_upgrade.html

changelog-v1-3-9d.html

whatsnew_1.3.9d.html

[rxalex]

I did read all of these but still having issues with importing the database. What am I doing wrong?

[dizzyfish]

Hi

Without more details I would give you this path to deal with your data.

But First; The reason you have more tables is due to the add-ons you had in your older version of Zen-Cart.

To upgrade you drop all the data files using phpmyadmin. Then import your old data.

The next step is to go through the same steps as when you do a fresh install of Zen Cart. At the window after you agree to terms you find that same area where Zen Cart tells you what may stand in the way of your install. File permissions for example.

At the bottom of this window is the patching section to patch a database that is older then the cart needs.

As far as why your images are gone? There are a few possibilities. Again I am guessing, but there are several places for images. If you were using a template in the past you will need to move the images inside the custom template folder. Also there can be file permission issues.

The bigger issue is that unless you use a template that has been updated the EZ-Pages will not work until you fix a template file inside your custom template/template folder. The file is tpl_ezpages_bar_header.php

Let me know if you need the php code to resolve the ez-pages issue.

Well, I hope this helps a little. If you want any more help I need more info... What server os? Are you using mysql? Do you know how to program in PHP? Are you familiar with how a ftp client works?

Last and most useful, do you have a test server and if so what are you running on it? If you are using a hosting provider? Who is the hosting provider may be helpful at a later time... but for now I would have to know about the server and database.

[rxalex]

So I create a Mysql database, import the old database into it. then install the new version into that database?

[dizzyfish]

I will try harder to be clearer...

When I tried this stuff 2 years ago everything seemed so alien, I had a hard time feeling like it was safe to poke about inside phpmysql and zen cart. Now, I know just enough to ask better questions then I would have at the beginning:)

Okay, look at what Rob answering another post just after yours has written, he writes it very clearly so you may want to look at what he and Schoolboy have in that thread...

It sounds like you want to know how to apply a patch to your mysql database? If you already did all the steps to upgrade your cart and you see a notice at the top of your screen that says you need to apply a patch as your mysql database is old or older version... whatever... the way to patch the database is as follows:

Put the zc_install folder back into the root of your cart. The root is were this folder was originally, but you were told by the security side to remove it. Put it back for this, then you can take it back out when you are done.

Once you have done this you will use a browser to do the following:
In the address bar, type in: http://yoursitename/zc_install/index.php

once this is typed in you can either hit <ENTER> on your keyboard or use your mouse and click on the go button.

You will or should see the install window come up like the time before. Follow along and agree to terms, etc. Once you get to the window that say's you need to change permissions or it may say it can not write to a configure.php file... you will know the page as you scroll down and see the green "OK" in front of the different file names.

Keep going down until you see the area at the very bottom that will say, or will alow you to update your mysql.

There will be a list of mysql update boxes. You will be able to use it to check which version you are going from and which one you are going to.

Click n the one you need. Then below this are 3 choices, or so I seem to remember. In any case check on the one that says update my database, or something to that effect. I seem to remember it is the center or second choice?

Once done it will take a moment and it should give you a success dialogue.

You have updated the mysql or more correctly "patched" your old database.

If you have not installed or upgraded the zen cart itself, then we will need to start over with different instructions. If this is the case see the thread I mentioned above by Rob and Schoolboy.

[rxalex]

Thanks Dizzy, so before the upgrade database- do I import the old database to the new mysql database via phpmyadmin?

[RodG]

Thanks Dizzy, so before the upgrade database- do I import the old database to the new mysql database via phpmyadmin?

Yes .

[rxalex]

What about the issue with 207 tables... the old database has only 112

[dizzyfish]

Yup

In phpmyadmin you click on the database name, and the window pops up that shows the tables with the selection boxes on the left 93 or so... You scroll to the bottom and click on select all, so do not waste your efforts looking for a select all at the top, then click on the little text area to the right and choose "DROP"

A new window shows up and you agree. Now you have an empty database to import your old data into. One you have imported your old data you do the patch.

IMPORTANT NOTE: When you export your old database make sure you check the box that includes the dropped table info. I read that somewhere in Zen Cart FAQ's. If you do not know what I am talking about I will try to make that a bit clearer.