Answers.Body: <p>I reran cv api System.utf8conversion and now it works.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-01-09T16:33:12.727Z
Answers.LastActivityDate: 2023-01-09T16:33:12.727Z
Answers.UserDisplayName: Alan Dixon
Body: <p>For a recently updated CiviCRM 5.56.2 + Drupal 7 (using mariadb 10.3), I got the little black box with the message &quot;DB Error: unknown error&quot; popping up when trying to send a mosaico civimail (e.g. as a test).</p>
  <p>Weirdly, there was nothing helpful in the CiviCRM error log or the Drupal error log, or the sql error log or the apache error log!</p>
  <p>I eventually discovered the error message in the browser console, which now makes some sense (since mosaico does a whole whack of js api stuff).</p>
  <p>The error was hard to figure out because it was full of a long string it had pulled out of the civicrm_mailing table, but if I look far enough, I can see this:</p>
  <pre><code>Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=']&quot;,&quot;type&quot;:&quot;DB_Error&quot;
  </code></pre>
  <p>I'm not seeing this in other updated sites (or at least, not yet ...), and I had run</p>
  <pre><code>cv api System.utf8conversion
  </code></pre>
  <p>Anyone with a similar experience or clue?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-01-09T16:19:24.060Z
Comments.Text: The api call doesn't update extension tables if they don't start with `civicrm`. If that's the problem, then you need to add the `patterns=table1,table2` parameter.
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-01-09T21:02:18.383Z
Comments.Text: Good point, though not this issue.
Comments.UserDisplayName: Alan Dixon
Tags: <database><mysql><mosaico>
Title: DB Error: unknown error when trying to send mosaico civimail
ThreadText: # DB Error: unknown error when trying to send mosaico civimail
  
  (Asked by: username_0 on 2023-01-09)
  
  For a recently updated CiviCRM 5.56.2 + Drupal 7 (using mariadb 10.3), I got the little black box with the message "DB Error: unknown error" popping up when trying to send a mosaico civimail (e.g. as a test).
  
  Weirdly, there was nothing helpful in the CiviCRM error log or the Drupal error log, or the sql error log or the apache error log!
  
  I eventually discovered the error message in the browser console, which now makes some sense (since mosaico does a whole whack of js api stuff).
  
  The error was hard to figure out because it was full of a long string it had pulled out of the civicrm\_mailing table, but if I look far enough, I can see this:
  
  ```
  Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=']","type":"DB_Error"
  
  ```
  
  I'm not seeing this in other updated sites (or at least, not yet ...), and I had run
  
  ```
  cv api System.utf8conversion
  
  ```
  
  Anyone with a similar experience or clue?
  
  **Tags:** database, mysql, mosaico
  
  > **Comments:**
  > **username_1**: The api call doesn't update extension tables if they don't start with `civicrm`. If that's the problem, then you need to add the `patterns=table1,table2` parameter.  
  > **username_0**: Good point, though not this issue.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2023-01-09. Score: 1
  
  I reran cv api System.utf8conversion and now it works.
  
  
  ---
  
  