Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.3.1
-
Fix Version/s: 4.3.2
-
Component/s: CiviContribute
-
Labels:None
Description
The file civicrm/extern/pxIPN.php (part of the Payment Express Payment processing module) has an SQL statement that is incompatible with the database schema for the civicrm_payment_processor and civicrm_payment_processor_type tables.
The offending lines are:
/*
- Get the password from the Payment Processor's table based on the DPS user id
- being passed back from the server
*/
$query = "
SELECT url_site, password, user_name, signature
FROM civicrm_payment_processor
WHERE payment_processor_type = 'Payment_Express'
AND user_name = %1
";
I will upload a patch to fix this shortly