Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2007
    Posts
    24
    Plugin Contributions
    0

    Default 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?

  2. #2
    Join Date
    Apr 2010
    Location
    Seattle, WA
    Posts
    45
    Plugin Contributions
    0

    Default 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

  3. #3
    Join Date
    Jun 2009
    Posts
    12
    Plugin Contributions
    0

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

  4. #4
    Join Date
    Apr 2010
    Location
    Seattle, WA
    Posts
    45
    Plugin Contributions
    0

    Default Re: Database upgrade failed.

    Im thinking they forgot to check some of the settings when outputting the file but without access to do it my self I am at a little bit of a loss.

  5. #5
    Join Date
    Sep 2007
    Posts
    24
    Plugin Contributions
    0

    Default Re: Database upgrade failed.

    Sounds like we're having the same problem. I wonder if there is a way to change the character set via phpAdmin.

  6. #6
    Join Date
    Apr 2010
    Location
    Seattle, WA
    Posts
    45
    Plugin Contributions
    0

  7. #7
    Join Date
    Sep 2007
    Posts
    24
    Plugin Contributions
    0

    Default Re: Database upgrade failed.

    The answer is explicitly here:
    http://www.zen-cart.com/forum/showpo...48&postcount=6

    AWESOME!

 

 

Similar Threads

  1. Connection to Database failed.
    By jsrede in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 6 Feb 2009, 10:24 PM
  2. Connection to Database failed
    By conglm in forum Installing on a Linux/Unix Server
    Replies: 3
    Last Post: 11 Dec 2008, 09:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •