Answers.Body: <p>I ran into this with a client and traced it to some bad data in the mailings table. The completed mailings that show up in the draft page are those with a NULL value in the scheduled_id column.</p>
  <p>I suspect there was a bug in an earlier version that caused that column to not be set properly when the mailing was scheduled. The unscheduled status filter on the mailing browse page uses that column to determine the status.</p>
  <p>You can fix it with this query (replace &quot;ID&quot; with the actual ID of a contact you want to associate as the scheduler).</p>
  <pre><code>UPDATE `civicrm_mailing` 
  SET scheduled_id = ID
  WHERE scheduled_id IS NULL 
  AND status = 'Complete'
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-10-17T08:05:47.837Z
Answers.Text: Wow @lcdservices, thank you so much. This was the solution we needed.
  Now everything works fine!
Answers.UserDisplayName: Regina Sommerfeld
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-09-11T19:11:04.213Z
Answers.LastActivityDate: 2024-09-11T19:11:04.213Z
Answers.UserDisplayName: lcdservices
Answers.Body: <p>At <a href="https://dmaster.demo.civicrm.org/civicrm/mailing/browse/scheduled?reset=1&amp;scheduled=true" rel="nofollow noreferrer">https://dmaster.demo.civicrm.org/civicrm/mailing/browse/scheduled?reset=1&amp;scheduled=true</a> there should be an exposed filter to determine what Mailings are going to show at each screen.</p>
  <p>You can also see this in the url, since the scheduled one shows as</p>
  <p>scheduled=true</p>
  <p>while the Draft shows as</p>
  <p>scheduled=false</p>
  <p>These are the two screens from Dmaster</p>
  <p>DRAFT
  <a href="https://i.sstatic.net/JzoFGn2C.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/JzoFGn2C.png" alt="enter image description here" /></a></p>
  <p>SENT
  <a href="https://i.sstatic.net/UmgPTwZE.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/UmgPTwZE.png" alt="enter image description here" /></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-03T20:21:49.253Z
Answers.Text: perhaps you can add screenshots and paths to your Question to help clarify the problem
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-04T07:04:23.883Z
Answers.Text: Thank you fpr your help, @petednz!
  I get an error message when I click on the demo link:
  "Access denied - You are not authorized to access this page."
  
  I didn't use screenshots as we have a german version, but maybe it's helpful though:
  scheduled: https://stiftungaktivebuergerschaft-my.sharepoint.com/:i:/g/personal/regina_sommerfeld_aktive-buergerschaft_de/EQCs4Dy1_gxGuLTO-XNedOQBlkGLiVFDwEwE_rHgtUmuTQ?e=sRSOmd
  drafts: https://stiftungaktivebuergerschaft-my.sharepoint.com/:i:/g/personal/regina_sommerfeld_aktive-buergerschaft_de/EeBzPprUBrNFs6OjTxEHmzgBFnxQ4wU3Ud7_eWOIGRdrVQ?e=WMfMMz
Answers.UserDisplayName: Regina Sommerfeld
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-04T07:09:27.377Z
Answers.Text: Sorry, I don't know how to insert images correctly ...
Answers.UserDisplayName: Regina Sommerfeld
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-04T07:40:56.490Z
Answers.Text: The images are fine and appear as they should / show on dmaster. Are the mailing IDs definitely the same for drafts and sent ones?
Answers.UserDisplayName: RebeccaTregenna
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-04T20:21:03.227Z
Answers.Text: There is info at https://dmaster.demo.civicrm.org/. It says "Just login with..., Username: demo, Password: demo"
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-04T20:21:49.407Z
Answers.Text: or is someone making the Draft, then someone else is coming along and clicking 'copy' and then sending the copied version?
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-09T07:39:40.443Z
Answers.Text: I compared all message IDs of drafts and sent mails and they are all identical.
  And yes, we often use the procedure that one person writes the draft and another person is sending the mail (without "copy").
Answers.UserDisplayName: Regina Sommerfeld
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-03T20:21:21.350Z
Answers.LastActivityDate: 2024-07-03T20:21:21.350Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>does anybody have the same conspicuity?</p>
  <p>Our finished and sent mails appear in the list of drafts and without the name of the sender.</p>
  <p>Why? And how do we change this?</p>
  <p>Regards,
  Regina</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-07-03T08:37:08.583Z
