Collections call to users_of_interest fails for users where actor.usr.card is null

Bug #990066 reported by Bill Ott
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Evergreen
Triaged
Undecided
Unassigned

Bug Description

Unique Management reported to me that a pull of users_of_interest was failing.

Problem was determined to be when attempting to pull a list of users_of_interest where one of those users did not have a card value.

Background:
We discovered this after deleting a large batch of old/dead accounts. At least one account was subsequently retrieved by barcode and chaos insued while this deleted account was used. To rectify this, we removed the actor.card entry, as well as the actor.usr.card value. This caused the noted problem.

To rectify this, I've added to the SQL in the money.pm new_collections method, verifying that the actor.usr record was not deleted. I'm not sure if this is the best method to resolve this, but it was effective.

Tags: collections
Revision history for this message
Bill Ott (bott) wrote :
Revision history for this message
Jason Stephenson (jstephenson) wrote :

Needs confirmation by another party.

Changed in evergreen:
status: New → Triaged
Jeff Godin (jgodin)
tags: added: collections
Revision history for this message
Ben Shum (bshum) wrote :

Marked this bug a duplicate of the newer one since it had slightly more recent discussion and traffic. But I am carrying forward Bill's suggested patch change here.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.