upgrade problems

[Kathi_S]

I believe I followed the "three easy steps" completely, but when I did the database upgrade I got this 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;]

I have no idea what this means or what I need to do to fix it. Please help.

[stevesh]

Check post #33 here:

http://www.zen-cart.com/forum/showthread.php?t=162378

[Kathi_S]

Thanks, that worked. Now when I go into my admin page I get a yellow warning:

Warning Your database appears to need patching to a higher level. See Tools->Server Information to review patch levels.

How do I fix this?

Thank you very much,

Kathi

[ksookma]

You need to run the database patch by navigating back to the zc_install path and choosing database upgrade rather then install.

-Kris