Prestashop: Custom feature value does not save in multilanguage shop

Created on 2 Jul 2020 · 7Comments · Source: PrestaShop/PrestaShop

Describe the bug

A product custom feature value is not saved in backoffice when there are multiple languages installed AND the default language is NOT english.

When only 1 language is installed (any language) and set as default, it works fine.
When multiple languages are installed and enabled, and English is set as default, it works fine.

Expected behavior

Custom feature value should be saved.

Steps to Reproduce

Steps to reproduce the behavior:

Install fresh PS 1.7.6.5
Install and enable second language, and make it default language
Add a predefined feature
Now add a product using a predefined feature AND a custom feature

=> only the predefined feature is saved

Additional information

PrestaShop version: 1.7.6.5
PHP version: 7.3

1.7.6.5 1.7.7.0 BO Bug Duplicate FO Features Major Products

Source

TVBZ

All 7 comments

Thanks for opening this issue! We will help you to keep its state consistent

prestashop-issue-bot[bot] on 2 Jul 2020

To make the bug even more complete. The employee should use the same language as the shop's default language, of it's not te same the user can't edit/create a custom feature.

NKoonen on 2 Jul 2020

👍1

Hi @TVBZ ,
First you need to downgrade your PHP version. You can have a full overview of PrestaShop system requirement here :
https://devdocs.prestashop.com/1.7/basics/installation/system-requirements/

Just a reminder that PS 1.7.7. will be out soon, no fix will be done on PS 1.7.6.5 (apart from security bugs).

I manage to reproduce your issue in PS 1.7.6.5 :
Capture d’écran 2020-07-02 à 15 12 45

And also in PS 1.7.7.0 :
Capture d’écran 2020-07-02 à 15 18 54

I will add the to our debug roadmap; please stay tuned !
Thanks!

florine2623 on 2 Jul 2020

👍1

Hi @florine2623. Thanks!

Just downgraded php to 7.2. Sadly the problem persists.

TVBZ on 2 Jul 2020

hi, my temporary solution is in product class do change the function :

public function addFeaturesCustomToDB($id_value, $lang, $cust)
   {

     if (trim($cust)=='') {

       $sql = 'SELECT f.`value`'
           .' FROM `'. _DB_PREFIX_.'feature_value_lang` f '
           .' WHERE f.id_feature_value = '.$id_value.' and id_lang<>'.$lang;
       $cust=  Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql);


     }

       $row = array('id_feature_value' => (int) $id_value, 'id_lang' => (int) $lang, 'value' => pSQL($cust));

       return Db::getInstance()->insert('feature_value_lang', $row);
   }