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.

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

Attachment 15367
Attachment 15368

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

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?

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

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?

---

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.

Good catch! I will update the module over the weekend.

Quote:

---

Originally Posted by lat9

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.

---