Page MenuHomePhabricator

CIVI error displaying contribs for cid=11355636
Closed, ResolvedPublic

Description

I get a network error when trying to access the list of donations for cid=11355636

11355636CID2022-12-08 at 2.59.51 PM.png (354×1 px, 98 KB)

Both Amber and Katie Hansen encounter the same error with just this cid. It's weird, I can access the Mailing Events, Activities and other lists for this CID but not the contribs. I'm using Firefox, Amber is using Chrome. I tried closing and reopening my Civi tab, and then my browser, but that didn't resolve it.

Event Timeline

This issue persists today. We're unable to help the donor in ZD #1245007 increase the amount of their recurring donation. If this could be pulled into a sprint or Chaos Crew it would be great - hopefully there are not more affected cids.

greg subscribed.

Weird. Adding to Chaos Crew.

Luckily still just one donor, right?

Thank you, and yes just this one odd duck.

The issue is the contact has a contribution from 2015 with no line items. I did some digging but our logging tables started in 2016 & we actually don't log the line item table anyway so I couldn't determine why.

So I checked for others - there are 683 contributions with no line items created between 2012-05-02 15:00:18 and 2015-10-21 01:09:31

SELECT c.id, receive_date, count(li.id) as line_count FROM civicrm_contribution c LEFT JOIN civicrm_line_item li ON li.contribution_id = c.id GROUP BY c.id HAVING line_count = 0;

For the specific contact / contribution in question I created a line item
drush @wmff cvapi LineItem.create entity_id=12461511 entity_table='civicrm_contribution' qty=1 unit_price=5 line_total=5 contribution_id=12461511 financial_type_id="Engage" price_field_id="contribution_amount"

However it might not be worth doing for the others. Ideally it should be rows in civicrm_line_item, civicrm_financial_item, civicrm_financial_trxn and civicrm_entity_financial_trxn that are created but doing that is a bigger chunk of work.

OTOH there are very few of them & a patch has already been proposed upstream https://github.com/civicrm/civicrm-core/pull/25145 - which I can review. I'm not even sure we need to backport it - the chance of someone hitting the error on one of the other 600~ contacts before we next update is pretty small

Thanks for the knowledge @Eileenmcnaughton. I helped this donor and if a patch is slated for the next update my ask for this Task is all set.

MBeat33 claimed this task.