Issues for the Sagepay Payment Extension

[andyw]

This problem is being looked into here:

http://issues.civicrm.org/jira/browse/CRM-11240

Will let you know when there's any update.

Andy

[andyw]

Bill, this should be fixed.

Many thanks,

Andy

[wmason]

Andy -- thanks, seemed to install just fine.

Generic -- thanks for the workarounds.

Bill M.

[gibsonoliver]

Hi

I'm doing some work for an organisation who have been using the sagepay extension (CiviCRM 4.3.3/Drupal 7) for a while. Sometimes the contribution is not completing and this only seems to be for certain users. I haven't been able to identify what the issue as I can't replicate the problem. I've been through previous forum posts and added the standard fixes but the problem is still there. The whole process is;
Complete form on CiviCRM - works fine
Taken to sagepay and asked to choose a payment method
Adding card details works fine and sagepay transaction reference generated
When they try and pay Sagepay then generates an error and reports to CiviCRM that the payment has failed /provides transaction reference to CiviCRM

On screen error details are;
HTTP Status Code: 500
HTTP Status Message: The request was unsuccessful due to an unexpected condition
encountered by the server.
Error Code : 5006
Error Description : Unable to redirect to Vendor's web site. The Vendor failed to provide a RedirectionURL.

Do you have any ideas as to what might be causing this?
Any help appreciated

Oliver

[andyw]

Hi Oliver,

The error is basically telling you Civi has fallen over with an HTTP 500 error before the Sagepay extension had a chance to send the correct response. It might be something in the extension causing it, but on past experience, I will stick my neck out and say it's probably something in the part of the Civi codebase that completes transactions causing it.

If you're able to check your web server logs or the Civi ConfigAndLog log at the time this happened, these might give you a bit more detail on the error - or if you can't dig up the entries, next time it happens, maybe check those.

Like you say, it's pretty difficult to know what the problem might be if you can't reproduce it, and with just that error to go on - but your first port of call is to check these logs I think, and if you can get any more information on what might be causing it, we'll be more than happy to try and help you debug this.

All the best!

Andy

[gibsonoliver]

Thanks Andy

The log error (below) seems to be related to the membership status. On investigation the 'new' member status wasn't active in the system.
I'll enable this and see if that changes anything - thanks for your help, Olly

Jun 01 11:07:37  [info] $Fatal Error Details = Array
(
    [message] => Oops, it looks like there is no valid membership status corresponding to the membership start and end dates for this membership. Contact the site administrator for assistance.
   

Code: [Select]

=>
)


Jun 01 11:07:37  [info] $backTrace = #0 /home/example/www/members/sites/all/modules/civicrm/CRM/Core/Error.php(315): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/example/www/members/sites/all/modules/civicrm/CRM/Member/BAO/Membership.php(1795): CRM_Core_Error::fatal("Oops, it looks like there is no valid membership status corresponding to the ...")
#2 /home/example/www/members/sites/all/modules/civicrm/CRM/Core/Payment/BaseIPN.php(329): CRM_Member_BAO_Membership::fixMembershipStatusBeforeRenew((Array:15), "20130601110737")
#3 /home/example/www/members/sites/default/extensions/uk.co.circleinteractive.payment.sagepay/ipn.php(455): CRM_Core_Payment_BaseIPN->completeTransaction((Array:22), (Array:10), (Array:8), Object(CRM_Core_Transaction), FALSE)
#4 /home/example/www/members/sites/default/extensions/uk.co.circleinteractive.payment.sagepay/ipn.php(132): uk_co_circleinteractive_payment_sagepay_notify->single((Array:22), (Array:10), (Array:8), FALSE, FALSE)
#5 /home/example/www/members/sites/default/extensions/uk.co.circleinteractive.payment.sagepay/sagepay.php(614): uk_co_circleinteractive_payment_sagepay_notify->main("contribute")
#6 /home/example/www/members/sites/all/modules/civicrm/CRM/Core/Payment.php(281): uk_co_circleinteractive_payment_sagepay->handlePaymentNotification()
#7 /home/example/www/members/sites/all/modules/civicrm/CRM/Core/Payment.php(202): CRM_Core_Payment::handlePaymentMethod("PaymentNotification", (Array:2))
#8 [internal function](): CRM_Core_Payment::handleIPN((Array:3))
#9 /home/example/www/members/sites/all/modules/civicrm/CRM/Core/Invoke.php(258): call_user_func((Array:2), (Array:3))
#10 /home/example/www/members/sites/all/modules/civicrm/CRM/Core/Invoke.php(70): CRM_Core_Invoke::runItem((Array:13))
#11 /home/example/www/members/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#12 /home/example/www/members/sites/all/modules/civicrm/drupal/civicrm.module(436): CRM_Core_Invoke::invoke((Array:3))
#13 [internal function](): civicrm_invoke("payment", "ipn")
#14 /home/example/www/members/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:2))
#15 /home/example/www/members/index.php(21): menu_execute_active_handler()
#16 {main}

