Edit History

Hi 4you.software, 

Thank you for your reply.

So, first, the context :

• Prestashop 1.7.8.2
• On a dedicated VPS with Ubuntu 18.04.5 LTS behind Cloudflare
• Server Management Gui : Plesk Obsidian 18.0.39
• Serverr BDD : Localhost via UNIX socket
• Type of server : MariaDB
• Version : 10.1.48-MariaDB-0ubuntu0.18.04.1 - Ubuntu 18.04
• Jeu de caractères du serveur : UTF-8 Unicode (utf8mb4)
• Server Web nginx/1.20.1
• Version du client de base de données : libmysql - mysqlnd 7.4.24
• Extension PHP : mysqli  curl  mbstring 
• PHP 7.4.24 or 7.3.33 (tried both) FPM served by Apache
• phpMyAdmin Version : 5.1.1
• Browser setup: Chrome or Firefox
• Operating system Windows 11

Now what I do to reproduce the bug :

1. go to dashboard -> Catalog -> Products
2. Click on any of the existing product
3. Go to "Combination" tab and try to change the quantity in any of the combination 
4. save and go back to catalog -> it shows the message "setting updated" but in fact the quantity is not updated.

One error message in the browser inspector (chrome) : 

Uncaught ReferenceError: rightSidebar is not defined
    at HTMLDocument.<anonymous> (form.js,q1.7.8.2.pagespeed.ce._edDeo8c7i.js:44)
    at o (prestashop-ui-kit.js:1)
    at d (prestashop-ui-kit.js:1)

No error message in debug mode (just some warnings about translations missing and some deprecations).

I noticed in the database that some of the recent tables (upgraded ->1.7.8.x I'd guess) are encoded in utf8mb4 when the older still remain in utf8.

Other bugs maybe related :

• the ajax button of "add brand" or "add a related product"in the product basic settings tab don't load content.
• When peolple order through Paypal, Paypal receives the payment but after that, prestashop puts the order in "payment error" (I also opened a ticket abouth this)

I also join as attached file the apache error log.

I tried the Hint provided by ComGrafPL but the column "location" already exists in the table prefix_stock_available.

Hi 4you.software, 

Thank you for your reply.

So, first, the context :

• Prestashop 1.7.8.2
• On a dedicated VPS with Ubuntu 18.04.5 LTS behind Cloudflare
• Server Management Gui : Plesk Obsidian 18.0.39
• Serverr BDD : Localhost via UNIX socket
• Type of server : MariaDB
• Version : 10.1.48-MariaDB-0ubuntu0.18.04.1 - Ubuntu 18.04
• Jeu de caractères du serveur : UTF-8 Unicode (utf8mb4)
• Server Web nginx/1.20.1
• Version du client de base de données : libmysql - mysqlnd 7.4.24
• Extension PHP : mysqli  curl  mbstring 
• PHP 7.4.24 or 7.3.33 (tried both) FPM served by Apache
• phpMyAdmin Version : 5.1.1
• Browser setup: Chrome or Firefox
• Operating system Windows 11

Now what I do to reproduce the bug :

1. go to dashboard -> Catalog -> Products
2. Click on any of the existing product
3. Go to "Combination" tab and try to change the quantity in any of the combination 
4. save and go back to catalog -> it shows the message "setting updated" but in fact the quantity is not updated.

One error message in the browser inspector (chrome) : 

Uncaught ReferenceError: rightSidebar is not defined
    at HTMLDocument.<anonymous> (form.js,q1.7.8.2.pagespeed.ce._edDeo8c7i.js:44)
    at o (prestashop-ui-kit.js:1)
    at d (prestashop-ui-kit.js:1)

No error message in debug mode (just some warnings about translations missing and some deprecations).

I noticed in the database that some of the recent tables (upgraded ->1.7.8.x I'd guess) are encoded in utf8mb4 when the older still remain in utf8.

Other bugs maybe related :

• the ajax button of "add brand" or "add a related product"in the product basic settings tab don't load content.
• When peolple order through Paypal, Paypal receives the payment but after that, prestashop puts the order in "payment error" (I also opened a ticket abouth this)

I also join as attached file the apache error log.

I tried the Hint provided by ComGrafPL but the column "location" already exists in the table prefix_stock_available.

_06087940_error_log(1).7fc9d38214b9f80e4ef6f402d5038f20