[solved] Cannot change the quantities of a product in the backoffice

[mastobuuth]

In a product page, I can no longer change the quantity of a product. Indeed, when I click on "save", it tells me that the product has been updated, but then, when I return to the catalog page, I see that the change in quantity has not been taken into account and remains unchanged.

prestashop 1.7.8.1

Edited December 29, 2021 by mastobuuth (see edit history)

[ComGrafPL]

PHP version?

Was your prestashop version was updated or its new shop?

[mastobuuth]

Hi, thx for the reply.

So I have the 7.4.27 version of PHP.

It is an updated shop (since 2013) but I never encountered such problem in the past.

[ComGrafPL]

Does it happen on new products or also updating old one?

That should give you a hint how to solve it.

https://github.com/PrestaShop/PrestaShop/issues/12075

and

https://stackoverflow.com/questions/33737513/cant-update-stock-quantity-in-prestashop-bo

Edited December 28, 2021 by ComGrafPL (see edit history)

[mastobuuth]

It's on all products (old and news).

 

Edited December 29, 2021 by mastobuuth (see edit history)

[mastobuuth]

Hi everyone, sorry to bother but would there be someone to help me ?

[ps8modules]

https://build.prestashop.com/howtos/misc/how-to-create-bug-report/

[mastobuuth]

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.

 

 

 

Edited December 29, 2021 by mastobuuth (see edit history)

[ps8modules]

Thank you.
From which version of Prestashop was please updated?
This really looks like some module error or override.

[mastobuuth]

I updated many Times since 2013. I disabled every override and non native modules, I even tried to use the classic thème, with no success.

[ps8modules]

It doesn't matter that you upgraded in 2013 before.
Now have you upgraded to 1.7.8.1?
Modules compatible with the old version of Prestashop, the override for the old version of Prestashop may not work properly for the new version of Prestashop and the PHP version.
It would be good to turn off the pagespeed module and clear the cache.
I haven't read anywhere if the e-shop was linked to StoreManger?
Furthermore, I did not read anywhere since the problem appeared, what module was installed, what modification was performed, etc ...

Unfortunately, the problem cannot be identified in this way.

[mastobuuth]

Hi, thank you for your kind advices.

So I upgraded slowly from version 1.3 to 1.7.8.2, year after year, version after version. In the beginning , through manual upgrade and , since it's available, with 1-click upgrade module. 

But, you should believe in yourself, coz you deserve respect :  I turned off the pagespeed module for http and https, and it worked as a charm.

Here is the code for Apache directives :

<IfModule pagespeed_module>
    ModPagespeed off
</IfModule>

 

Hope it will help some other people.