Database Patch Level

[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.