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