Data base upgrade

[dmwizzard]

Back up your db, then run the upgrade again, choose to upgrade db only. You should lose nothing.

Again, back up first.

I too have the same problem, I back-up my database and installed the Zen cart update using cPanel from my hosting package. I then re-applied my BD back.

The trouble is, doing a server side upgrade there is no option to Update again. Is there a 'manual' way to patch the DB??

Cheers!

[Sheddoggie]

Same here...
I upgraded from 1.3.5 to 1.3.8a using Fantastico and now my database is stuck on 1.3.5

Any way to update the database WITHOUT doing another install?

[dmwizzard]

Ok, It's taken me most of the Day But, i'm back up and running.
Here's what I did and a possible simple way to update the database without a complete re-install... for those of us with cPanel/Fantastico update.

1, Downloaded old Shop to Hard Drive, for backup
2, Made a backup of SQL Database
3, Installed a NEW Zen Cart in to a temp folder (ie Shop2) using cPanel
4, Renamed downloaded backed up SQL file to read the same name as new BD file. ie zc1.sql.gz to zc2.sql.gz and uploaded it to apply old data to new database.

Of course that made the new Shop install start reporting database patch required.

To fix this I downloaded the Full install of Zen cart to my computer and then copied the zc-install folder in to my new Shop directory (shop2) Then it was just a case of running the update again....

Important note: DO NOT INSTALL, All you need to do is run the Update database!!! and in my case (Very old install) this update Database needed to run 3 times - as it only seemed to update one version at a time.

Fianlly, I renamed the old shop folder (Host side) to old_*** and simply renamed the new install to match what the old one was called. Then after a small edit of the config files to point to the new location - I was done!!



Now, after going through all this I realised that 'MAYBE' all I need to do was simply copy the newly downloaded 'zc_install' folder up to my FTP site and run the update Database option.... I'm guessing and maybe someone with more knowledge could verify that.

Oh yeah, one other thing... I copied across my templates and my custon edits in the Design page editor.

Anyway, I hope this helps some, if not all out...

...and like everyone says "BACK UP FIRST"

[Sheddoggie]

Good work dmwizzard! Thats pretty much the same direction I was heading.

After I downloaded the full new version I kept thinking about just loading the new install folder to see what happens...

So...after reading your results and yes, backing up things I think I'll dive over the rail and just try the install folder theory.

I'll report my findings...

[dmwizzard]

Glad to be some help.

I'll be interested to see if it works for you and/or others.

[Sheddoggie]

It worked! I uploaded only the zc_install folder. Heres what worked for me:

After trying to update through Fantastico the database did not update, so to work around manually...
1. Back up everything you are nervous of loosing.
2. Download latest version 1.3.8a
3. Unzip and upload the zc_install to your server into the /shop folder. Or what ever you named your store.
4. Use your web browser to go to the address of the zc_install folder, ie yourdomain.com/shop/zc_install
5. Run update database ONLY.
It will require being run for every upgrade level. I was starting with 1.3.5 so it upgrade 3 times to get to 1.3.8. I checked via the Zen Cart admin-tools-Server/Version info drop down window after the first run and saw it had updated me one version. I used the browser "back" button and made it resend info and was able to get it to run the next update. Had to load in password and user name for each update.
6. I suspect this method is at best a work around. You will encounter a little weirness when you wait for the update to process, a nearly blank page with no indication of anything running/or happening. Thats when you go check via admin to see if you got move up a version.

It's a clunky way to do it, but seemed to work.
Good luck and...did you back things up? better do it or...