Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17
  1. #11
    Join Date
    May 2009
    Posts
    222
    Plugin Contributions
    1

    Default Re: ZC 1.5 UTF8 Collation standard now?

    Im getting seriously .... off with ZC. Why is it so complicated?? Wordpress you just click a button to install stuff.
    I feel ZC should come to the end of its life and be replaced with something better. I just wish i could get my clients details and passwords out and import them into something that doenst need constant updating and maintenance
    I do appreciate the help though
    Last edited by creamcrackers; 25 Jul 2012 at 02:02 AM.

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

    Default Re: ZC 1.5 UTF8 Collation standard now?

    It's only as complicated as you make it. Comparing with WordPress is like comparing apples and oranges. They're very different systems because they do very different things. And none of this is related to "clicking a button to install stuff". You've got damaged files or configuration, or even damaged data, which need to be fixed.

    You haven't shared your URL, so none of us can take a direct look and offer specific help. Same with your configure.php content.

    Most likely you're telling the database to use latin1 and the PHP to use utf8, and thus things aren't displaying properly. And you've already been told that you can set DB_CHARSET to fix that. But you haven't done that yet.

    We're trying to help you, but it seems like you have your own ideas.
    Can you help us help you?
    .

    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. #13
    Join Date
    May 2009
    Posts
    222
    Plugin Contributions
    1

    Default Re: ZC 1.5 UTF8 Collation standard now?

    Quote Originally Posted by DrByte View Post
    Yes, I seem to remember that you chose not to follow the upgrade steps. And here we are, cleaning up for you. Sorry if I sound frustrated about that.

    You haven't posted your URL, nor your configure.php files. So, it's very hard to help you with specifics in that area.


    That was probably a mistake.

    I suggest putting v1.5 configure.php files onto your v1.5 site:
    Make a solid backup.
    Install a new copy of Zen Cart, letting it generate the correct configure.php files. Then use those.
    You might want to specify a separate test database to build the configure.php files, and then change the database name to point to your real database. That will save you having to restore from backup.
    Thanks. Actually I did follow those steps but i ended up with a blank screen I think due to Simple SEO URL being installed and having compatibility issues and due to their install manager it wasnt possible to uninstall it normally so I started with a new fileset and the old database and config files. The problem was made worse due to my host upgrading PHP which meant the old version of ZC wouldnt run on their server and I couldnt find any way to load the old version php/sql into MAMP to get it to work either so i could uninstall and check the old site before upgrading it. I think the fact I had upgraded to UTF8 was somehow causing the upgrade problem too.
    Basically im not a programmer, im a flower shop owner who started out, for me, I think the wrong shopping cart I would have been better off with something proprietary but basically now ive got so many customers in there and their passwords and logins arent exportable to another system I am stuck with it
    I will try what you have suggested above

    Cheers!
    Last edited by creamcrackers; 25 Jul 2012 at 01:53 PM.

  4. #14
    Join Date
    May 2009
    Posts
    222
    Plugin Contributions
    1

    Default Re: ZC 1.5 UTF8 Collation standard now?

    Also I did ask Numinix to fix this for me a while ago - but they were unable to do it because my site doesnt have a Super Admin. It only has Super Users and they said it was not possible to check it was working properly without having a Super Admin. Ive found no way to create a Super Admin. This site was upgraded from 1.3 when they didnt have Super Admins

  5. #15
    Join Date
    Jan 2011
    Posts
    70
    Plugin Contributions
    0

    Default Re: ZC 1.5 UTF8 Collation standard now?

    creamcrackers, is your site gogoflorist dot com? [found in old forum posts]
    This will help people see exactly what you see, and maybe help you fix the problem.
    Where would we change the language to see the thai version?

    Take it easy making changes, converting to UTF8 is not fun. Keep backups of everything at each step if you can.

  6. #16
    Join Date
    Jan 2004
    Posts
    66,380
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: my stores in western and my Thai script pages are showing as ??????????

    Quote Originally Posted by creamcrackers View Post
    I think the fact I had upgraded to UTF8 was somehow causing the upgrade problem too.
    Yes, most likely.

    The ideal situation is one where EVERYTHING talks consistently in the same characterset:
    - connection to database (DB_CHARSET is 'utf8')
    - data in the database (collation)
    - PHP language files (encoded as utf8-without-BOM and CHARSET is set to 'utf-8')

    In your case it seems as though probably the content of the data in your database isn't clean.
    And if it started out as latin1 and you or your customers stuffed multibyte characters into it, then converting the entire database and all its content to utf8 becomes a complicated process ... which needs to be done carefully offline in a test site so you can prepare all your steps to apply to the live site once well tested.
    .

    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.

  7. #17
    Join Date
    Jan 2009
    Location
    Earth
    Posts
    36
    Plugin Contributions
    0

    Default Re: ZC 1.5 UTF8 Collation standard now?

    Quote Originally Posted by DrByte View Post
    For NEW STORES, it assumes UTF8 automatically. http://www.zen-cart.com/forum/showthread.php?t=190424

    If you are UPGRADING, then you will need to convert your data manually, using VERY SPECIAL CARE.
    NOTE TO ALL FUTURE READERS OF THIS DISCUSSION: If your store does not NEED utf-8 then you DO NOT NEED TO CONVERT ANYTHING. See: https://www.zen-cart.com/tutorials/i...hp?article=414
    Hi Dr.Byte,
    I've installed new ZC 1.5.1 and still getting the problem showing chinesse and arabic letters.
    In front page (home) I've added words in chinese and arabic (copy pasted from google translate) and it shows up like this:

    أفضل مزود العود
    最好的沉香供应商

    Thank you very much in advance for any clues.

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Checkout and other secured pages are not showing as secured
    By davidmay354 in forum General Questions
    Replies: 1
    Last Post: 5 Sep 2012, 08:25 PM
  2. Replies: 8
    Last Post: 4 May 2012, 08:17 PM
  3. Category pages are not showing?
    By gabriel25 in forum Setting Up Categories, Products, Attributes
    Replies: 4
    Last Post: 25 Jan 2010, 10:34 PM
  4. HELP.. My SSL pages are not showing
    By captnbob in forum Basic Configuration
    Replies: 2
    Last Post: 9 Apr 2008, 03:15 PM
  5. Cart pages are showing up weird and making my site scroll?
    By andreadesigns in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 5 Jun 2007, 02:27 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