Body: <p>Finally have Civi 5.73.3 (Drupal 10) up and running.  Was able to import contacts from another database, search for contacts, create a group and smart group, etc.</p>
  <p>But when I try to send create a mailing, both &quot;Save draft&quot; and &quot;Send Test&quot; result in DB Error: Unknown Error.  This isn't creating any error logs in my Drupal reports -- although other Civi errors do.</p>
  <p>Also worth noting: The drafts ARE in fact saving in my draft mailings section.  However test emails are not sending.</p>
  <p>I have made sure to enter a recipient group, which has historically been the glitch here, but with everything filled out, same error.</p>
  <p>One note:  my Drupal installation is unhappy that civicrm_install_canary does not have a primary key.  This table seems to be empty, may I delete it?  Not sure if this is related to my mail problem or totally distinct, but wanted to mention it.</p>
  <p>Thanks in advance!
  -tiffani</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-05-28T19:37:12.617Z
Comments.Text: what are your settings at /civicrm/admin/setting/smtp?reset=1
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-05-28T19:41:50.187Z
Comments.Text: Allow mail from logged in contact YES
  Select mailer: mail()
Comments.UserDisplayName: Tiffani Chin
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-05-28T20:18:29.237Z
Comments.Text: You can ignore the canary warning, but don't delete the table. In recent drupal installs you're likely to have the isolation set to something that will work in a basic civi install, but has this warning. See https://www.drupal.org/docs/getting-started/system-requirements/setting-the-mysql-transaction-isolation-level. You can add an arbitrary primary key to the table though to make the warning go away.
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-05-28T20:20:37.403Z
Comments.Text: Are you able to send a "regular" email as opposed to a bulk mailing, e.g. Contacts - New Email?
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-05-28T20:53:20.420Z
Comments.Text: I can!  Individual email works.
Comments.UserDisplayName: Tiffani Chin
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-05-28T21:07:30.013Z
Comments.Text: Also, thank you.  I designated the ID column as the primary key for the canary table and that solved the error.
Comments.UserDisplayName: Tiffani Chin
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-05-29T20:24:42.320Z
Comments.Text: will one of you add the above as an Answer
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-05-29T21:41:18.683Z
Comments.Text: @peterdnz -- I've solved the canary table part, but not the Civimail part.  Anyone have thoughts on that?  I can send groups of 50 through regular mail, but whenever try to send through Civimail I get the "DB error" dropdown.  Same response when I try to send a draft. 
  
  Is this something in my Civimail settings if the regular mail function is working? Thanks!
Comments.UserDisplayName: Tiffani Chin
Tags: <civimail>
Title: Civimail: emails will neither save (draft) nor send test -- DB Error: Unknown Error
ThreadText: # Civimail: emails will neither save (draft) nor send test -- DB Error: Unknown Error
  
  (Asked by: username_0 on 2024-05-28)
  
  Finally have Civi 5.73.3 (Drupal 10) up and running. Was able to import contacts from another database, search for contacts, create a group and smart group, etc.
  
  But when I try to send create a mailing, both "Save draft" and "Send Test" result in DB Error: Unknown Error. This isn't creating any error logs in my Drupal reports -- although other Civi errors do.
  
  Also worth noting: The drafts ARE in fact saving in my draft mailings section. However test emails are not sending.
  
  I have made sure to enter a recipient group, which has historically been the glitch here, but with everything filled out, same error.
  
  One note: my Drupal installation is unhappy that civicrm\_install\_canary does not have a primary key. This table seems to be empty, may I delete it? Not sure if this is related to my mail problem or totally distinct, but wanted to mention it.
  
  Thanks in advance!
  -tiffani
  
  **Tags:** civimail
  
  > **Comments:**
  > **username_1**: what are your settings at /civicrm/admin/setting/smtp?reset=1  
  > **username_0**: Allow mail from logged in contact YES Select mailer: mail()  
  > **username_2**: You can ignore the canary warning, but don't delete the table. In recent drupal installs you're likely to have the isolation set to something that will work in a basic civi install, but has this warning. See https://www.drupal.org/docs/getting-started/system-requirements/setting-the-mysql-transaction-isolation-level. You can add an arbitrary primary key to the table though to make the warning go away.  
  > **username_2**: Are you able to send a "regular" email as opposed to a bulk mailing, e.g. Contacts - New Email?  
  > **username_0**: I can!  Individual email works.  
  > **username_0**: Also, thank you.  I designated the ID column as the primary key for the canary table and that solved the error.  
  > **username_1**: will one of you add the above as an Answer  
  > **username_0**: @peterdnz -- I've solved the canary table part, but not the Civimail part.  Anyone have thoughts on that?  I can send groups of 50 through regular mail, but whenever try to send through Civimail I get the "DB error" dropdown.  Same response when I try to send a draft.   Is this something in my Civimail settings if the regular mail function is working? Thanks!  
  
  ---
  
  ## 0 answers
  
  