Database Patch Level

[PinkLeopard]

Upgraded but using my old database and received this:

Your database appears to need patching to a higher level. See Admin->Tools->Server Information to review patch levels.

This is what I have:

Zen Cart 1.3.9g

Database Patch Level: 1.3.8

All the files are 1.3.9 g but it appears my database is still 1.3.8.

So my question is which patch do I need?

Thanks!

[Ajeh]

This says you have not run the:
/zc_install

on the database to upgrade it to v1.3.9 ...

[PinkLeopard]

Hi Linda....

I followed the instructions under FAQ's.

All the files are 1.39g

BUT I wanted to used the products from my old database..

I am not sure how to fix the problem...

Which patch to apply....

Thanks!

(originally I did run the zc install --- moved over the database and then applied the php file)

[Ajeh]

If you read the files in the /docs directory, it will give you details on how to Upgrade ...

[PinkLeopard]

Sorry Linda for asking this question...but I looked at the docs.

Do I do each html starting from 1.39a?

Maybe someone else might have the same question and can benefit from this too.

I have never done this before and I want to make sure I am on the right path.

Thanks!

[Ajeh]

I would read the file:
/docs/2.readme_how_to_upgrade.html

plus all the other files that came with your current version of Zen Cart ...

Then look at the Tutorials/FAQs and search on:
upgrade


When upgrading the database, the /zc_install will pick for you the Upgrades you need ...

The best method is to uncheck all but the first one that it has picked ... run that upgrade ... then have it do a recheck ... and continue to do 1 by 1 based on what it picks for you until it is done ...

Make Backups and make backups and make backups before doing upgrades ... and if I did not mention it ... make backups ...

[PinkLeopard]

Wow...thanks Linda...

I will definitely make a backup...after backup...

Thanks so much...

p.s. I will let you know if I run into any problems...

[PinkLeopard]

So....I read it followed the instructions and click on the last box..

1.38 to 1.39

and put in my Admin name & pw and got this message:

1253 COLLATION 'latin1_general_ci' is not valid for CHARACTER SET 'utf8'
in:
[CREATE TABLE counter_history_clean as SELECT * FROM counter_history WHERE 1 GROUP BY startdate COLLATE latin1_general_ci;]

Huh?

[PinkLeopard]

Guess it did not work...put my site in Maintenance.

I am able to log-in but still the red warning about the database.

[DrByte]

Apparently your database is set to utf8 mode. You'll need to edit the /zc_install/includes/installer_params.php file and change the DB_CHARSET from 'latin1' to 'utf8'.
Then the zc_install steps should run fine.