Webservice do not work after upgrading to 8.2

[pietpetoors]

I used the service of Prestashop to help me upgrade from 1.7.8.7 to 8.2 .
I use WebService to connect my accounting software to sync orders , stock and products with Prestashop.

Prestashop upgraded my site to 8.2 and also upgraded the server php to 8.1.30

WebService was working 100% for several years on the old setup.

After the upgrade everything was fine until the first sync between Accounting Software and Presta.
All our products' names, short and long descriptions were deleted.

All the data is still in the accounting software, Smart-It , but when I sync it does not write the data back to Prestashop and Webservice.

My server support tried hard to help but says everything is fine on their side.

For some reason it cannot write to Prestashop.
Anyone encountered this before?

Do you know what this is, was also one of the errors?

connect() to unix:/var/www/vhosts/system/4x4direct.co.za/php-fpm.sock failed (2: No such file or directory) while connecting to upstream, client

what is php-fpn.sock ?

These are some of the errors and do not worry I changed the key.

I've increased the max_children to 80.
In terms of server capabilities, GET, POST, PUT, PATCH, DELETE and HEAD are supported.

The 40 max_children was reached. There is also a PHP error seen in the PHP error log:

[27-Nov-2024 20:00:44] WARNING: [pool 4x4direct.co.za] server reached max_children setting (40), consider raising it
[27-Nov-2024 20:00:53] WARNING: [pool 4x4direct.co.za] child 29725 said into stderr: "PHP message: PHP Fatal error:  Uncaught Error: Call to undefined method Attribute::getAttributes() in /var/www/vhosts/4x4direct.co.za/httpdocs/override/classes/WebserviceSpecificManagementSi.php:198"
[27-Nov-2024 20:00:53] WARNING: [pool 4x4direct.co.za] child 29725 said into stderr: "Stack trace:"
[27-Nov-2024 20:00:53] WARNING: [pool 4x4direct.co.za] child 29725 said into stderr: "#0 /var/www/vhosts/4x4direct.co.za/httpdocs/classes/webservice/WebserviceRequest.php(622): WebserviceSpecificManagementSiCore->manage()"
[27-Nov-2024 20:00:53] WARNING: [pool 4x4direct.co.za] child 29725 said into stderr: "#1 /var/www/vhosts/4x4direct.co.za/httpdocs/webservice/dispatcher.php(98): WebserviceRequestCore->fetch()"
[27-Nov-2024 20:00:53] WARNING: [pool 4x4direct.co.za] child 29725 said into stderr: "#2 {main}"
[27-Nov-2024 20:00:53] WARNING: [pool 4x4direct.co.za] child 29725 said into stderr: "  thrown in /var/www/vhosts/4x4direct.co.za/httpdocs/override/classes/WebserviceSpecificManagementSi.php on line 198"

proxy_access_ssl_log:41.***.***.101 - EAE1AIMIZ46UGA6IT3H431PHKEGTEZJ1 [27/Nov/2024:17:41:58 +0200] "PUT /api/stock_availables/682 HTTP/1.1" 200 640 "-" "-"
proxy_access_ssl_log:41.***.***.101 - EAE1AIMIZ46UGA6IT3H431PHKEGTEZJ1 [27/Nov/2024:17:41:59 +0200] "PUT /api/stock_availables/232 HTTP/1.1" 200 640 "-" "-"
proxy_access_ssl_log:41.***.***.101 - EAE1AIMIZ46UGA6IT3H431PHKEGTEZJ1 [27/Nov/2024:17:41:59 +0200] "PUT /api/stock_availables/864 HTTP/1.1" 200 640 "-" "-"
proxy_access_ssl_log:41.***.***.101 - EAE1AIMIZ46UGA6IT3H431PHKEGTEZJ1 [27/Nov/2024:17:41:59 +0200] "PUT /api/stock_availables/1570 HTTP/1.1" 200 643 "-" "-"
proxy_access_ssl_log:41.***.***.101 - EAE1AIMIZ46UGA6IT3H431PHKEGTEZJ1 [27/Nov/2024:17:41:59 +0200] "PUT /api/stock_availables/1272 HTTP/1.1" 200 643 "-" "-"
proxy_access_ssl_log:41.***.***.101 - EAE1AIMIZ46UGA6IT3H431PHKEGTEZJ1 [27/Nov/2024:17:42:00 +0200] "PUT /api/stock_availables/1122 HTTP/1.1" 200 643 "-" "-"
proxy_access_ssl_log:41.***.***.101 - EAE1AIMIZ46UGA6IT3H431PHKEGTEZJ1 [27/Nov/2024:17:42:00 +0200] "PUT /api/stock_availables/1499 HTTP/1.1" 200 643 "-" "-"
proxy_access_ssl_log:41.***.***.101 - EAE1AIMIZ46UGA6IT3H431PHKEGTEZJ1 [27/Nov/2024:17:42:01 +0200] "PUT /api/stock_availables/1071 HTTP/1.1" 200 641 "-" "-"
proxy_access_ssl_log:41.***.***.101 - EAE1AIMIZ46UGA6IT3H431PHKEGTEZJ1 [27/Nov/2024:17:42:01 +0200] "PUT /api/stock_availables/1523 HTTP/1.1" 200 643 "-" "-"
proxy_access_ssl_log:41.***.***.101 - EAE1AIMIZ46UGA6IT3H431PHKEGTEZJ1 [27/Nov/2024:17:42:01 +0200] "PUT /api/stock_availables/279 HTTP/1.1" 200 640 "-" "-"

