We've got 27 emails that show as completed, have a report, etc; however, they are showing on the list of Draft/Unscheduled emails. What could be causing this to happen? I'm trying to clean up the back-end for the new volunteers who will be working with the site this year, but I don't want to delete emails that have actually been sent.

We're on Drupal 7 and CiviCRM 5.5.3

CiviCRM screenshot

  • Is this on CiviMail report or Activity report? – Pradeep Nayak Oct 11 at 9:10
  • If this is in CiviMail - what checkboxes are checked in the Mailing Status box for each menu item (Draft and Unscheduled Mailings vs. Scheduled and Sent Mailings)? – RayWright Oct 11 at 17:40
  • It's the page you get when your select the Unscheduled and Draft link under the Mailings menu item. The only thing checked is the one for unscheduled and drafts or whatever it's called (sorry, don't have it right in front of me at the moment). Only a couple dozen out of hundreds of sent emails are showing on that page. – Jenni Simonis Oct 12 at 10:09
  • Now that I'm at the computer, I grabbed a screenshot to show where it's at and what is clicked. – Jenni Simonis Oct 12 at 21:06
  • The screenshot is helpful - is see it's not respecting that 'draft / unscheduled' checkbox. Since it's only a couple dozen, maybe you can take a look in the database itself, see if there is some other value that these share but not the other completed mailings that aren't showing. (Also I see that the created by is blank on the couple shown in the screenshot - theoretically that should have nothing to do with it - but it's strange there's no contact listed maybe that's affecting things?) – RayWright Oct 19 at 17:17

I just verified that a completed mailing (in my test installation of 5.5.3) will show up in the draft/unscheduled list IF the original creator of the email is a deleted (permanently) user. Doesn't solve the problem but at least gives us a cause.

  • Thanks! I wonder if I can go into the database and add a user to them. I've told folks not to remove people, just change their permission level. – Jenni Simonis Oct 19 at 19:48
  • I didn't fully test it someone who was only partially deleted (still recoverable). Maybe there's a chance you can restore the original contact. If not, I agree you should just be able to assign it directly in the database to make that connection again and pull them off the report. – RayWright Oct 19 at 19:52
  • I think they completely deleted the person, plus I'd have no idea who it was. I just assigned them all to my user account since it's easy to just input 1 as the user who did it. Now they're all gone from that list. :D – Jenni Simonis Oct 19 at 20:01
  • 1
    Yay! Glad it all worked out! – RayWright Oct 19 at 20:02

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.