Reportbacks Getting Into Drupal w/ No Photos

[jessleenyc]

BUG

Current Behavior

There are approx 1000 reportbacks in the db with no photos associated.

Desired Behavior

Uploading a photo is a requirement for reportingback so we need to figure out where the photo is or why reportbacks are getting through without the photo.

Steps to Replicate

Refer to these examples:
https://docs.google.com/spreadsheets/d/1Z3W_EPKKTRlamrk3mAUPnkw5PAzumKdbyhlb3lnsWPI/edit#gid=1841358361

Also, no idea who Edmund Burke is and how he ended up in our db.

[angaither]

wow.

I have no idea what's going on here. I ran this query to see if there was a record of what's happening but there's no record in the log table of inserting these, and for most there is no record in the dosomething_reportback_file table with a source.

select rb.rbid, rb.nid, n.title, rb.run_nid, rbf.source, rbf.fid, from_unixtime(rb.created), l.op, from_unixtime(l.timestamp), l.files
from dosomething_reportback rb
left join dosomething_reportback_file rbf on rb.rbid = rbf.rbid
left join dosomething_reportback_log l on rb.rbid = l.rbid
inner join node n on rb.nid = n.nid
where rb.rbid in (list of rbids)

[jessleenyc]

@angaither this trello issue might shed a tiny bit of light as to what's happening -- https://trello.com/c/IEKQMlfe/1521-issue-with-rb-for-ggw

Apparently a member went through all the reportback steps, hit submit and got a 404. The reportback hit drupal but the photo never made it. This was a frugs issue from January that Nami dug up at 6am this morning. cc @ngjo

[angaither]

I bet this is because of #6167