[andyw]

No problem Olly, thanks for the update. I should think that will solve it, but keep us posted on how you get on.

Andy

[Generic]

Has anyone got this working in 4.4.x?

I am getting a failed return URL error from SagePay

Joomla 2.5.x

[Generic]

The latest version (2.2) is not creating a Joomla notifyURL

I've replaced

Code: [Select]

        // Construct notification url
        $notifyURL = $config->userFrameworkBaseURL . 'civicrm/payment/ipn?';
foreach ($notifyParams as $key => $value)
    $notifyURL .= $key . '=' . urlencode($value) . '&';
$notifyURL = substr($notifyURL, 0, -1);
With

Code: [Select]

        // Construct notification url
        $querystring = '';
foreach ($notifyParams as $key => $value)
$querystring .= $key . '=' . urlencode($value) . '&';
$notifyURL = CRM_Utils_System::url('civicrm/payment/ipn', $querystring, TRUE, NULL, FALSE, TRUE, FALSE);
$notifyURL = substr($notifyURL, 0, -1);
This now produces the following notifyURL for Joomla which is the same as in previous working versions.

Code: [Select]

https://www.mywebsite.com/index.php?option=com_civicrm&task=civicrm/payment/ipn&Itemid=200&processor_name=Sagepay&cid=5&conid=1938&mo=contribute&v=mysagevendor&qf=1297cd7dcac1dc1d8434f01b357fcbab_8678&mid=790&rcid=24
However I still get SagePay return URL failed, this also happens if the transaction is cancelled.

[Generic]

FAO Andyw

Work in progress files attached.

[andyw]

Hi Generic,

Thanks for that - and apologies for not being around last week.

I've just been having a look at this this morning - when it calls the notification url, I'm currently getting the error:

The requested Profile (gid=12) is disabled OR it is not configured to be used for 'Profile' listings in its Settings OR there is no Profile with that ID OR you do not have permission to access this profile.

Not sure if that's some unrelated problem specific to me, or if it's related - but I'll try and work through it, have a look at these files you've attached and get everything fixed up and working on 4.4.

Hope that's ok - and thanks very much for your help with this!

Andy

[Generic]

Are you seeing the CiviCRM fatal error page or is this error in ConfigAndLog?

[andyw]

It's coming up in the ConfigAndLog log - looks like the core code that gets triggered by CRM_Core_Payment_BaseIPN::completeTransaction() is having trouble updating the 'Your Registration Info' profile - could be a permissions issue, as the ipn call is considered to be an anonymous user rather than the user you're logged in as - but it looks like I'll have to dig a bit deeper and find out the reason - have tried adjusting profile related permissions for anonymous users, but still no joy at the moment.

Like I say, I'm not sure if that's the problem you're having too, or whether that's just some other random error the universe has decided to inflict on me today, but I'll try to get to the bottom of that one first, and see what happens then.

Cheers,

Andy

[andyw]

Hi Generic,

Can you try giving anonymous users 'profile listings and forms' permission in your access controls? Doing that seems to have sorted out the problems at my end, although I am admittedly testing this on Drupal at the moment.

I'm thinking the best way to deal with that would be to submit a patch to core to disable the permissions check when receiving an ipn callback rather than recommending everyone grant profile listings and forms permissions to anonymous users, but I'm just wondering if that's the problem you're having too, or if you've got another one - if so, I'll set up a Joomla and have another look.

Cheers,

Andy

[Donald Lobo]

rather than giving the generic permission, might want to just give "access profile create"

its a lot more restrictive permission

lobo