Paste P10290

T243356 Check no one will get double-charged 2020-01
ActivePublic
Actions

Authored by AndyRussG on Jan 29 2020, 10:17 PM.

Tags

None

Referenced Files

	F31539277: raw.txt
	Jan 29 2020, 10:17 PM

Subscribers

None

	SELECT
	r.next_sched_contribution_date,
	c.receive_date
	FROM
	civicrm_contribution as c
	LEFT JOIN

	civicrm_contribution_recur as r
	ON
	r.id = c.contribution_recur_id
	WHERE
	r.next_sched_contribution_date < '2020-02-01' AND
	c.receive_date > '2020-01-01' AND
	r.cancel_date IS NULL;

Event Timeline

AndyRussG created this paste.Jan 29 2020, 10:17 PM

AndyRussG mentioned this in T243356: Civi: January 2020 Ingenico recurrings processing in duplicate?.