CiviCRM Community Forums (archive)

Greetings,

In testing on a brand new clean install of CiviCRM, we just discovered something inconsistent, but that actually works. (Installed 4.4.3, updated to 4.4.4 prior to testing.)

For our site, the main use of CiviCRM we need combine:
1) CiviMembership - as it is a website with paid membership component
2) CiviContribution - to collect the funds
3) CiviProfile - to gather contact information

A fourth aspect which we have disabled presently is to have the CiviProfile create a Drupal account, however for testing purposes we do not wish to fabricate countless test Drupal accounts.

So, we had this scenario configured, and specifically the CiviContribution "Financial Type" was set to "Member Dues". Transactions against the PayJunction test gateway were getting stuck in processing state and would never complete.

We went back in as straight up CiviContribution Donation transactions process through to completion... so we set the "Financial Type" of the site membership join page to "Donation" and test transactions process through to completion.

Further, on the Contribution Dashboard, in the "Type" column, we see transactions which now complete properly show up as "Member Dues".

Questions:

1) What within CiviCRM is different between a "Financial Type" --> "Member Dues" verses "Donation" that would cause CiviCRM to drop the response coming back from PayJunction?

2) Where is the disconnect that now that we have reconfigured the CiviContribute page for site memberships to "Financial Type" --> "Donation" do the transactions show up as "Member Dues" on the Contribution Dashboard?

Still trying to track down why PayJunction transactions do not complete on our server, however do on the CiviCRM Drupal demo site.

Today I thought to track down where in the CiviCRM code wraps the module (packages/PayJunction/pjClasses.php) I added logging to a while ago. Seems it is wrapped by yet another PayJunction specific file: CRM/Core/Payment/PayJunction.php

I added more logging, then ran a live transaction to the PayJunction test gateway, same as I tested successfully on the CiviCRM Drupal demo site.

Modifications to packages/PayJunction/pjClasses.php as follows:
    // create a pjpgRequest object passing the transaction object
    $pjpgRequest = new pjpgRequest($pjpgTxn);
//error_log("PayJunction.php doDirectPayment new pjpgRequest, pjpgRequest = >" . $pjpgRequest . "<");

    $pjpgHttpPost = new pjpgHttpsPost($pjpgRequest);
//error_log("PayJunction.php doDirectPayment new pjpgHttpsPost, pjpgHttpPost = >" . $pjpgHttpPost . "<");

    // get an pjpgResponse object
    $pjpgResponse = $pjpgHttpPost->getPJpgResponse();
error_log("PayJunction.php doDirectPayment pjpgHttpPost->getPJpgResponse, pjpgResponse = >" . $pjpgResponse . "<");

    if (self::isError($pjpgResponse)) {
error_log("PayJunction.php doDirectPayment isError of pjpgResponse was true");
      return self::error($pjpgResponse);
    }

    /* Check for application errors */

    $result = self::checkResult($pjpgResponse);
    if (is_a($result, 'CRM_Core_Error')) {
error_log("PayJunction.php doDirectPayment application error was true, result = >" . $result . "<");
      return $result;
    }

    // Success
    $params['trxn_result_code'] = $pjpgResponse['dc_response_code'];
    $params['trxn_id'] = $pjpgResponse['dc_transaction_id'];
    $params['gross_amount'] = $params['amount'];
error_log("PayJunction.php doDirectPayment Success");

    return $params;
  }
  // end function doDirectPayment


  /*
   * This function checks the PayJunction response code
   */
  function isError(&$response) {
    $responseCode = $response['dc_response_code'];

    if ($responseCode == "00" || $responseCode == "85") {
error_log("PayJunction.php isError FALSE");
      return FALSE;
    }
    else {
error_log("PayJunction.php isError TRUE");
      return TRUE;
    }
  }


  // ignore for now, more elaborate error handling later.
  function &checkResult(&$response) {
error_log("PayJunction.php checkResult");
    return $response;
  }

It appears that PayJunction accepted the charge and processed smoothly. Why is CiviCRM not understanding that, leaving transactions in "pending" state after a several second delay/pause?

Output from my test transaction is as follows:

