CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Erratic results with Profile + CiviMember + CiviContribute
Pages: [1]

Author Topic: Erratic results with Profile + CiviMember + CiviContribute  (Read 1559 times)

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Erratic results with Profile + CiviMember + CiviContribute
March 31, 2011, 07:03:58 am
Greetings,

Since our configuration is connecting multiple sub-components of Civi together, it was hard for me to decide which forum group to post to.

Our organization is an on-line community. CiviContribute charges keep their Drupal / CiviMember ID active which we include the creation of a Profile to gather contact information for the member.

Several weeks ago, I believe while we had v3.3.5 code on the server, CiviContribute transactions were making it all of the way to "Completed" state. Our CC gateway is PayJunction (PJ), and when the charges were making it all of the way to "Completed" in Civi, the one thing which was missing was the recurring attribute on the charge per PJ. We were having to manually turn that on via the PJ website. Ever since we began with CiviCRM / PJ, yes the "Enabling the PayJunction processor to handle recurring contributions" has been in our configuration, per the instructions here: http://wiki.civicrm.org/confluence/display/CRMDOC33/PayJunction+Configuration#PayJunctionConfiguration-RecurringContributions

For the past couple of weeks (Since 03/21/2011 per my sent email...), however, behavior has suddenly changed! Currently CiviContribute transactions get stuck / do not move past "Pending (Incomplete Transaction)" and magically transactions appear correctly in recurring mode at the PJ website! (When transactions actually show up at PJ that is!) A fair number of transactions get stuck at "Pending (Incomplete Transaction)" and appear NO WHERE at the PJ website!

Since the CiviContribute transactions do not get to completed state, then obviously we do not get receipts emailed.

Additionally no email is generated when a person completes the Profile attached to this configuration.

<><><><>

Straight up CiviContribute donation transactions appear to work FAR MORE SMOOTHLY! We see those go through to "Completed", and the receipt with PDF attachment is delivered.

So it seems to us that Civi is able to handle small tasks, but when Drupal user account creation + Profile + CiviContribute + CiviMember + LoginToboggon + EIEIO are all strung together, the process does not work properly.

I have been thus interested in the logging aspects of Civi, and default logging is silent as to what is happening in Civi internals.

PJ said months ago they were going to set up a CiviCRM test environment to help us work through such issues. We are yet to see them complete the task.

As members (both new and existing) are getting ticked off at the troubles and some are leaving, I am turning here to seek assistance with these troubles.

Sincerely,
Michael Lueck
« Last Edit: March 31, 2011, 07:09:51 am by mdlueck »
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Erratic results with Profile + CiviMember + CiviContribute
March 31, 2011, 08:18:54 am

Seems like civi is recording that "it sent the user to PJ" and is not hearing anything back. hence the incomplete transaction

i would do the following:

1. check with PJ to see if they have logs of whos coming from your site

2. check your access logs and see if PJ makes the IPN call back to your website

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Erratic results with Profile + CiviMember + CiviContribute
March 31, 2011, 08:26:57 am
Thanks lobo.

About #2, with the Civi / PJ handshake there is no return path comparable to Authroize.net. According to PJ, all PJ is going to communicate back about a charge is returned at the time Civi sends the charge to PJ.

There is some voo-doo Rx to modify the Authorize.net return path program file to have it receive Authorize.net format chatter from PJ's Authorize.net return path simulator. I thought we needed to do that in order to get transactions to reach "Completed" state. Since the straight-up donations work consistently and only the more complicated memberships are having trouble, apparently configuring the return path via the Rx is not really necessary.

I will work on your #1 request.
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Erratic results with Profile + CiviMember + CiviContribute
April 07, 2011, 07:42:52 am
First the answer to Lobo's #1 question:

Quote
As for Lobo's question regarding "who is coming from your site"...
This was essentially answered in the previous email by indicating which transactions we saw on our end. We have received all of the transactions, except for 2 that were processed by <MEMBER NAME HERE> (he tried 3 times, 1 succeeded, 2 did not)

I got the impression that the PJ website somehow shows different subsets of the transactions on various web pages, or something like that. So it is necessary to piece together several screens in order to get the complete picture.

More details about what we are seeing:

1) New Member Joins using PayPal are exhibiting the same bad behavior. Site membership joins getting stuck at "Pending" rather than going all of the way to completed, emails not getting sent, etc...

2) March 26 is the last email we have received from the Profile created during a new member join process. We were on exactly the same version of CiviCRM then as we are running now: 3.3.5. SourceForge shows a date of 2011-02-08 that version released, and I seem to recall applying that the same day as there was a security update included.

3) The LoginToboggan module has been disabled for about a week now. No improvement to these new member join problems has been seen. Exactly the same results. So I would think LoginToboggan is now in the clear for not being involved. (Now that I think of it, I do not think I cleared the /files/civicrm/templates_c/ directory after disabling LoginToboggan, so I will try that now.)

4) The thing which does work consistently 100% of the time is straight up CiviContribute donations. The transactions go all of the way through to "Completed" and the receipt email with PDF attachment is delivered.

Do you have further suggestions of things we should try to improve our results? Thank you!
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Erratic results with Profile + CiviMember + CiviContribute
April 08, 2011, 08:35:19 am
Via IRC: According to Lobo:
dlobo>   mdlueck: there are too many combination that are used in your setup that we don't have experience with

OK, so:

1) Shall we drop certain parts of our member join process to simplify it? If so, please specify.