Comments.Text: We use CiviMail with CiviCRM 5.74.4 in WordPress 6.5.5.
Comments.UserDisplayName: Regina Sommerfeld
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-07-03T20:17:10.733Z
Comments.Text: not heard of it. do they Mailings actually have the same ID - if so is it possible that your displays of Mailings have been overwritten at some time in past so the filters have been modified - had to look up 'conspicuity'. have never seen it in use.
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-07-04T06:54:24.493Z
Comments.Text: 'conspicuity' was suggested by Google Translator ;-)
Comments.UserDisplayName: Regina Sommerfeld
Tags: <civimail><email>
Title: sent mails appear in the list of drafts
ThreadText: # sent mails appear in the list of drafts
  
  (Asked by: username_0 on 2024-07-03)
  
  does anybody have the same conspicuity?
  
  Our finished and sent mails appear in the list of drafts and without the name of the sender.
  
  Why? And how do we change this?
  
  Regards,
  Regina
  
  **Tags:** civimail, email
  
  > **Comments:**
  > **username_0**: We use CiviMail with CiviCRM 5.74.4 in WordPress 6.5.5.  
  > **username_1**: not heard of it. do they Mailings actually have the same ID - if so is it possible that your displays of Mailings have been overwritten at some time in past so the filters have been modified - had to look up 'conspicuity'. have never seen it in use.  
  > **username_0**: 'conspicuity' was suggested by Google Translator ;-)  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2024-09-11. Score: 2
  
  I ran into this with a client and traced it to some bad data in the mailings table. The completed mailings that show up in the draft page are those with a NULL value in the scheduled_id column.
  I suspect there was a bug in an earlier version that caused that column to not be set properly when the mailing was scheduled. The unscheduled status filter on the mailing browse page uses that column to determine the status.
  You can fix it with this query (replace "ID" with the actual ID of a contact you want to associate as the scheduler).
  UPDATE `civicrm_mailing` 
  SET scheduled_id = ID
  WHERE scheduled_id IS NULL 
  AND status = 'Complete'
  
  > **Comments:**
  > **username_0**: Wow @username_2, thank you so much. This was the solution we needed. Now everything works fine!  
  
  ---
  
  ### Answer by username_1 on 2024-07-03. Score: 2
  
  At <https://dmaster.demo.civicrm.org/civicrm/mailing/browse/scheduled?reset=1&scheduled=true> there should be an exposed filter to determine what Mailings are going to show at each screen.
  
  You can also see this in the url, since the scheduled one shows as
  
  scheduled=true
  
  while the Draft shows as
  
  scheduled=false
  
  These are the two screens from Dmaster
  
  DRAFT
  [![enter image description here](https://i.sstatic.net/JzoFGn2C.png)](https://i.sstatic.net/JzoFGn2C.png)
  
  SENT
  [![enter image description here](https://i.sstatic.net/UmgPTwZE.png)](https://i.sstatic.net/UmgPTwZE.png)
  
  > **Comments:**
  > **username_1**: perhaps you can add screenshots and paths to your Question to help clarify the problem  
  > **username_0**: Thank you fpr your help, @petednz! I get an error message when I click on the demo link: "Access denied - You are not authorized to access this page."  I didn't use screenshots as we have a german version, but maybe it's helpful though: scheduled: https://stiftungaktivebuergerschaft-my.sharepoint.com/:i:/g/personal/regina_sommerfeld_aktive-buergerschaft_de/EQCs4Dy1_gxGuLTO-XNedOQBlkGLiVFDwEwE_rHgtUmuTQ?e=sRSOmd drafts: https://stiftungaktivebuergerschaft-my.sharepoint.com/:i:/g/personal/regina_sommerfeld_aktive-buergerschaft_de/EeBzPprUBrNFs6OjTxEHmzgBFnxQ4wU3Ud7_eWOIGRdrVQ?e=WMfMMz  
  > **username_0**: Sorry, I don't know how to insert images correctly ...  
  > **username_3**: The images are fine and appear as they should / show on dmaster. Are the mailing IDs definitely the same for drafts and sent ones?  
  > **username_1**: There is info at https://dmaster.demo.civicrm.org/. It says "Just login with..., Username: demo, Password: demo"  
  > **username_1**: or is someone making the Draft, then someone else is coming along and clicking 'copy' and then sending the copied version?  
  > **username_0**: I compared all message IDs of drafts and sent mails and they are all identical. And yes, we often use the procedure that one person writes the draft and another person is sending the mail (without "copy").  
  
  ---
  
  