Database upgrade failed.

10 Jun 2010, 8:22 AM

#1

New Zenner

Join Date:: Sep 2007
Posts:: 24
Plugin Contributions:: 0

Database upgrade failed.

When upgrading my database from 1.3.8 to 1.3.9, I get this error:

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

My install is otherwise complete, as far as I can tell.

Is there another way to patch the database? :(

10 Jun 2010, 7:06 PM

#2

branden

New Zenner

Join Date:: Apr 2010
Location:: Seattle, WA
Posts:: 50
Plugin Contributions:: 0

Re: Database upgrade failed.

I am trying to help a guy whos site is very messed up. he had it made though dreamco designs.... So many functions are not working that I decided to upgrade him to the latest zen cart and remake everything correctly. When I went to update the database this is what I received. Every other time I have used the zc_installer to upgrade it has worked perfectly. I'm not sure how to fix the database issue so any help would be very much appreciated.

This is the error I get.

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

Dreamco designs e-mailed the database in a .zip file I am unable to get cpanel access to try to get my own copy of the database. But if the issue is caused by a setting in php my admin let me know. Thanks in advance

http://www.zencartcodeanddesign.com/

10 Jun 2010, 7:51 PM

#3

simply_sterling

New Zenner

Join Date:: Jun 2009
Posts:: 12
Plugin Contributions:: 0

Re: Database upgrade failed.

I'm getting the same exact error as listed below. I updated the site from 1.3.9b to 1.3.9d but the database was out of date and shows an error on my homepage as well as my admin page. I tried Upgrading Database again but now it says that it is not needed, yet in Admin it shows 1.3.8 database still. Seems as though this is a more common problem than thought, but I cannot get my site up and running with errors showing on my site.

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;]

10 Jun 2010, 11:27 PM

#4

branden

New Zenner