2) Should we migrate to beta releases of 3.4 and assist with testing at this point? Will documenting such problems be easier to address with a beta release rather than fixing the current stable release?

Frankly I am at a loss...
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Erratic results with Profile + CiviMember + CiviContribute
April 08, 2011, 09:30:08 am

other than getting into the code and debugging whats happening and why, i cant really offer any other suggestions

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Erratic results with Profile + CiviMember + CiviContribute
April 08, 2011, 10:39:08 am
Quote from: mdlueck on April 07, 2011, 07:42:52 am
3) The LoginToboggan module has been disabled for about a week now. No improvement to these new member join problems has been seen. Exactly the same results. So I would think LoginToboggan is now in the clear for not being involved. (Now that I think of it, I do not think I cleared the /files/civicrm/templates_c/ directory after disabling LoginToboggan, so I will try that now.)

Well possibly clearing the /templates_c/ directory shook problems out. This morning we had someone update their membership using monthly recurring PayPal. The transaction made it through to "Completed" state, the email was sent as result of filling in the profile. The only think lacking on the CiviCRM side was Civi does not think the transaction is a recurring one.

However on the PayPal side, they show the transaction correctly as recurring. So better to have PP thinking in terms of recurring than neither side.

I hope the next CC site membership goes as smoothly!!!  :)

P.S. Perhaps since PayPal has this charge as a recurring charge, can Civi NOT show the charge as recurring as that would result in both systems charging / aka double charges? Perhaps Civi can not show recurring since PayPal is in recurring mode.
« Last Edit: April 08, 2011, 10:45:42 am by mdlueck »
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Erratic results with Profile + CiviMember + CiviContribute
April 21, 2011, 11:32:38 am
Greetings,

Last Friday we made noticeable progress on our Civi quirks list. Lobo was able to assist us with being able to update contact records without getting a SQL error.
http://forum.civicrm.org/index.php/topic,19427.msg81255.html#msg81255

Meanwhile our application people had discovered how to drive just the Profile part of our Join process. That Profile works 100% perfect: We receive the email that the profile was submitted, the Drupal account is created... PERFECTLY!

This raises the question: Can I forbid that bare Profile URL in Apache to prevent site hackers from creating bogus accounts? Or must that Profile URL be accessible via Apache in order for the Contribution Page to include the Profile correctly?

It is and it is not a security hole in our site. It is based on the ability to create bogus accounts. It is not because they have not gone through CiviContribute to accomplish it, thus they have no group permissions therefor less access rights to the site than Anonymous!  ;D

Let me back up just a second... Per the applicaiton team here, this is where they got their Rx from for creating what they created:

contribution
http://en.flossmanuals.net/civicrm/ch027_configuring

membership
http://en.flossmanuals.net/civicrm/ch037_configuring

profile
http://en.flossmanuals.net/civicrm/ch012_profiles

So what we have is:
Four contribution pages (2 for Credit Card {PayJunction} and 2 for PayPal... 2 monthly / 2 yearly)
Attached to those is one Profile page which collects the contact information and creates a Drupal account

The Contribution pages have been "re-factored" many times, ultimately arriving back at what the application folks first attempted, just Civi was not ready to support that and as result of staying on current code now the original design is supported. (At the moment I am unable to find the thread where Dave Greenberg made known that some feature had just become possible in current code, thus the stimuli to circle back to the original design.)

That being said, perhaps there is crud in the database somewhere from so many "re-factorings" of the same Contribution pages, and we simply need to start over creating them correctly from the start, then they might work better? Or might that not even be successful based on what Lobo found in our database elsewhere... that even if we were to start with four new Contribution pages, might odd errors persist due to lateral crud in the database?

I am encouraged to see portions of the needed process work flawlessly!  ;D Looking forward to it ALL working FLAWLESSLY soon!  :o

Thank you so much!
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Erratic results with Profile + CiviMember + CiviContribute
April 21, 2011, 12:01:40 pm

goto a url like:

http://drupal.demo.civicrm.org/civicrm/admin/uf/group/update?action=update&id=1&context=group

(which u can get from administe civicrm >> civicrm profile >> settings (for thtat profile)

and uncheck the "Profile" in the used for box

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Erratic results with Profile + CiviMember + CiviContribute
April 21, 2011, 01:35:31 pm
Neat trick, Lobo! That takes care of the (A) part of my long question.

So any thoughts on the (B) part... "erratic behavior possibly associated with so many re-factorings of the contribution pages - how to clean?"
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Erratic results with Profile + CiviMember + CiviContribute
April 21, 2011, 02:01:29 pm

you'll have to be a lot more specific on what is erratic and not working
.
lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Erratic results with Profile + CiviMember + CiviContribute
April 21, 2011, 02:42:22 pm
Credit card transactions not consistently going through to completion. Same with Pay Pal. No new user registration email received from the new user registration profile. Receipts never received. and on and on...

The New User Registration Profile was successfully tested external to the CiviMember + CiviContribute process and was found to be working 100%.

Straight up simple Donations also work 100%.

So our thought gears are working on why the new member join process would not work as a whole.

I thought perhaps since so much redesign had gotten done to the four contribution pages, that garbage could be stuck in a table somewhere.

Thus, should we start over with four new contribution pages, or perhaps would that still leave data in tables that would continue plaguing the new member join process? How much to flush out to make sure this Join process has a fair chance at succeeding?
« Last Edit: April 21, 2011, 02:44:38 pm by mdlueck »
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Erratic results with Profile + CiviMember + CiviContribute

This forum was archived on 2017-11-26.