Printable View
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.
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
I did read all of these but still having issues with importing the database. What am I doing wrong?
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.
So I create a Mysql database, import the old database into it. then install the new version into that database?
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.
Thanks Dizzy, so before the upgrade database- do I import the old database to the new mysql database via phpmyadmin?
Yes .Quote:
Originally Posted by rxalex
What about the issue with 207 tables... the old database has only 112
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.
207 tables?
Hmmmm... I show 93 or so when I do a clean install. Did you add something or?
I would need more info about your set-up before I could say what is up. Well, going to dinner, I will be back later, God Willing...
https://www.zen-cart.com/tutorials/index.php?article=98Quote:
So I create a Mysql database, import the old database into it. then install the new version into that database?
https://www.zen-cart.com/tutorials/i...hp?article=108
Excellent Dizzy, I believe thats what I was doing wrong not dropping database. Ok but now im getting the install not upgrade :(
It's enough to make ones spleen ache... But with perseverance we can over come this minor set back...
So, you dropped and then did you import the old database after?
Your right, yes I dropped the tables and imported the old database, then tried to do an upgrade of the database but didnt have that option, the only option was install or upgrade cfg files.
Your DB_PREFIX in the new site configure.php files is probably different from the old site. It won't work if they're different.
Thanks, how do I check the difference, it would be in the configure.php file?
Thanks, I changed the prefix and upgrade option appeared, but got this error
1253 COLLATION 'latin1_general_ci' is not valid for CHARACTER SET 'utf8'
in:
[CREATE TABLE zen_counter_history_clean as SELECT * FROM zen_counter_history WHERE 1 GROUP BY startdate COLLATE latin1_general_ci;]
I appreciate the help
Just do this: http://www.zen-cart.com/forum/showpo...48&postcount=6
Thanks doc that helped. In backend and front end I get this message Your database appears to need patching to a higher level. See Tools->Server Information to review patch levels. ok then re-ran the patch and seems that message went away. Thank you, so this means all went well...
Ok finally uopgraded thanks for the help.. But images are missing I insert into correct path, not sure why they are all x'ed out
Check if the files are on the server and if so, check the permissions ...
The files are on the server, folder permission is 777 and files are 644, weird I look at the configure files as well... I cant figure it out
What happens if you delete one that is coming up bad and reload it via FTP? :unsure:
You have double filename extentions:
Genteal_Lubricant_Liquid_Gel_Eye_Drops_.15oz.jpg
and that is causing issues ...
Try using something like:
Genteal_Lubricant_Liquid_Gel_Eye_Drops_15oz.jpg
instead of:
Genteal_Lubricant_Liquid_Gel_Eye_Drops_.15oz.jpg
Also check if the only ones doing this are in the /images/uploads directory ...
That is really designed for uploads from customers not for storing images for your shop ...
You could have a conflict on the .htaccess files ...
Thanks Linda, I think I have a conflict, how do I fix this conflict in .htaccess?
If you do not use customer uploads see what happens if you rename the .htaccess in the /images/upload directory to .htaccess_hide
If that does not work, rename it back ... then post what you have in the file:
/images/.htaccess
Thanks that worked :)
Which change worked for you? :smile:
renamed the .htaccess in the /images/upload directory to .htaccess_hide
Thanks for the update ...
NOTE: This is not a recommended fix for anyone using the /images/uploads in its normal, expected manner for managing upload files from customers ...
I was waiting to do my upgrade until I had more of a handle on how to do it...but having someone work on site and they hit the auto update in admin area. Now, I am getting the database patch error. I tried to use the mysql backup to restore to older version just a day earlier and will not work.
Since, I did not start the upgrade from ftp file transfer and step by step directions- it was done automatically..where do I begin in the directions? Do I perform the database transfer? Should I follow the directions in this post?
Thanks, Kim