Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

installing a new language


felix_at

Recommended Posts

Posted

hi all,

 

I try to install a new language (Italian), while installing a new language the ADMIN copies all the product-descriptions of one existing language to the new one. My problem is, how can I control which product-description is copied, it should be in my case the English one. so the user-interface will be Italian and all the products in English, but it is always in German, which is my default language.

If I change the default to English and then install Italian it makes no difference.

 

Can anyone please help me ?

 

Thank you

 

Felix

Posted

it dont change once you have filled the database.

you would have to delete the new installed language (you dont have to ftp/remove the folders) change your default to english and then install the language new.

 

john

Posted

Hi john,

 

thank you your answer. I did as you told me, but again the product-description in Italian is copied from the German records.

I think the solution could be found in admin/languages.php. there are the following statements, defining the source language for creating these records. But I cannot find where $languages_id is set and what is the current value

 

// create additional products_description records
       $products_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, pd.products_url from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where pd.language_id = '" . (int)$languages_id . "'");
       while ($products = tep_db_fetch_array($products_query)) {
         tep_db_query("insert into " . TABLE_PRODUCTS_DESCRIPTION . " (products_id, language_id, products_name, products_description, products_url) values ('" . (int)$products['products_id'] . "', '" . (int)$insert_id . "', '" . tep_db_input($products['products_name']) . "', '" . tep_db_input($products['products_description']) . "', '" . tep_db_input($products['products_url']) . "')");
       }

 

any idea ???

 

thank you

 

Felix

Posted

you can find the language_id used throughout the database and it will have id values

1=english

2=german

3=spanish

 

then there are default settings for the language_id which is normally set to 1 which again is english, check that yours are set to 1 and not 2

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Posted

now I found a way getting the result I need:

 

I insert a statement

$languages_id ="1";

 

in the admin/language.php, then I install a new language. Next step, I delete the statement and use the original php again.

Not a nice solution, but usable.

 

Thank you !

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...