Results 1 to 10 of 10
  1. #1
    Join Date
    Jan 2007
    Posts
    173
    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
    Posts
    26,512
    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
    Get Your Business Found

  3. #3
    Join Date
    Jan 2007
    Posts
    173
    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
    173
    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
    60,545
    Blog Entries
    4
    Plugin Contributions
    145

    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!
    Donations always welcome: www.zen-cart.com/donate

    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
    Posts
    26,512
    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
    Get Your Business Found

  7. #7
    Join Date
    Jan 2007
    Posts
    173
    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
    149
    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,099
    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 - Does the rabbit beat Zen "never".
    Zen Cart 1.5.1 Update Release Need help Purchase the Book

  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. 1253 COLLATION Error Message
    By cactusrunning in forum Upgrading from 1.3.x to 1.3.9
    Replies: 5
    Last Post: 11 Nov 2010, 01:54 AM
  2. Collation question
    By r189 in forum General Questions
    Replies: 3
    Last Post: 9 Aug 2010, 05:28 AM
  3. collation
    By rxalex in forum General Questions
    Replies: 3
    Last Post: 29 Jun 2010, 09:41 AM
  4. Search function not working properly (collation problem)
    By dennisysh in forum General Questions
    Replies: 9
    Last Post: 27 Apr 2010, 05:27 PM
  5. Replies: 3
    Last Post: 19 Jun 2008, 12:44 AM

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
  •