SagePay payment processor on CiviCRM 4.2.2

[edc1]

Hello,

when a user clicks the confirm contribution button this happens:

Fatal error: Uncaught exception 'Exception' with message 'A fatal error was triggered' in /home/admin/domains/d6.windmilers.org.uk/public_html/sites/all/modules/civicrm/CRM/Core/Error.php:262 Stack trace: #0 /home/admin/domains/d6.windmilers.org.uk/public_html/sites/all/civicrm_extensions/uk.co.circleinteractive.payment.sagepay/sagepay.php(398): CRM_Core_Error::fatal('The following e...') #1 /home/admin/domains/d6.windmilers.org.uk/public_html/sites/all/modules/civicrm/CRM/Member/BAO/Membership.php(1400): uk_co_circleinteractive_payment_sagepay->doTransferCheckout(Array, 'contribute') #2 /home/admin/domains/d6.windmilers.org.uk/public_html/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Confirm.php(896): CRM_Member_BAO_Membership->postProcessMembership(Array, '1', Object(CRM_Contribute_Form_Contribution_Confirm), Array, Array, Array) #3 /home/admin/domains/d6.windmilers.org.uk/public_html/sites/all/modules/civicrm/CRM/Core/Form.php(246): CRM_Contribute_Form_Contribution_Confirm->postProcess() #4 /home/admin/dom in /home/admin/domains/d6.windmilers.org.uk/public_html/sites/all/modules/civicrm/CRM/Core/Error.php on line 262

We're running CiviCRM 4.2.2 on Drupal 6 and using the SagePay payment processor extension. Any idea how to trouble shoot this. I'm really stuck.

Thanks.

Em.

[edc1]

And this in the Apache error log (which doesn't help much either):

[Tue Oct 02 22:12:50 2012] [error] [client 78.86.163.23] PHP Fatal error:  Uncaught <table border="1" cellspacing="0">\n<tr><td colspan="3" bgcolor="#ff9999"> <b>PEAR_Exception</b>: DB Error: constraint violation in <b>unknown</b> on line <b>unknown</b></td></tr>\n<tr><td colspan="3" bgcolor="#ff9999">- <b>DB_Error</b>: DB Error: constraint violation in <b>unknown</b> on line <b>unknown</b></td></tr>\n<tr><td colspan="3" bgcolor="#aaaaaa" align="center"><b>Exception trace</b></td></tr>\n<tr><td align="center" bgcolor="#cccccc" width="20"><b>#</b></td><td align="center" bgcolor="#cccccc"><b>Function</b></td><td align="center" bgcolor="#cccccc"><b>Location</b></td></tr>\n<tr><td align="center">0</td><td>CRM_Core_Error::exceptionHandler(Object(DB_Error))</td><td>unknown:unknown</td></tr>\n<tr><td align="center">1</td><td>call_user_func(Array, Object(DB_Error))</td><td>/var/www/html/sites/all/modules/civicrm/packages/PEAR.php:931</td></tr>\n<tr><td align="center">2</td><td>PEAR_Error->PEAR_Error('DB Error: constr&hellip;', -3, 16, Array, 'INSERT INTO civi&hellip;')</td><td>/var/www/html/sites/ in /var/www/html/sites/all/modules/civicrm/CRM/Core/Error.php on line 568, referer: http://78.86.163.23/civicrm/contribute/transact?_qf_Confirm_display=true&qfKey=ce162c8c2ab4cade63178f3d78f78c3a_3280

Any ideas? Anyone?

Em.

[edc1]

I've managed to get the actual error message that the SagePay code was generating:

The following errors occurred when submitting payment to Sage Pay:<br />Missing address field(s).<br /><br />Please contact the site administrator.

So quite easy to fix once you have this information! I don't know why it causes PHP to crash if the address field isn't there?

Em.

[edc1]

PHP fatal errors also occur under these circumstances:

The following errors occurred when submitting payment to Sage Pay:<br />3078 : The CustomerEMail format is invalid.<br />Please contact the site administrator.
The following errors occurred when submitting payment to Sage Pay:<br />4000 : The VendorName is invalid or the account is not active.<br />Please contact the site administrator.
The following errors occurred when submitting payment to Sage Pay:<br />Missing address field(s).<br /><br />Please contact the site administrator.
The following errors occurred when submitting payment to Sage Pay:<br />The CustomerEmail supplied is Invalid.<br />Please contact the site administrator.

Em.

[andyw]

NB: reposted in Issues for the Sagepay Payment Extension