• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Cancel from Paypal page still creates entry

Cancel from Paypal page still creates entry 11 years 5 months ago #25553

I would like to have the pending entry not posted if the user cancels or returns from the PayPal page. How do I do that? How do I set up the form to only send the user/admin/additional emails when the payment is confirmed by PayPal?
Last Edit: 11 years 5 months ago by teri.pratt. Reason: added question
The administrator has disabled public write access.

Cancel from Paypal page still creates entry 11 years 3 weeks ago #27162

  • dryfive
  • dryfive's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
Any update on this? I'm having the same problem.

Thanks in advance to anyone who can help!
The administrator has disabled public write access.

Cancel from Paypal page still creates entry 11 years 3 weeks ago #27167

  • adrianp
  • adrianp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 631
  • Thank you received: 146
Hello,

When publishing the submitted information via RSForm!Pro menu items, you can choose to only display the confirmed subscriptions(this would be done from the menu item configuration).

As for the emails, these can indeed be deferred until the payment is confirmed by the PayPal gateway. Simply enable this feature as explained here:

www.rsjoomla.com/support/documentation/v...-payment-plugin.html
This is not official customer support. To receive your support, submit a support ticket here.
The administrator has disabled public write access.

Cancel from Paypal page still creates entry 9 years 9 months ago #31763

  • dieter5
  • dieter5's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 9
The deferred emails do not solve the particular problem. I have the same issue. If a user has any problem @ the PayPal payment page or cancels the transaction, the submission entry is still created.

There must be a way to ensure that the entry is created only if the PayPal is successfully!

Cheers
The administrator has disabled public write access.

Cancel from Paypal page still creates entry 9 years 9 months ago #31767

  • adrianp
  • adrianp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 631
  • Thank you received: 146
Hello,

It's actually normal to save transaction details when the subscription takes place. This is needed in order to associate information about the transaction when the payment gateway response is sent. Thus, initial subscription will have a pending PayPal status, while based on the payment gateway answer, the status changes.
This is not official customer support. To receive your support, submit a support ticket here.
The administrator has disabled public write access.

Cancel from Paypal page still creates entry 9 years 9 months ago #31768

  • dieter5
  • dieter5's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 9
I theory thi should be the case, however when pressing submit and being redirected to paypal and then the transaction is faulty or camcelled, the submission is stil created.
On my module with submissions posted on frontoage, i have the option selected for it to display only confirmed transactions, but i get a the duplicates displayed also.

What can be done to avoid tnis? Us there a script that can be added to diplay only thosentries in the module that have Paypal payment as "confirmed"

Please advise
The administrator has disabled public write access.

Cancel from Paypal page still creates entry 9 years 9 months ago #31941

  • adrianp
  • adrianp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 631
  • Thank you received: 146
Hello,

"Duplicates" are displayed as the user submits the form once again, and while you're enabling the "show only confirmed submissions" option, this refers to the submission itself and not the transaction.

You can try similar steps:

- enable the submission confirmation feature in your form (without actually sending/using the confirmation link).

- leave "show only confirmed submissions" option from your module configuration enabled.

- perform a template override for the module.

The file in question would be located under this path:

\modules\mod_rsform_list\tmpl\default.php

- within the duplicate file used for template overrides, add a script that will check submitted data and adjusts the "confirmed" column from the "#__rsform_submissions" table to one 1 accordingly (1 means confirmed):
$flag = 0;
$db = JFactory::getDBO();
$db->setQuery("SELECT `SubmissionId`,`FieldValue` FROM #__rsform_submission_values WHERE `FormId`=3 AND `FieldName`='_STATUS'");
$info = $db->loadObjectList();
    foreach($info as $inf){
        if($inf->FieldValue == 1){
            $db->setQuery("UPDATE #__rsform_submissions SET `confirmed`='1' WHERE `SubmissionId`='".$inf->SubmissionId."'");
            $db->execute();
        }
        if($db->getAffectedRows() > 0){
            $flag = 1;
        }
    }
if($flag == 1){
    header("Refresh:0");
}

You'll have to replace from the script, the number, with your form ID:

`FormId`=3

If everything is done properly, the module will only include the PayPal confirmed submissions.
This is not official customer support. To receive your support, submit a support ticket here.
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!