Body: <p>I choose the Export PRIMARY fields when export a participant, I always get the error &quot;DB Error: unknown error&quot; after click the Continue button at step  2. Export Options.</p>
  <p>I open the debug log and got the errors message like the below image. Is there any way to fix it?</p>
  <p><a href="https://i.sstatic.net/lrlnx.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/lrlnx.png" alt="enter image description here" /></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-09-29T10:38:12.503Z
Comments.Text: Can you add detail about the unknown error? You should see the error details down the line or in CiviCRM log
Comments.UserDisplayName: Pradeep Nayak
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-09-29T19:26:03.523Z
Comments.Text: Does it work if you do not use the Primary Fields option. otherwise you may need the utf8mb4 conversion fix refer https://lab.civicrm.org/dev/core/-/issues/2784#note_63447
  https://lab.civicrm.org/dev/core/-/issues/2780 and https://github.com/civicrm/civicrm-core/pull/21239
Comments.UserDisplayName: petednz - fuzion
Tags: <export><participants>
Title: Cannot export Participants - DB Error: unknown error
ThreadText: # Cannot export Participants - DB Error: unknown error
  
  (Asked by: username_0 on 2021-09-29)
  
  I choose the Export PRIMARY fields when export a participant, I always get the error "DB Error: unknown error" after click the Continue button at step 2. Export Options.
  
  I open the debug log and got the errors message like the below image. Is there any way to fix it?
  
  [![enter image description here](https://i.sstatic.net/lrlnx.png)](https://i.sstatic.net/lrlnx.png)
  
  **Tags:** export, participants
  
  > **Comments:**
  > **username_1**: Can you add detail about the unknown error? You should see the error details down the line or in CiviCRM log  
  > **username_2**: Does it work if you do not use the Primary Fields option. otherwise you may need the utf8mb4 conversion fix refer https://lab.civicrm.org/dev/core/-/issues/2784#note_63447 https://lab.civicrm.org/dev/core/-/issues/2780 and https://github.com/civicrm/civicrm-core/pull/21239  
  
  ---
  
  ## 0 answers
  
  