Page 1 of 2

Phoca Cart does not change order status to Completed after Paypal payment

Posted: 26 May 2020, 11:33
by metestaki
Hello,

I have a problem with Phoca Cart.
I use Joomla 3.9.18 and Phoca cart 3.5.2.

After a payment via Paypal, the order status remains pending.
So, the user sees the download link but it is empty, showing "There are no files to download".

I have read these
https://www.phoca.cz/documents/116-phoc ... l-standard
and the last paragraph "Changing Of Order Status"
but I cannot mak it work properly.

The settings are:
Product:
Download Options - Download file - it is selected

Payment:
Paypal Standard - Payment Method Options - Completed Status - Completed

Order Statuses:
Completed - Download - Yes
Pending - Download - No

I want the user be able to download the files only after the Paypal Payment.
(If I change Pending - Download - Yes, he will be able to download files even if he hasn;t completed the payment.)


Any ideas?

Re: Phoca Cart does not change order status to Completed after Paypal payment

Posted: 27 May 2020, 21:28
by Jan
Hi, yes, the download can be displayed when status changes so there seems to be a problem with status changing than with download itself.

Please, enable logging and try to test PayPal (e.g. the sandbox method) with or without certificate and checkt eh logs - there should be information that the payment was done on your server and then PayPal should send a message to your server. So when there is a PayPal payment, then at least there must be two items in log.

Jan

Re: Phoca Cart does not change order status to Completed after Paypal payment

Posted: 28 May 2020, 11:17
by metestaki
I'm afraid I cannot view the logs.

Can I check any other setting to make it work?

Re: Phoca Cart does not change order status to Completed after Paypal payment

Posted: 28 May 2020, 14:38
by Jan
Hi, what do you mean wiht "I'm afraid I cannot view the logs."?

You have no access to logs?

Jan

Re: Phoca Cart does not change order status to Completed after Paypal payment

Posted: 29 May 2020, 09:14
by metestaki
I enabled debugging at jooomla and there is some info at the bottom of each page. At which stage of the order and at which section exactly I have to search for these log lines from Paypal?

Re: Phoca Cart does not change order status to Completed after Paypal payment

Posted: 30 May 2020, 09:48
by Benno
Hi,
I enabled debugging at jooomla
I think Jan meant the Phoca Cart Logging that can be activated in the Options. See image:
Image
The Logs you find here:
Backend --> Components --> Phoca Cart --> System Log

Kind regards,
Benno

Re: Phoca Cart does not change order status to Completed after Paypal payment

Posted: 30 May 2020, 10:37
by metestaki
Many thanks, Benno!

I found the logs, now.

I get 3 lines:

2020-05-30 08:43:54 Notice Payment - PayPal Standard - ERROR ---.---.---.--- https://www.---/index.php?option=com_phocacart&view=response&task=response.paymentnotify&type=paypal_standard&pid=1&tmpl=component
cURL error: [60] SSL certificate problem: unable to get local issuer certificate, User: Anonymous
2
2020-05-30 08:43:54 Notice Payment - PayPal Standard - ERROR (Listener Error) ---.---.---.--- https://---/index.php?option=com_phocacart&view=response&task=response.paymentnotify&type=paypal_standard&pid=1&tmpl=component
cURL error: [60] SSL certificate problem: unable to get local issuer certificate, User: Anonymous
3
2020-05-30 08:43:19 Notice Payment - PayPal Standard - SENDING FORM TO PAYPAL order2 ---.---.---.--- https://www.---/my-cart/payment
cURL error: [60] SSL certificate problem: unable to get local issuer certificate, User: Anonymous


This seems to be related with SSL.

However, the payment is done, but the order status does not change and I have no download links.

Any ideas, please?

Re: Phoca Cart does not change order status to Completed after Paypal payment

Posted: 31 May 2020, 11:25
by metestaki
I reinstalled my SSL certificate, but no success. The error appears again.

Re: Phoca Cart does not change order status to Completed after Paypal payment

Posted: 31 May 2020, 20:31
by Jan
Hi, yes, unfortunately PayPal has issues with the certificates, what happens when you disable the certificate? Do you get the same problem?

Re: Phoca Cart does not change order status to Completed after Paypal payment

Posted: 01 Jun 2020, 14:03
by metestaki
I wish to keep my SSL.

I saw this post
viewtopic.php?t=61062

and finally resolved this issue.

In the Paypal Payment Method Options, I set the verification of Verify SSL Certificate to "No".

Now the order status turns automatically to "Completed".

Thank you, all!