Description
Description
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Resolved | Ejegg | T315102 Custom field "AF_has_active_recurring_donation" is showing false positives | |||
Invalid | Spike | None | T317164 Look into paypal recurrings that are status pending but no next_sched_contribution_date |
Event Timeline
Comment Actions
Note my query
select cr.next_sched_contribution_date, count(*), cr.contact_id,cr.id, MAX(create_date) FROM civicrm_contribution_recur cr WHERE cr.contribution_status_id IN (2,5) AND (cr.next_sched_contribution_date IS NULL OR cr.next_sched_contribution_date = '') GROUP BY cr.next_sched_contribution_date; +------------------------------+----------+------------+---------+---------------------+ | next_sched_contribution_date | count(*) | contact_id | id | MAX(create_date) | +------------------------------+----------+------------+---------+---------------------+ | NULL | 133 | 4519330 | 1165653 | 2022-09-05 17:03:56 |
We thought these might have all been historical - but not so much. Note the contact_id and id are 'eg' - ie it's just displaying one because it is group by - which just gives us something to spot check but the two ids might not be the same record
Comment Actions
Unsure if this issue is still occurring - please create a fresh Phab if we see this again.