Payment processing issue

[Eileen]

Hello,

I have been testing the upgrade to 3.1 on a site using eWay as the payment processor. It works fine on contribution pages but when I go to the equivalent of this page:


http://sandbox.civicrm.org/civicrm/contact/view/contribution?reset=1&action=add&cid=112&context=contribution&mode=live


I get a non-recoverable error. The cause of the error is this (invalid ) SQL:


SELECT civicrm_pledge.id id
FROM civicrm_pledge
WHERE civicrm_pledge.status_id   IN (2,,6)       
  AND civicrm_pledge.contact_id = 82502


But I'm not how it is deriving that incorrect IN clause (with the extra comma). This doesn't seem payment processor located but I'm not sure where in the code it is coming up with the that SQL to look for pledges at this point.

[Kurund Jalmi]

You should replicate this on http://drupal.demo.civicrm.org, if you are able to replicate file an issue.

Kurund

[Eileen]

Hi,

This is a site we inherited & so I don't have any background but the Option Value for contribution_status that would normally be 'In Progress' had been renamed to 'Refer to Notes'. I have no idea why.

As a minor side issue I think the 'is_reserved' flag should be set to 1 for all of these option_values (group 11 in my installs) as they clearly are required to match the system values and while these fields aren't front end configurable it is a small safeguard against silly developers and any front end configurability that gets added later

[Donald Lobo]

yes, we should make those reserved. wanna submit a patch (and a corresponding upgrade snippet) along with an issue to do the needful

thanx

lobo

[ruid]

I have got the same problem for a 3.1version upgraded from 1.9 version which only have 4 status: Completed(1), Pending(2), Cancelled(3) and Overdue(6) whenever I clicked add contribution or edit contribution. After I added those 2 status: Failed(4) and In Progress (5), it is back working.

I am interested where is this query code located. I grepped and found it seems on /CRM/Pledge/BAO/Query.php but couldn't see any change when I modified that file. And why it is querying civicrm_pledge.status_id instead of civicrm_contribution.status_id?

[Eileen]

The code is in Contribute/PseudoConstant.php

[Eileen]

I logged it but not sure if it is required as my databases don't seem to have it set but the blank template does.

http://issues.civicrm.org/jira/browse/CRM-5752