Because I'm not seeing how to edit the mysql_upgrade_zencart_138_to_139.sql file.
The line in question is ...
And I don't see the mention of "latin" anywhere in this file. I don't find the word "collate" in the script either.
# fix counter_history race condition
CREATE TABLE counter_history_clean as
SELECT * FROM counter_history WHERE 1 GROUP BY startdate;
DROP TABLE counter_history;
RENAME TABLE counter_history_clean
I also wonder... If the above sql statement fails, does it abort the script? Or do the subsequent sql statements get run nevertheless?