How do I know what the "new" version files are?

[Jeffries Productions]

I first got an error. Tried it again, and dint get an error. hit the re-check button and then hit done.

Now after doing it again. I got this error again:
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;]

I understand what that means, but does that mean I have to go through all the tables and change all the character sets to utf8?

[Jeffries Productions]

I just checked my database and my,
MySQL connection collation: utf8_unicode_ci

and ALL of my tables say under collation: utf8_unicode_ci.

Where could this be going wrong?

[DrByte]

That collation error comes from the fact that the system defaults to latin1, not utf8, but your database is utf8.

You can override that by editing the /zc_install/includes/installer_params.php to set DB_CHARSET from latin1 to utf8

[Jeffries Productions]

Ok I believe that went well.

My last concern is how do I edit this "HEADER_TITLE_CATALOG" to say "Home"?

Is it common to get all of these again when you update you site?

"This content is located in the file at: /languages/english/html_includes/YOUR_TEMPLATE/define_main_page.php

You can quickly edit this content via Admin->Tools->Define Pages Editor, and select define_main_page from the pulldown.

NOTE: Always backup the files in /languages/english/html_includes/your_template"

[DrByte]

My last concern is how do I edit this "HEADER_TITLE_CATALOG" to say "Home"?

Apparently you deleted this line from your /includes/languages/english/your_template/header.php:

  define('HEADER_TITLE_CATALOG', 'Home');

... and probably other stuff too.