Database Patch

[karmasherbs]

Evidently you've created the table with UTF8 character set. If that's what you want to continue using, then change the DB_CHARSET in /zc_install/includes/installer_params.php to 'utf8' before using zc_install.

Thanks Heaps!!

[aeolidia]

Hello!

I have a UTF-8 database and I'm getting this error on upgrade:

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

I have edited installer_params.php to try utf8 and to uncomment the "IGNORE_DB_CHARSET" line - no luck for either!

I've also added a my_db_charset.php in the extra_configures folders. Is there somewhere else I need this info? I'm thinking I inadvertently lost a needed file change when preparing the upgrade files.