Results 1 to 10 of 10
  1. #1
    Join Date
    Jan 2007
    Posts
    169
    Plugin Contributions
    0

    Default Collation problem upgrading from 1.3.8 to 1.3.9

    I'm running the database upgrade from zc_install and got the following error ...

    Code:
    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 see in phpMyAdmin that my tables are utf8_unicode_ci and type MyISAM.

    What is your recommendation on getting the database upgraded?

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Collation problem upgrading from 1.3.8 to 1.3.9

    You will have to edit the upgrade sql and change latin1_general_ci to utf8
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Jan 2007
    Posts
    169
    Plugin Contributions
    0

    Default Re: Collation problem upgrading from 1.3.8 to 1.3.9

    Or could I use phpMyAdmin and change all my tables from utf8 to latin1_general_ci instead? Not sure if doing that would corrupt my data or not.

    And then run the script as is.

  4. #4
    Join Date
    Jan 2007
    Posts
    169
    Plugin Contributions
    0

    Default Re: Collation problem upgrading from 1.3.8 to 1.3.9

    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?
    Last edited by artcoder; 24 Nov 2010 at 07:35 AM.

  5. #5
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Collation problem upgrading from 1.3.8 to 1.3.9

    Which 1.3.9 version are you upgrading to?
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  6. #6
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Collation problem upgrading from 1.3.8 to 1.3.9

    Because I'm not seeing how to edit the mysql_upgrade_zencart_138_to_139.sql file.
    My bad should have stated installer
    Quote Originally Posted by DrByte
    Evidently you've created the table with UTF8 character set. If that's what you want to continue using, then change the DB_CHARSET in /zc_install/includes/installer_params.php to 'utf8' before using zc_install.
    Post#6
    http://www.zen-cart.com/forum/showthread.php?t=157297
    Zen-Venom Get Bitten

  7. #7
    Join Date
    Jan 2007
    Posts
    169
    Plugin Contributions
    0

    Default Re: Collation problem upgrading from 1.3.8 to 1.3.9

    Upgrading to 1.3.9h.

    And yes, setting DB_CHARSET from latin1 to utf8 appears to work. Database upgraded successfully.

    Thanks.

  8. #8
    Join Date
    Jul 2007
    Posts
    155
    Plugin Contributions
    0

    Default Re: Collation problem upgrading from 1.3.8 to 1.3.9

    So this is the Easy 3 step Upgrade !

  9. #9
    Join Date
    Apr 2006
    Location
    Ohio
    Posts
    6,162
    Plugin Contributions
    0

    Default Re: Collation problem upgrading from 1.3.8 to 1.3.9

    Quote Originally Posted by stuffdone View Post
    So this is the Easy 3 step Upgrade !
    @stuffdone,
    Maybe you would like to donate your time and help with the zencart community for detailed instructions on upgrading..
    Nothing is easy when you procrastinate 10 versions behind schedule...
    Mark
    Hare Do

  10. #10
    Join Date
    Feb 2010
    Location
    Michigan
    Posts
    2
    Plugin Contributions
    0

    Default Re: Collation problem upgrading from 1.3.8 to 1.3.9

    Thank you for the info on editing DB_CHARSET!

 

 

Similar Threads

  1. Search function not working properly (collation problem)
    By dennisysh in forum General Questions
    Replies: 9
    Last Post: 27 Apr 2010, 05:27 PM
  2. Upgrading problem from 1.3.7 to 1.3.8
    By rtfulk in forum Upgrading from 1.3.x to 1.3.9
    Replies: 1
    Last Post: 29 Oct 2009, 07:16 PM
  3. Replies: 3
    Last Post: 19 Jun 2008, 12:44 AM
  4. Problem upgrading from 1.3.0.2 to 1.3.6
    By Big Kahuna in forum Installing on a Linux/Unix Server
    Replies: 12
    Last Post: 6 Dec 2006, 09:45 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR