Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Location
    WA
    Posts
    555
    Plugin Contributions
    0

    Default Diamond characters and I tried defining DB_CHARSET

    Hi. I am working on getting my site to 1.5.1 from 1.3.9h. Today I was able to get about 90% of it working and am now trying to solve some of my problems.

    One is that I see diamonds with question marks all over. I see that this has been addressed many times and I've read every post I could find. But I must not be understanding something.

    First, I put the define statement into /includes/configure.php and the admin/includes define('DB_CHARSET','latin1);
    I cleared my cached and reloaded the page and they (darn diamonds) are still there.

    I checked my old english.php files to see what they referred to, and the only thing I see is:
    setlocale(LC_TIME, 'en_US.utf8').

    What else should I look at?

    Thank you for your help.
    Linda

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

    Default Re: Diamond characters and I tried defining DB_CHARSET

    Zen-Venom Get Bitten

  3. #3
    Join Date
    Sep 2008
    Location
    WA
    Posts
    555
    Plugin Contributions
    0

    Default Re: Diamond characters and I tried defining DB_CHARSET

    Thank you so much, that seemed to work.

    One thing though, when I ran the script, I got an error message twice (same message):
    Processing table [zen_combination_discounts_purchase]:
    Dropped index idx_date_added. Unique: No
    MySQL Error: Incorrect table definition; there can be only one auto column and it must be defined as a key
    Dropped index idx. Unique: No
    Altered field selector_type on zen_combination_discounts_purchase from type char(20)
    Table altered: zen_combination_discounts_purchase
    Altered field active on zen_combination_discounts_purchase from type char(1)
    Table altered: zen_combination_discounts_purchase
    Altered field discount_units on zen_combination_discounts_purchase from type char(1)
    Table altered: zen_combination_discounts_purchase
    Created index idx_date_added on zen_combination_discounts_purchase (date_added). Unique: No
    MySQL Error: Duplicate key name 'idx'
    Created index idx on zen_combination_discounts_purchase (id). Unique: No

    Processing table [zen_combination_discounts_required]:
    MySQL Error: Incorrect table definition; there can be only one auto column and it must be defined as a key
    Dropped index idx. Unique: No
    Dropped index idx_discout_id. Unique: No
    Altered field selector_type on zen_combination_discounts_required from type char(20)
    Table altered: zen_combination_discounts_required
    MySQL Error: Duplicate key name 'idx'
    Created index idx on zen_combination_discounts_required (id). Unique: No
    Created index idx_discout_id on zen_combination_discounts_required (discount_id). Unique: No


    Should I be concerned with this? I'm not sure what idx is.

    Linda

 

 

Similar Threads

  1. v154 CHARSET / DB_CHARSET: Valid combinations?
    By lat9 in forum General Questions
    Replies: 2
    Last Post: 5 Feb 2016, 02:43 PM
  2. 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
  3. v139h Defining a new and pre owned price for all SKUs -
    By PatF in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 14 Mar 2013, 11:54 AM
  4. defining paths and data base info in configure.php
    By nomad in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 23 Jan 2011, 04:50 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