proxy_access_ssl_log:41.***.***.101 - R91TH6YKB6V2F8US4Q82SVMBY2FQGBEN [27/Nov/2024:14:08:48 +0200] "DELETE /api/categories/1069 HTTP/1.1" 404 238 "-" "-"
proxy_access_ssl_log:41.***.***.101 - R91TH6YKB6V2F8US4Q82SVMBY2FQGBEN [27/Nov/2024:14:08:48 +0200] "DELETE /api/categories/1070 HTTP/1.1" 200 5 "-" "-"
proxy_access_ssl_log:41.***.***.101 - R91TH6YKB6V2F8US4Q82SVMBY2FQGBEN [27/Nov/2024:14:08:48 +0200] "DELETE /api/categories/1111 HTTP/1.1" 200 5 "-" "-"
proxy_access_ssl_log:41.***.***.101 - R91TH6YKB6V2F8US4Q82SVMBY2FQGBEN [27/Nov/2024:14:08:49 +0200] "DELETE /api/categories/1181 HTTP/1.1" 404 238 "-" "-"
proxy_access_ssl_log:41.***.***.101 - R91TH6YKB6V2F8US4Q82SVMBY2FQGBEN [27/Nov/2024:14:08:49 +0200] "DELETE /api/categories/1182 HTTP/1.1" 404 238 "-" "-"

 

Edited November 27, 2024 by pietpetoors
typo (see edit history)

[Prestashop Addict]

Hi, you have an override class WebserviceSpecificManagementSi.php that call a method that doesn't exist. php-fpm is a process for php fastcgi

[pietpetoors]

Thank you, will relay this to the software developer.

Must cgi be enabled in webservices or not?

[Prestashop Addict]

  On 11/28/2024 at 10:03 AM, pietpetoors said:

Must cgi be enabled in webservices or not?

Expand  

This is a apache/php configuration, doesn't have effect

[pietpetoors]

We might have found the problem but now I must either somehow change something in the DB or the software guys must change the software. For interest sake:

Because during 8 years of using Prestashop I only had 1x upgrade which was successful , the rest were problems with sleepless nights.
So this time I decided to pay Prestashop to do the upgrade for me so things can go without problems 😃😅

In Short:
Quentin did upgrade and after everything was fine handed it to me.
Everywhere French text showed up, looked under Language and saw 2 Languages. 1. French, 2 English.
Because French was causing problems and I did not need it I deleted French.

Turns out the software use Language ID = 1 for English and this is why it worked the past 8 years.
Now Language ID=1 is deleted because it was allocated to French which I neither understood nor need.

Software looks for ID 1 to sync product name and descriptions and cannot find it.

I must either somehow  change English back to ID = 1 or they will have to change their software to allocate ID 2 to English.
Problem is many other sites use same software so if they change Language to ID 2 for me other sites wont work.

[pietpetoors]

I still have the old DB. Is there a table I can copy from the old DB to the new so that language ID 1 can be = English again?

[pietpetoors]

Some feedback:
The web site and Smarti-It is working now .

Lesson learned: When you migrate an installation even the unique ID of the language is important.