[Solved] problem when I change the product name ps_product_lang

[Rams]

Hi,
i use PS 1.4.0.17 whit italian language.
I have a problem when I change the product name.
Exemple :
1) I copy a product name “XXX”
2) change the name in “YYY”
3) in my language is ok ( italian ) , but in other languages, the name remains the same “XXX”

same problem for the featured

Look this is my “ ps_product_lang “

71, 1, ‘’, ‘’, ‘pennello’, ‘’, ‘’, ‘’, ‘Pennello’, ‘’, ‘’), <-Pennello OLD NAME
(71, 2, ‘’, ‘’, ‘pennello’, ‘’, ‘’, ‘’, ‘Pennello’, ‘’, ‘’), <-Pennello OLD NAME
(71, 3, ‘’, ‘’, ‘pennello’, ‘’, ‘’, ‘’, ‘Pennello’, ‘’, ‘’), <-Pennello OLD NAME
(71, 4, ‘’, ‘’, ‘pennello’, ‘’, ‘’, ‘’, ‘Pennello’, ‘’, ‘’), <-Pennello OLD NAME
(71, 5, ‘’, ‘da barba con manico in acciaio’, ‘pennello’, ‘’, ‘’, ‘’, ‘Acciaio 21’, ‘’, ‘’), <-Acciaio 21 NEW NAME

Thanks fol help.

[ToXxX]

Hi,
i use PS 1.4.0.17 whit italian language.
I have a problem when I change the product name.
Exemple :
1) I copy a product name “XXX”
2) change the name in “YYY”
3) in my language is ok ( italian ) , but in other languages, the name remains the same “XXX”

same problem for the featured

Look this is my “ ps_product_lang “

71, 1, ‘’, ‘’, ‘pennello’, ‘’, ‘’, ‘’, ‘Pennello’, ‘’, ‘’), <-Pennello OLD NAME
(71, 2, ‘’, ‘’, ‘pennello’, ‘’, ‘’, ‘’, ‘Pennello’, ‘’, ‘’), <-Pennello OLD NAME
(71, 3, ‘’, ‘’, ‘pennello’, ‘’, ‘’, ‘’, ‘Pennello’, ‘’, ‘’), <-Pennello OLD NAME
(71, 4, ‘’, ‘’, ‘pennello’, ‘’, ‘’, ‘’, ‘Pennello’, ‘’, ‘’), <-Pennello OLD NAME
(71, 5, ‘’, ‘da barba con manico in acciaio’, ‘pennello’, ‘’, ‘’, ‘’, ‘Acciaio 21’, ‘’, ‘’), <-Acciaio 21 NEW NAME

Thanks fol help.

71 is the product id, 5 is the language id.
5 is for Italian, 1 for English, ecc...
If you want to update the product name in english you have to change the language in product info (click on the flag).
Otherwise you can do a massive update on the database.

[Rams]

Otherwise you can do a massive update on the database.

how can I do this?

Graphics are good, ok for php,
but I do not know sql

[Asenar]

For changing name in a different language, click in the flag next to the field if this is enough for you.

For the mysql way :
First of all, you can type "mysql query" in google or something to help you about MySQL

Please be sure to understand the following query before using it :

1° :

update ps_product_lang set name="Acciaio 21" where id_product=71

This will change every value of the field "name" into Acciaio 21 of each row having "id_product" equals to 71

You can use this kind of query in a php script to make "a massive update" as suggested ToXxX (this is a really basic query, you can construct an other one more optimized)

[Rams]

For changing name in a different language, click in the flag next to the field if this is enough for you.

For the mysql way :
First of all, you can type "mysql query" in google or something to help you about MySQL

Please be sure to understand the following query before using it :

1° :

update ps_product_lang set name="Acciaio 21" where id_product=71

This will change every value of the field "name" into Acciaio 21 of each row having "id_product" equals to 71

You can use this kind of query in a php script to make "a massive update" as suggested ToXxX (this is a really basic query, you can construct an other one more optimized)

OOOOkkkkk

[Asenar]

Do you mean this solve your problem ?

[Rams]

I solved this way from back office :

1) I deleted languages ​​and enabled with a null value and description wrong.
2) idioms installed previously deleted and automatically creates values ​​in the database.

now I have to remember not to copy and then edit the product.
They must always be created by new.