Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,474
    Plugin Contributions
    88

    Default [Done v155c] ZC1.3.9h->1.5.5b: DB_CHARSET is blank

    I'm in the process of a Zen Cart 1.3.9h -> 1.5.5b upgrade. The site owner had asked me to check on "blank descriptions" being displayed in the products' admin and, sure enough, the issue was still present after the upgrade, running PHP 5.6.

    When performing the upgrade, I did all the file copies/merges and then used zc_install to first update the configure.php files to the new format and then perform the database upgrade. When I inspected the configure.php files generated, both the admin and the storefront versions included the following statement:
    Code:
    define ('DB_CHARSET', '');
    Yep, set to a null-string ... not utf8 or latin1. Once I properly set the DB_CHARSET to utf8, those product descriptions started displaying in the admin.

    Note, too, that the DB_CHARSET value was initially defined in Zen Cart 1.5.0 ... so the ZC 1.3.9h version of the file didn't contain such a statement. I believe that that's the "cause" of the issue: the upgrade-configure-files handling isn't accounting for the fact that the DB_CHARSET definition might not pre-exist.

  2. #2
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: ZC1.3.9h->1.5.5b: DB_CHARSET is blank

    Thanks for reporting this, with details!

    I believe this should fix the issue: https://github.com/zencart/zencart/pull/1354
    .

    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.

  3. #3
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,474
    Plugin Contributions
    88

    Default Re: ZC1.3.9h->1.5.5b: DB_CHARSET is blank

    Thanks, DrByte!

 

 

Similar Threads

  1. v155 [Done v155c] $product_type incorrectly set in admin/product.php
    By apogeerockets in forum Bug Reports
    Replies: 1
    Last Post: 20 Dec 2016, 07:22 PM
  2. v155 ZC1.5.4->1.5.5b upgrade, ENABLE_SSL is blank
    By lat9 in forum Bug Reports
    Replies: 4
    Last Post: 11 Dec 2016, 09:02 PM
  3. v154 CHARSET / DB_CHARSET: Valid combinations?
    By lat9 in forum General Questions
    Replies: 2
    Last Post: 5 Feb 2016, 02:43 PM
  4. ability to define DB_CHARSET in v1.3.9?
    By davico in forum Upgrading from 1.3.x to 1.3.9
    Replies: 35
    Last Post: 25 Jan 2014, 02:37 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR