Webservice from 1.6.0.14 to 1.6.1.1

[ColonelMoutarde]

Since my migration to  1.6.1.1 the webservice dosent work, he said :

This call to PrestaShop Web Services failed and returned an HTTP status of 500

As you a solution ?

[Miguel Carvalho]

I have the same problem, webservice integration integration was working fine and now is showing this error:

 

This call to PrestaShop Web Services failed and returned an HTTP status of 500. That means: Internal Server Error.

 

Any ideas??

[bellini13]

have you tried to enable debug mode, maybe an error or exception will be returned.  You can also try to review your PHP error log or webserver error log to see if there is something going on in there.

[prestalearn]

I have noticed that the webservice for Prestashop 1.6.1.1 requires an updated library (on receiver side) to work.

When the partner I use that connects to me through webservice updated their php library it worked fine after that.

So I guess its just that the update of prestashop needs updated libraries on client side.

[Miguel Carvalho]

Hi,

 

Thank you for the reply. I updated the "PSWebServiceLibrary.php" after the upgrade as required;

 

A few minutes ago I check the log_error in the webservice directory and found a lot of "PHP Fatal error:  Maximum execution time of 120 seconds exceeded in /home/.../classes/db/Db.php on line 632" . Changed to 600 in PHP.INI and the error disappear.

 

Now I have a new problem, to update a product price I take more than two minutes 

 

Best regards,

Miguel Carvalho

[Miguel Carvalho]

New update.

 

My problem seems related with advanced search module, every time I try to update a product with webservices i can see more than 700 updates to my DB equal to the following: these:

 

 UPDATE `ps_pm_advancedsearch_product_price_1` app\r\n JOIN (SELECT `id_cache_product`, `id_shop`, `id_group`\r\n FROM `ps_pm_advancedsearch_product_price_1`\r\n GROUP BY `id_cache_product`, `id_shop`, `id_group`\r\n HAVING SUM(`is_specific`)=0) as app2\r\n ON (app.`id_cache_product`=app2.`id_cache_product` AND app.`id_shop`=app2.`id_shop` AND app.`id_group`=app2.`id_group`)\r\n SET app.`has_no_specific`=1', 203927

 

Best Regards,

Miguel Carvalho

[bellini13]

did you try to disable the module?

[Miguel Carvalho]

Hi,

 

Yes I tried with the module disabled and it is a subsecond operation.

 

Best Regards,

Miguel Carvalho

[bellini13]

So it sounds like you need to review this module in more depth to understand why it would update it's database table when you update a product.  You'll need to decide if that is important functionality or not.