Data base upgrade

Hi I just upgraded zencart from 1.3.2 to 1.3.8. I'm getting a "Your database appears to need patching to a higher level. See Admin->Tools->Server Information to review patch levels." but I just checked my server info and its

Zen Cart 1.3.8a
Database Patch Level: 1.3.8
v1.3.8 [2008-01-18 13:55:42] (Fresh Installation)
v1.3.8 [2008-01-18 13:55:42] (Fresh Installation)

Am I up to date and why do I have two versions of 1.3.8 on my server?

I just went into zc_install and see if there are any patches needed. It doesn't look like I need any. This is the message I get

Database Information -- Upgrade Sniffer predicts: *** No upgrade required ***

But the other thing is that it shows Database Table-Prefix = zen_ . I checked my table names in the new database and they don't have that prefix. What gives? I still need help with the original problem for the error message for the database patch.

Did you figure anything out? I am getting the same error. I was using 1.3.7 and just did a clean install of 1.3.8.

IFEELFROOSH:

But the other thing is that it shows Database Table-Prefix = zen_ . I checked my table names in the new database and they don't have that prefix. What gives? I still need help with the original problem for the error message for the database patch.

If your configure.php files contain database information that's pointing to the wrong database or wrong prefix then naturally you'll be getting unexpected results. Remember, there are two configure.php files involved: store and admin.

I just started fresh with a new upgrade. Everything is fine. A few things I noticed that I might have missed the first time around and after reading some more threads regarding upgrades :

• when doing the database upgrade I did one version at a time i.e. do one checkbox at at time until its fully upgraded from 1.3.2 to 1.3.8
• make sure the database prefix is correct

Thanks to lots of informational posts by Dr Byte.

I upgrade my zencart from 1.2.x to 1.3.8a
and get the same error result "Your database appears to need patching to a higher level. See Admin->Tools->Server Information to review patch levels."

I check the server info and it show up that my Zencart is 1.3.8a and database patch is 1.3.5
what should I do?

I dont want to loose my database because already running, so please anyone can help here?

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

Again, back up first.

yellow1912:

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! :hug:

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?

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!!

:clap:

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"

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... :Flush:

Glad to be some help.

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

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. :clap:
Good luck and...did you back things up? better do it or...

:oops: