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 CiviContribute (Moderator: Donald Lobo) »
  • D6 / Civi 3.4.8 suddenly start CRM-8814 nonsense without any change to config
Pages: [1]

Author Topic: D6 / Civi 3.4.8 suddenly start CRM-8814 nonsense without any change to config  (Read 2056 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
D6 / Civi 3.4.8 suddenly start CRM-8814 nonsense without any change to config
October 14, 2012, 01:26:17 pm
Greetings,

Our site recently started the nonsense reported in CRM-8814 ( http://issues.civicrm.org/jira/browse/CRM-8814 ) Incorrect form-action for login-form on contribution page results on submit in error "This contribution has already been submitted. Click here if you want to make another contribution."

We have been on Civi 3.4.8 since shortly after it was released. So it is very odd that just out of the blue contribution transactions would begin this nonsense.

We just tried restricting the Drupal Login block to not be included on any civicrm* URL's, per Lobo's suggestion. That did not resolve this error.

Some times, absolutely nothing shows up in either Drupal Watchdog or the CiviCRM log file. Yet brand new contribution (donation) transactions were attempted.

We have tried with both having the Drupal user logged in, and also logged out / anonymous generating a contribution transaction. The error appears the same.

As the end of the year approaches, this is the peak donation time of year for our organization. Assistance resolving this trouble is most appreciated.
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: D6 / Civi 3.4.8 suddenly start CRM-8814 nonsense without any change to config
October 15, 2012, 05:27:53 am
This happens for every contribution attempt?

You tried deleting all folders in templates_c and also Config.IDS.ini ?

Do you have any custom CiviCRM templates or PHP files?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

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: D6 / Civi 3.4.8 suddenly start CRM-8814 nonsense without any change to config
October 15, 2012, 03:06:39 pm
Quote from: Hershel on October 15, 2012, 05:27:53 am
This happens for every contribution attempt?

Yes, suddenly all donation contributions / CC gateway PayJunction are getting this error. Some get logged, some do not get logged.

Quote from: Hershel on October 15, 2012, 05:27:53 am
You tried deleting all folders in templates_c and also Config.IDS.ini ?

Yes, I rm -rf templates_c/%%*

I have never wiped out Config.IDS.ini file. Looks to be correct data in it.

Quote from: Hershel on October 15, 2012, 05:27:53 am
Do you have any custom CiviCRM templates or PHP files?

I have a few customizations to core Civi...

Fix for Civi insisting on a Multi-Site Drupal installation:
cd /sites
ln -s default domain.org
Done.

Pre-form Help text in preview mode of profile only, why?
http://forum.civicrm.org/index.php/topic,18205.msg86293.html
sites/all/modules/civicrm/templates/CRM/Profile/Form/Search.tpl

That appears to be the extent of my customizations at present. The other ones are all marked "no longer needed", thus those were not applied to 3.4.8 when I upgraded to it.
--
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: D6 / Civi 3.4.8 suddenly start CRM-8814 nonsense without any change to config
October 16, 2012, 07:07:12 pm
This evening we received word that site membership joins are also dead via the same error. So it is not restricted to only the more simple donation process, but also the site membership which involves a Civi Profile and a Drupal user account creation and one other detail I am not remembering right off hand... (Civi Contribution + Civi Membership + Civi Profile which provisions a Drupal user account... fffeeewww!!!)

We have contacted PayJunction, the CC gateway we use.
--
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: D6 / Civi 3.4.8 suddenly start CRM-8814 nonsense without any change to config
October 22, 2012, 03:16:18 am
We contacted PayJunction a while ago about this issue, I seem to have forgotten to post their response here...

About the:
Payment Processor Error message: 9001:Unknown System Error.

which is reported by the people attempting to make the Civi Contribution from their web browser... PayJunction says that the error message is not coming from their gateway, so must be coming from CiviCRM / Drupal.

Yet internally in the log files / Drupal Watchdog, Civi logs that the Contribution has already been completed.

Sounds to me like Civi has perhaps a transaction stuck that it keeps going back to and thinking about rather than moving onto / thinking about a new transaction. Is there any such Contribution serialization scheme that might be biting us? Anyway to resolve / correct this?
--
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: D6 / Civi 3.4.8 suddenly start CRM-8814 nonsense without any change to config
October 24, 2012, 06:45:54 pm
Our gateway partner, Pay Junction, came across other sites experiencing sudden trouble. In those cases, the root cause was outdated CA Certs.

I understand that newer builds of CiviCRM come with its own CA Certs. Our older 3.4.8 build must utilize what comes with the host OS as I could not find CA Certs within the CiviCRM directory structure.

Since we host on Ubuntu, I located the correct command to run to force the update of CA Certs:

Code: [Select]
# sudo update-ca-certificates
That updated many files under /etc/ssl/certs.

However, production transactions still receive on the web browser a "Payment Processor Error message : 9001:Unknown System Error."

NOTHING was logged to the Civi log or Drupal Watchdog.

Any suggestions?
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: D6 / Civi 3.4.8 suddenly start CRM-8814 nonsense without any change to config
October 24, 2012, 07:09:32 pm
So 2 separate bugs

On CRM-8814 - we have also hit this on d6/3.4.8 starting in late Sep. Site had numerous module updates @ that time & ccccc module installed
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: D6 / Civi 3.4.8 suddenly start CRM-8814 nonsense without any change to config
October 24, 2012, 07:12:21 pm
Note that what we are seeing is the login form being submitted when the contribution form is submitted (ie. the login button is not being submitted at all)
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Chris Burgess

  • Ask me questions
  • ****
  • Posts: 675
  • Karma: 59
Re: D6 / Civi 3.4.8 suddenly start CRM-8814 nonsense without any change to config
October 24, 2012, 07:38:35 pm
Also, if the login form is used on that page, then the contribution form throws an error.

Without access to debug (Eileen showed me the site which was misbehaving), it appears that CiviCRM attempts to handle all form submissions to the CiviCRM path. Drupal will post forms like login to the current form path, and when processing forms checks that the form ID submitted matches one in its form cache. I suspect that if CiviCRM checked for a qfKey value before attempting to handle POST requests, it would not be throwing this error.

(ie, if (!$qfKey = CRM_Utils_Request::retrieve('qfKey')) then render the form for display)
@xurizaemon ● www.fuzion.co.nz

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: D6 / Civi 3.4.8 suddenly start CRM-8814 nonsense without any change to config
October 26, 2012, 03:23:06 pm
Quote from: Eileen on October 24, 2012, 07:09:32 pm
So 2 separate bugs

Terrific. Most confusing.

Quote from: grobot on October 24, 2012, 07:38:35 pm
it appears that CiviCRM attempts to handle all form submissions to the CiviCRM path. Drupal will post forms like login to the current form path, and when processing forms checks that the form ID submitted matches one in its form cache.

I stated in the OP that I already tried...

Quote from: mdlueck on October 14, 2012, 01:26:17 pm
We just tried restricting the Drupal Login block to not be included on any civicrm* URL's, per Lobo's suggestion. That did not resolve this error.

so it can not possibly be the Drupal login block causing the problem as it does not appear on any CiviCRM page any longer.

The simple donation contribution we are testing with does not require Drupal authentication to access it.

This is the solution that was applied in order to get it working.

I will be trying this suggestion from PayJunction shortly.

Quote from: PayJunction Support
1)
Get the latest version of the cacert.pem file:
http://curl.haxx.se/ca/cacert.pem

2)
Save your own copy of the pem file on your server:
For example: http://YourDomain.com/cacert.pem

3)
Within, CiviCRM, find the file named pjClasses.php

On line 200, add the following:
curl_setopt($ch, CURLOPT_CAINFO, 'http://YourDomain.com/cacert.pem');

Your cURL reference should look like this:
/*
* PayJunction service request and response
*/
$ch = curl_init($url);
curl_setopt($ch, CURLOPT_HEADER, FALSE);
curl_setopt($ch, CURLOPT_POST, TRUE);
curl_setopt($ch, CURLOPT_POSTFIELDS, $request);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, TRUE);
curl_setopt($ch, CURLOPT_CAINFO, 'http://YourDomain.com/cacert.pem');
$content = curl_exec($ch);
curl_close($ch);

4)
Process a new test. Let me know how this goes.
--
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: D6 / Civi 3.4.8 suddenly start CRM-8814 nonsense without any change to config
October 26, 2012, 05:04:21 pm
I tried PJ's suggestion just now, same exact 9001 error on the web browser.

Eileen, you mentioned two bugs... what would the "other" bug be? Where would it be documented?

Trouble with CACerts seems more likely than the Drupal Login block suddenly causing troubles without any software / configuration changes. But other than PJ pulling that possibility out of their hat, I am not seeing anything confirming that as a possibility.
--
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: D6 / Civi 3.4.8 suddenly start CRM-8814 nonsense without any change to config
October 27, 2012, 12:00:31 pm
The PayJunction suggested code including a URL would not work as our server has the hardened PHP installed on it, where URL's are taboo.

I adjusted the code to utilize getcwd() instead. Still the 9001 error persisted.

This code was not checking for error messages:

Code: [Select]
/*
* PayJunction service request and response
*/
$ch = curl_init($url);
curl_setopt($ch, CURLOPT_HEADER, FALSE);
curl_setopt($ch, CURLOPT_POST, TRUE);
curl_setopt($ch, CURLOPT_POSTFIELDS, $request);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, TRUE);
curl_setopt($ch, CURLOPT_CAINFO, getcwd() . '/cacert.pem');
$content = curl_exec($ch);
curl_close($ch);

So I hacked in:

Code: [Select]
error_log("Curl error = >" . curl_error($ch) . "<");
Saw this:

[27-Oct-2012 14:29:34] Curl error = >error setting certificate verify locations:

and it looking for the cacert.pem in the web-root directory instead of down in the CiviCRM directory. I modified the path in the CURLOPT_CAINFO LOC adding the site relative path, and transactions are processed successfully.

Now to put the site back to the way it is suppose to be configured, and and and...

Thank You God.

Blessings,
Michael
« Last Edit: October 27, 2012, 12:03:45 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 CiviContribute (Moderator: Donald Lobo) »
  • D6 / Civi 3.4.8 suddenly start CRM-8814 nonsense without any change to config

This forum was archived on 2017-11-26.