Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2009
    Location
    Amersfoort, The Netherlands
    Posts
    2,846
    Plugin Contributions
    25

    Idea or Suggestion Multi Language Country Names Support Thread

    This is the support thread for the new module: Multi Language Country Names

    This will give you the ability to give the country names the right translation for each installed language in your store.

    As soon as the link for the download is know it will be posted here.

  2. #2
    Join Date
    Dec 2009
    Location
    Amersfoort, The Netherlands
    Posts
    2,846
    Plugin Contributions
    25

    Default Re: Multi Language Country Names Support Thread

    Here is the download link once the module is approved you will be able to use it

    http://www.zen-cart.com/downloads.ph...le&id=2006

    Image1.jpg
    Image2.jpg

  3. #3
    Join Date
    Dec 2009
    Location
    Amersfoort, The Netherlands
    Posts
    2,846
    Plugin Contributions
    25

    Default Re: Multi Language Country Names Support Thread

    the above link seems to be invalid. this is the right one

  4. #4

    Default Re: Multi Language Country Names Support Thread

    I installed the module and now getting the error:

    PHP Fatal error: 1054:Unknown column 'c.countries_id' in 'on clause' :: select c.customers_firstname, c.customers_lastname, c.customers_telephone,
    c.customers_email_address, ab.entry_company, ab.entry_street_address,
    ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id,
    z.zone_name, co.countries_id, cn.countries_name,
    co.countries_iso_code_2, co.countries_iso_code_3,
    co.address_format_id, ab.entry_state
    from (customers c, address_book ab )
    left join zones z on (ab.entry_zone_id = z.zone_id)
    left join countries co on (ab.entry_country_id = co.countries_id)
    left join countries_name cn on (c.countries_id = cn.countries_id)
    where c.customers_id = '3590'
    and ab.customers_id = '3590'
    and c.customers_default_address_id = ab.address_book_id
    and cn.language_id = '5' ==> (as called by) /xxx/includes/classes/order.php on line 268 <== in /var/www/xxx/includes/classes/db/mysql/query_factory.php on line 167

    What is going wrong?

  5. #5
    Join Date
    Dec 2009
    Location
    Amersfoort, The Netherlands
    Posts
    2,846
    Plugin Contributions
    25

    Default Re: Multi Language Country Names Support Thread

    I am not near my computer right now, so I'll have to get back to you later for the exact answer. I suspect it has to do with newer, Sql rules.
    Quote Originally Posted by manage-it View Post
    I installed the module and now getting the error:

    PHP Fatal error: 1054:Unknown column 'c.countries_id' in 'on clause' :: select c.customers_firstname, c.customers_lastname, c.customers_telephone,
    c.customers_email_address, ab.entry_company, ab.entry_street_address,
    ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id,
    z.zone_name, co.countries_id, cn.countries_name,
    co.countries_iso_code_2, co.countries_iso_code_3,
    co.address_format_id, ab.entry_state
    from (customers c, address_book ab )
    left join zones z on (ab.entry_zone_id = z.zone_id)
    left join countries co on (ab.entry_country_id = co.countries_id)
    left join countries_name cn on (c.countries_id = cn.countries_id)
    where c.customers_id = '3590'
    and ab.customers_id = '3590'
    and c.customers_default_address_id = ab.address_book_id
    and cn.language_id = '5' ==> (as called by) /xxx/includes/classes/order.php on line 268 <== in /var/www/xxx/includes/classes/db/mysql/query_factory.php on line 167

    What is going wrong?

  6. #6
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,366
    Plugin Contributions
    87

    Default Re: Multi Language Country Names Support Thread

    The alias for the countries_id in the portion highlighted below should be co.countries_id instead of c.countries_id:
    Code:
    PHP Fatal error: 1054:Unknown column 'c.countries_id' in 'on clause' :: select c.customers_firstname, c.customers_lastname, c.customers_telephone,
    c.customers_email_address, ab.entry_company, ab.entry_street_address,
    ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id,
    z.zone_name, co.countries_id, cn.countries_name,
    co.countries_iso_code_2, co.countries_iso_code_3,
    co.address_format_id, ab.entry_state
    from (customers c, address_book ab )
    left join zones z on (ab.entry_zone_id = z.zone_id)
    left join countries co on (ab.entry_country_id = co.countries_id)
    left join countries_name cn on (c.countries_id = cn.countries_id)
    where c.customers_id = '3590'
    and ab.customers_id = '3590'
    and c.customers_default_address_id = ab.address_book_id
    and cn.language_id = '5' ==> (as called by) /xxx/includes/classes/order.php on line 268
    Look in /YOUR_ADMIN/includes/classes/order.php, either on or before line 268, recognizing that the table names are most likely identified by their defined names, i.e. TABLE_COUNTRIES instead of countries.

  7. #7
    Join Date
    Dec 2009
    Location
    Amersfoort, The Netherlands
    Posts
    2,846
    Plugin Contributions
    25

    Default Re: Multi Language Country Names Support Thread

    Good catch! I will update the module over the weekend.
    Quote Originally Posted by lat9 View Post
    The alias for the countries_id in the portion highlighted below should be co.countries_id instead of c.countries_id:
    Code:
    PHP Fatal error: 1054:Unknown column 'c.countries_id' in 'on clause' :: select c.customers_firstname, c.customers_lastname, c.customers_telephone,
    c.customers_email_address, ab.entry_company, ab.entry_street_address,
    ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id,
    z.zone_name, co.countries_id, cn.countries_name,
    co.countries_iso_code_2, co.countries_iso_code_3,
    co.address_format_id, ab.entry_state
    from (customers c, address_book ab )
    left join zones z on (ab.entry_zone_id = z.zone_id)
    left join countries co on (ab.entry_country_id = co.countries_id)
    left join countries_name cn on (c.countries_id = cn.countries_id)
    where c.customers_id = '3590'
    and ab.customers_id = '3590'
    and c.customers_default_address_id = ab.address_book_id
    and cn.language_id = '5' ==> (as called by) /xxx/includes/classes/order.php on line 268
    Look in /YOUR_ADMIN/includes/classes/order.php, either on or before line 268, recognizing that the table names are most likely identified by their defined names, i.e. TABLE_COUNTRIES instead of countries.

 

 

Similar Threads

  1. v154 Search: Prioritize Matching Names [Support Thread]
    By lat9 in forum All Other Contributions/Addons
    Replies: 16
    Last Post: 9 Nov 2022, 10:45 PM
  2. Multi Cross Sell mod [Support thread]
    By gilby in forum All Other Contributions/Addons
    Replies: 475
    Last Post: 11 Apr 2020, 10:44 PM
  3. CartSideboxWithButtonandFreeShipping - Multi language support?
    By Jeet Kune Do in forum Addon Sideboxes
    Replies: 20
    Last Post: 7 Jun 2010, 03:05 PM
  4. How to set a default country per language for multi language sites
    By lacabessa in forum Addon Language Packs
    Replies: 2
    Last Post: 18 Nov 2006, 11:00 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