Upgrading Database error

[honrheart]

I have tried to upgrade the database to 1.3.9 but I get the following message:

1253 COLLATION 'latin1_general_ci' is not valid for CHARACTER SET 'utf8'
in:
[CREATE TABLE zen_counter_history_clean as SELECT * FROM zen_counter_history WHERE 1 GROUP BY startdate COLLATE latin1_general_ci;]

Any suggestions??

[kobra]

latin1 is default so somewhere along the way you must have converted to utf8
Would have to edit the sql update and change to utf8

[dewluca]

I'm having the same problem and don't have any idea where to find what I'm supposed to fix . . . could you please provide more information/details?
Thanks!

[honrheart]

How do you edit the sql update? I really don't want to mess up my database lol.