[Fri Mar 21 15:48:20 2014] [error] [client *.*.*.*] pjClasses.php url = >https://www.payjunctionlabs.com/quick_link<, referer: http://d1.orgname.org/civicrm/contribute/transact?_qf_Confirm_display=true&qfKey=954595d80a4a5028e993eb40851a220f_3328
[Fri Mar 21 15:48:20 2014] [error] [client *.*.*.*] pjClasses.php request = >dc_logon=pj-ql-01&dc_password=pj-ql-01p&dc_first_name=Michael&dc_last_name=Lueck&dc_expiration_month=02&dc_expiration_year=2023&dc_number=4444333322221111&dc_verification_number=000&dc_transaction_amount=15.00&dc_transaction_type=AUTHORIZATION_CAPTURE&dc_version=1.2&dc_address=123+Any+Road&dc_city=Any+Town&dc_state=AL&dc_zipcode=12345&dc_country=US&dc_schedule_create=true&dc_schedule_limit=999&dc_schedule_periodic_number=1&dc_schedule_periodic_type=month&dc_schedule_start=2014-03-21&<, referer: http://d1.orgname.org/civicrm/contribute/transact?_qf_Confirm_display=true&qfKey=954595d80a4a5028e993eb40851a220f_3328
[Fri Mar 21 15:48:22 2014] [error] [client *.*.*.*] pjClasses.php Curl error = ><, referer: http://d1.orgname.org/civicrm/contribute/transact?_qf_Confirm_display=true&qfKey=954595d80a4a5028e993eb40851a220f_3328
[Fri Mar 21 15:48:23 2014] [error] [client *.*.*.*] pjClasses.php content = >dc_merchant_name=PayJunction Demo\x1cdc_merchant_address=1903 State Street\x1cdc_merchant_city=Santa Barbara\x1cdc_merchant_state=CA\x1cdc_merchant_zip=93101\x1cdc_merchant_phone=800-601-0230\x1cdc_device_id=313\x1cdc_transaction_date=2014-03-21 12:48:13\x1cdc_transaction_action=charge\x1cdc_approval_code=PJ20AP\x1cdc_response_code=00\x1cdc_response_message=APPROVAL PJ20AP\x1cdc_transaction_id=45028\x1cdc_posture=void\x1cdc_invoice_number=\x1cdc_notes=\x1cdc_card_name=Michael Lueck\x1cdc_card_brand=VSA\x1cdc_card_exp=XX/XX\x1cdc_card_number=XXXX-XXXX-XXXX-1111\x1cdc_card_address=123 Any Road\x1cdc_card_city=Any Town\x1cdc_card_zipcode=12345\x1cdc_card_state=AL\x1cdc_card_country=US\x1cdc_base_amount=15.00\x1cdc_tax_amount=0.00\x1cdc_capture_amount=15.00\x1cdc_cashback_amount=0.00\x1cdc_shipping_amount=0.00<, referer: http://d1.orgname.org/civicrm/contribute/transact?_qf_Confirm_display=true&qfKey=954595d80a4a5028e993eb40851a220f_3328
[Fri Mar 21 15:48:23 2014] [error] [client *.*.*.*] PayJunction.php doDirectPayment pjpgHttpPost->getPJpgResponse, pjpgResponse = >Array<, referer: http://d1.orgname.org/civicrm/contribute/transact?_qf_Confirm_display=true&qfKey=954595d80a4a5028e993eb40851a220f_3328
[Fri Mar 21 15:48:23 2014] [error] [client *.*.*.*] PayJunction.php isError FALSE, referer: http://d1.orgname.org/civicrm/contribute/transact?_qf_Confirm_display=true&qfKey=954595d80a4a5028e993eb40851a220f_3328
[Fri Mar 21 15:48:23 2014] [error] [client *.*.*.*] PayJunction.php checkResult, referer: http://d1.orgname.org/civicrm/contribute/transact?_qf_Confirm_display=true&qfKey=954595d80a4a5028e993eb40851a220f_3328
[Fri Mar 21 15:48:23 2014] [error] [client *.*.*.*] PayJunction.php doDirectPayment Success, referer: http://d1.orgname.org/civicrm/contribute/transact?_qf_Confirm_display=true&qfKey=954595d80a4a5028e993eb40851a220f_3328

Last line of that Apache log: "Success"

Why is CiviCRM not receiving that Success status back from the PayJunction specific modules?

I'm having this same problem with PayPal (sandbox) on a membership signup form. I tried your suggestion of changing the financial type to "Donation" but the contribution status is still "Pending : Incomplete Transaction" and the user is not added as a member (presumably because the transaction did not complete). Do you have any other suggestions?

UPDATE: I just found out the reason the membership was not added was because I was in test mode, and you can find test memberships in the same way that you find test contributions: Memberships > Find Memberships > Membership is a Test? Yes > Search

So this appears to have nothing to do with the transaction apparently not completing. It still says "Pending : Incomplete Transaction" under the test contribution.