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

Phoca Cart - complex e-commerce extension
metestaki
Phoca Member
Phoca Member
Posts: 16
Joined: 30 Jul 2019, 11:45

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

Post by metestaki » 26 May 2020, 11:33

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?

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 42650
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

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

Post by Jan » 27 May 2020, 21:28

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
If you find Phoca extensions useful, please support the project

metestaki
Phoca Member
Phoca Member
Posts: 16
Joined: 30 Jul 2019, 11:45

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

Post by metestaki » 28 May 2020, 11:17

I'm afraid I cannot view the logs.

Can I check any other setting to make it work?

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 42650
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

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

Post by Jan » 28 May 2020, 14:38

Hi, what do you mean wiht "I'm afraid I cannot view the logs."?

You have no access to logs?

Jan
If you find Phoca extensions useful, please support the project

metestaki
Phoca Member
Phoca Member
Posts: 16
Joined: 30 Jul 2019, 11:45

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

Post by metestaki » 29 May 2020, 09:14

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?

User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 7452
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

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

Post by Benno » 30 May 2020, 09:48

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

metestaki
Phoca Member
Phoca Member
Posts: 16
Joined: 30 Jul 2019, 11:45

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

Post by metestaki » 30 May 2020, 10:37

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?

metestaki
Phoca Member
Phoca Member
Posts: 16
Joined: 30 Jul 2019, 11:45

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

Post by metestaki » 31 May 2020, 11:25

I reinstalled my SSL certificate, but no success. The error appears again.

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 42650
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

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

Post by Jan » 31 May 2020, 20:31

Hi, yes, unfortunately PayPal has issues with the certificates, what happens when you disable the certificate? Do you get the same problem?
If you find Phoca extensions useful, please support the project

metestaki
Phoca Member
Phoca Member
Posts: 16
Joined: 30 Jul 2019, 11:45

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

Post by metestaki » 01 Jun 2020, 14:03

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!

Post Reply